Shulou(Shulou.com)05/31 Report--

This article mainly introduces "mysql remote can not log in ERROR 2003 (HY000) how to solve", in the daily operation, I believe that many people in the mysql remote can not log in ERROR 2003 (HY000) how to solve the problem, Xiaobian consulted all kinds of information, sorted out a simple and easy-to-use method of operation, hope to answer the "mysql remote unable to log in ERROR 2003 (HY000) how to solve" doubt! Next, please follow the editor to study!

Q: the following error occurred when logging in to MySQL on another machine:

ERROR 2003 (HY000): Can't connect to MySQL server on 'x.x.x.x'

A: the reason is that MySQL takes security into account and the default configuration only allows you to log in locally

Open the / etc/mysql/my.cnf file and find bind-address = 127.0.0.1 and change it to bind-address = 0.0.0.0

Restart mysql: sudo / etc/init.d/mysql restart

Please refer to:

> I've already check my / etc/my.cnf file for a "binding"

> line. Its not

> there. I also found an item online that indicated

> adding:

>

Look for the option "skip-networking". This disables TCP/IP so the

Server only accepts local connections via the Unix socket. This sounds

Like your situation.

Note that a "could not connect" error means just that. If the problem

Was related to user privileges you would get an "access denied" error.

Q: there is also an error similar to the following:

ERROR 1045 (28000): Access denied for user (using password: NO)

A: the reason is that the login user name is not set to log in to the remote host.

Log in locally with root: mysql-u root-p

Modify the Host field of the corresponding user name in the user table in MySQL, and change the localhost to%

Use

Update user set Host ='% 'where User =' username'

At this point, on the "mysql remote login can not appear ERROR 2003 (HY000) how to solve" on the end of the study, I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.