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

This article will explain in detail the methods of authorizing remote access by navicat. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

Navicat for MySQL is a commonly used database management software for MySQL database, which supports a single program and can be connected to MySQL and MariaDB at the same time. This fully functional front-end software provides an intuitive and powerful graphical interface for database management, development and maintenance, so how to use this software to remotely access MySQL databases?

1. Create a new connection and set the connection information. Just enter the host ip address that requires a remote connection at the hostname / IP address.

But using Navicat directly to connect via IP will report various errors, such as Error 1130: Host '192.168.1.80' is not allowed to connect to this MySQL server.

1. First log in to the database that you want to connect remotely using localhost

2. Open a command prompt window and enter the following command:

Mysql > grant all privileges on *. * to 'root'@'%' identified by' 123456 'with grant option;Query OK, 0 rows affectedmysql > flush privileges;Query OK, 0 rows affected

The first sentence is that given the permission of the remote connection, you only need to set the user name and password of the connection according to the root and 123456 in the modification statement of the personal database.

The second sentence is to refresh the database so that permissions take effect immediately.

3. In general, you can connect to the database remotely, but sometimes the following error occurs: 2003-Can't connect to MySQL server on '192.168.1.80' (10038).

The error is that the firewall of the server (the server is the win7 system) intercepts your connection. Then turn off the firewall and you can connect.

Use the cmd command to connect to the remote database and do not want to use any tools to connect to the remote database.

I made a mistake on the command line. ERROR 2003: Can't connect to MySQL serveron "192.168.1.80"

The reason for this error is the same as above, which is blocked by the firewall.

PS: turn off WIN7 Firewall not only under the control panel, but also in the service

This is the end of this article on "the method of navicat authorizing remote access". I hope the above content can be helpful to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

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.