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

Editor to share with you how to solve the problem that ip is not connected to mysql. I believe most people don't know much about it, so share this article for your reference. I hope you can learn a lot after reading this article. Let's learn about it together.

The way to solve the problem that ip cannot connect to mysql: first execute the command "grant all privileges on *. * to 'username' @'IP address' identified by 'password' in the Navicat tool; then refresh the permissions.

MySQL native IP cannot be connected, but can be connected with localhost and 127.0.0.1. | solution

1. Use the command in the Navicat tool or in other tools: (all 'single quotes are removed)

Grant all privileges on *. * to 'username' @'IP address' identified by 'password'

two。 After executing the above command, refresh the permissions with the following command

Flush privileges

Specific description:

All privileges: all permissions can also be written as select, update, etc.

*. *: all tables of all libraries, such as databasename.*

User name: the user name that needs to log in

IP: the IP address of the database

Identified by 'password' means to connect by password

The above is all the content of the solution to the problem that ip can not connect to mysql. Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more 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.