Shulou(Shulou.com)06/01 Report--

This article mainly introduces the solution that mysql can not be connected remotely, which is very detailed and has certain reference value. Friends who are interested must finish reading it!

Mysql can not connect to the remote solution: 1, open the command prompt, log in to mysql;2, execute [grant all privileges on *. * to root@ "ip" identified by "password] command to give remote access; 3, refresh permissions.

Solution:

First open a command prompt and execute the mysql-u root-p command

Then execute grant all privileges on *. * to root@ "xxx.xxx.xxx.xxx" identified by "password"; the command gives IP-xxx.xxx.xxx.xxx all permissions, including remote access.

Finally, execute the flush privileges; command to refresh the permissions.

These are all the solutions that mysql can't connect remotely. Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.