How to setup Apache, MySQL, PHP on CentOs

[Maxwell]

I've just bought a new VPS for checking, just want to know what are your easy ways to setup Apache, MySQL, PHP on CentOs?

Any tips

 

[ironcladservers]

Easiest way? Probably set up XAMPP @ apachefriends.org

Other than that you can use CentOS standard packages to install PHP/MySQL and such things, using 'yum' for example.

 

[yestyle]

I've just bought a new VPS for checking, just want to know what are your easy ways to setup Apache, MySQL, PHP on CentOs?

Any tips

Hello Maxwell, I installed and configured for a vps in the past hence I can give you easy tips to setup what you need, follow my instructions
First, you need to nstall Apache then type the follow command

sudo yum install httpd

after running for a while it will ask you "want to install package?", press Y and Enter.
restart Apache with code

sudo service httpd start

Install MySQL for CentOS 6

sudo yum install mysql-server

Restart Mysql

sudo service mysqld start

Now you need to set password for MySQL with command:

sudo /usr/bin/mysql_secure_installation

Enter current password for root (enter for none):
Type your password to make changes

Install Php and MySQL, you type these codes

sudo yum install php php-mysql

Restart server for PHP

Sudo service httpd restart

Ok you finished installations for LAMP (Linux, Apache, MySQL, PHP).
You need to have 2 these codes to run services automatically when rebooting

sudo chkconfig httpd on 
sudo chkconfig mysqld on

Hope it helps

 

[Maxwell]

@yestyle, Thanks for the tips but after install mysql completely, I'd like to install database for it, how to do?

 

[yestyle]

yestyle

Ok, now you will login into mysql to create database

mysql -u root -p

Using your username and password
For example, you have database with information follow

Database Name: myblog
Database User: myusername
Database Password: mypassword

Create a databse

CREATE DATABASE myblog;

and creating database user

CREATE USER myusername;

Set password for my username above

SET PASSWORD FOR myusername= PASSWORD("mypassword");

Grant privileges to a database user

GRANT ALL PRIVILEGES ON myblog.* TO myusername IDENTIFIED BY 'mypassword';

Refresh your MySQL by command

FLUSH PRIVILEGES;

and finally, exit MySql

exit

You have your database name, username and password. It's easy for you to create/install blog or website with this database.
If you have any questions, let me know
Good luck!

 

[jackdolphin]

After install mysql, remember to run mysql_secure_installation for security.

 

[Maxwell]

Maxwell

what is it? can you show me the details or codes?