Install a MySQL server on CentOS

2Fast2BCn

New member
Joined
May 27, 2016
Messages
10
Points
0
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:

Code:
yum install mysql-server
The command will ask for confirmation (the download is approximately 22 megs). Press "Y" to confirm

Install-a-MySQL-server-on-CentOS-1.jpg

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

Install-a-MySQL-server-on-CentOS-2.jpg

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 :

Code:
service mysqld start
As before, the system will have to show that everything went successful writing "OK" on the screen.

Install-a-MySQL-server-on-CentOS-3.jpg

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:

Code:
/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

Install-a-MySQL-server-on-CentOS-4.jpg

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

Install-a-MySQL-server-on-CentOS-6.jpg

Press the Y key and Enter

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

Install-a-MySQL-server-on-CentOS-8.jpg

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

Install-a-MySQL-server-on-CentOS-7.jpg

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!
 
Older threads
Newer threads
Replies
1
Views
1,857
Replies
33
Views
10,145
Replies
9
Views
7,383
Latest threads
Replies
2
Views
368
Replies
1
Views
366
Replies
4
Views
1,888
Replies
3
Views
794
Recommended threads
Replies
16
Views
14,186
Replies
3
Views
1,916
Replies
23
Views
10,294
Replies
8
Views
5,216

Referral contests

Referral link for :

Sponsors

Popular tags

You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.

Top