Configure MySQL under CentOS to allow root users to Telnet

1. Common commands:

Install upload download File command
Yum Install Lrzsz
Installing the WebGet tool
Yum-y Install wget

------------------------------------Split Line---------------------------------------------

After successfully installing MySQL server on CentOS, we found that we could not connect with clients, and found out that if you want root users to support remote login, additional configuration is required , and the configuration steps are as follows:

Steps: to change the root password (optional)

# switch to MySQL this database mysql> use mysql;# change the root user's password to:123456mysql> update user set Password=password (' 123456 ') where user= ' root ';

　　

　Check the root configuration

# root User Login $ mysql-u root-p# switch to mysql this database mysql> use mysql;# view root User Configuration mysql> Select Host,user from user where user = ' root ';

　　Modify the root configuration

If the query results do not contain the following records, add, otherwise ignore the steps hostuser%rootmysql> Update user set host = '% ' where user = ' root ' and host= ' 127.0.0.1 ';

　　Authorization to the user

Mysql> Grant all privileges on * * to ' root ' @ '% ' identified by ' 123456 ' with GRANT option;

　　Make configuration effective

mysql> flush Privileges;

　　

Configure MySQL under CentOS to allow root users to Telnet