Install MySQL using yum under CentOS6.8 and log in to MySQL remotely

1th step, see if MySQL is installed under CentOS

Input command: Yum List installed | grep MySQL

2nd step, remove installed MySQL

Input command: yum-y remove MySQL

Seeing complete means success.

3rd step, view MySQL in the Yum Library (not required)

Input command: Yum List | grep MySQL

4th step, installing MySQL from the Yum Library

Input command: yum-y install MySQL Mysql-server

5th step, start the MySQL service

Input command: Service mysqld start

6th Step, Change password

mysql > Use MySQL;
MySQL > Update user set password= ' 123456 ' where user= ' root ';

7th Step, open Telnet permission

Input command: GRANT all privileges on . To ' root ' @ '% ' identified by ' your password ' with GRANT OPTION;
FLUSH privileges;

8th step, set boot boot (not required)

Chkconfig mysqld on

Install MySQL using yum under CentOS6.8 and log in to MySQL remotely