Shulou(Shulou.com)06/01 Report--

The following brings you about the CentOS6.8 system using yum source to install mysql and achieve remote login mysql, if you are interested, let's take a look at this article, I believe that after reading the CentOS6.8 system using yum source to install mysql and achieve remote login mysql to you more or less helpful.

Step 1: check whether mysql is installed under CentOS

Enter command: yum list installed | grep mysql

Step 2, delete the installed mysql

Enter the command: yum-y remove mysql

Seeing complete means it's a success.

Step 3, view the mysql in the yum library (optional)

Enter command: yum list | grep mysql

Step 4, install mysql from the yum library

Enter the command: yum-y install mysql mysql-server

Step 5, start the MySql service

Enter command: service mysqld start

Step 6, change the password

Mysql > use mysql

Mysql > update user set password='123456' where user='root'

Step 7: open remote login permissions

Enter the command: GRANT ALL PRIVILEGES ON. TO 'root'@'%' IDENTIFIED BY' your password 'WITH GRANT OPTION

FLUSH PRIVILEGES

Step 8, set boot (optional)

Chkconfig mysqld on

Read the details above about CentOS6.8 system using yum source to install mysql and achieve remote login mysql, whether there is anything to gain. If you want to know more about it, you can continue to follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.