Install a MySQL server on CentOS

[2Fast2BCn]

MySQL is a relational database management system and using for free on all web systems from the open source CMS to the sites designed by small and large web companies, it was integrated to use with Apache, PHP. Today I want to share with you a quick guide to install MySQL on your Dedicated Server or VPS with the operating system installed CentOS .

Requirements:
servers running on CentOS.
basic knowledge to do via shell
about 15 minutes of time

Get Started

Step 1:
Connect to your VPS or dedicated and loged in your server.
Before you proceed, you need to know that all the commands are executed without the "sudo" prefix.
So in the system if you are using a user that is not the root, you'll have to add the "sudo" prefix to commands.

Step 2:
Install MySQL using the yum command. The command is as following:

yum install mysql-server

The command will ask for confirmation (the download is approximately 22 megs). Press "Y" to confirm



when finished it will appear in shell with a message: "Complete!"



Step 3:
Perfect! MySQL is properly installed on our servers. Now it's time to start the main MySQL services.

The necessary command is as following :

service mysqld start

As before, the system will have to show that everything went successful writing "OK" on the screen.



Step 4:
Configure the root password of MySQL.
Such as your operating system, MySQL also has its root. You also can set your own password if wanted.
To set the root password for MySQL, you must use the following command:

/usr/bin/mysql_secure_installation

Following this command prompts you to enter your root password. For the first run, you enter to create a blank password



The system will ask you at this point: Set root password? [Y/n]



Press the Y key and Enter

At this point you will set your own password and must enter the password twice.



The system will proceed by asking a few questions that will be appeared and you should press "Y" to proceed to the next.



After completing this step will show the message:

All done! If you've completed all of the above steps, your MySQL
installation should now be secure.

Thanks for using MySQL!

That's all. Your MySQL configuration is successful!