This post is the second in the series of setting up a Centos 6.5 VPS without WHM/cPanel (or any other panel). The first post is setting up Apache web server. This post will list the steps to install MySQL and PHP
The version installed will be the latest GA version of MySQL (at the time of writing this post, this is version 5.6).
Install MySQL
First, download the MySQL Yum Repository rpm package.
cd /usr/src
wget http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
Then, install the rpm package.
yum localinstall mysql-community-release-el6-5.noarch.rpm
Next, install MySQL server using the following command.
yum install mysql-community-server
Run the server.
service mysqld start
The default MySQL installation allows access to the server without password. It also contains the test database server. In other words, it’s not secure. To secure the MySQL server, run the following command and follow the prompts that will guide to secure the server.
mysql_secure_installation