"MySQL" setting allows users to Telnet

Yesterday the basic system was deployed on the server, everything is OK .

However, the developer to remote access to the MySQL database on the server, found that root remote connection is not, prompting the error :"1045-access denied for user [email protected] ... "

The workaround is as follows, execute the command:

mysql> use MySQL;

Mysql> selecthost,user from user;

view result is not root user only allow local (localhost) login , Here's the situation . .

Yes, , It's going to be modified. Host to be %, represents any IP address can be logged in .

mysql> Update user set host = '% ' where user = ' Root ';

may prompt when finished executing error. then mysql> select Host,user from user; check it out. .

Root corresponding to the Host Become a %, indicates that you can arbitrarily IP address is logged in. .

Mysql> flushprivileges;

flush out the cache . . after modifying a user record with the UPDATE statement, the FLUSH statement is required to tell the server to overload the authorization table .

"MySQL" setting allows users to Telnet