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

This article mainly introduces the navicat database ip can not connect how to do, the article is very detailed, has a certain reference value, interested friends must read it!

We sometimes encounter this situation when using navicat. We can connect with localhost, but when using ip address, navicat will report an error and fail to connect.

Introduction to the question:

1. Localhost connection success:

2. The connection using ip is not successful:

Solution:

Enter mysql under windows:

C:\ WINDOWS\ system32 > net start mysqlC:\ WINDOWS\ system32 > mysql-uroot-p123456

123456 after PS:-p is the password of the database, pay attention to modify it.

Enter the following command under the mysql command line:

Mysql > use mysql

Give all ip remote connection permissions with the username root:

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

Update the configuration:

Mysql > flush privileges

After that, you can connect and manipulate the database remotely using tools such as navicat.

The above is all the contents of the article "what to do if the database ip in navicat is not connected". 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.