Some problems when using MySql in Redhat5

The first step is to start from remote connection failure, although indirectly encountering some problems. Find out the problem and summarize it. If the problem persists or has been resolved, I hope to reply to it! Remote connection error 1130 some user information is recorded in the mysql database table user. The host in the table specifies the clients that can access the database. If it is installed in Windows and the remote access is specified, this problem will not occur. The solution is to modify the access permission: After logging on to mysql, change the "host" column in the "user" table in the "mysql" database, and change it from "localhost" to "% '. Mysql-u root-pmysql> use mysql; mysql> select 'host' from user where user = 'root '; mysql> update user set host = '%' where user = 'root'; mysql> flush privileges; mysql> select 'host' from user where user = 'root '; log out and restart the mysql service! Author: cuisuqiang