Set up MySQL on Centos 6.5

By | 6 September 2014

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

Leave a Reply

Your email address will not be published. Required fields are marked *