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

This article mainly introduces "what to do if MYSQL cannot be connected remotely". In daily operation, I believe that many people have doubts about how to connect remotely with MYSQL. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful for you to answer the doubt that "MYSQL can not connect remotely." Next, please follow the editor to study!

ERROR 1130: Host '192.168.1.3' is not allowed to connect to this MySQL server

Solution:

Change the meter. It may be that your account is not allowed to log in remotely, only in localhost. At this time, just change the item "host" in the "user" table in "mysql" from "localhost" to "%" after logging in to mysql on the computer in localhost.

Www.2cto.com

-u root-pvmwaremysql > use mysql

Mysql > update user set host ='% 'where user =' root'

Mysql > select host, user from user

Finally, restart the MYSQL service.

At this point, the study on "what to do if MYSQL cannot be connected remotely" is over. 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.