How to remotely connect to MySQL database with Navicat Premium

The party that creates a new connection is equivalent to the client, and the one being connected is equivalent to the server. The steps are as follows:

1. Create a subaccount and type the following authorization commands in the Navicat query interface and execute them in sequence:

GRANT ALL PRIVILEGES
ON test.* to 'root333'@"%"
IDENTIFIED by 'abc111' WITH GRANT OPTION;

FLUSH PRIVILEGES;

• all PRIVILEGES means all permissions;
• on is followed by the database name. For example, test.* means that the permissions granted are for all tables under the database test. *.* means that any table in any database is authorized.
• The "to" after the "to" is the username granted to that computer. The "root333" before the "@" symbol represents the subaccount name, which is the "user name" when connecting to the MySQL server later. The "@" symbol after the "@" symbol is the IP address of the computer granted to that computer. The "%" symbol represents any IP address.
• IDENTIFIED BY is followed by a password;
• FLUSH PRIVILEGES: Refresh permissions.

2. Create a new MySQL connection (1)

Connection name: choose your own Host: Enter the server host address you want to connect to Port: Default is 3306
Username: The subaccount name before the @ symbol in authorization 1 Password: The password after IDENTIFIED BY in authorization 1 (2) Click "Test Connection"

The "Connection successful" pop-up message indicates that the connection is successful. Now we can operate the database on the corresponding server.

3. To delete sub-user permissions, type

DELETE FROM mysql.`user` where User='username' AND Host='IP';

Username: The subaccount name set during authorization
IP: represents the IP address of the computer, and % represents all. At this time, if you try to connect using a sub-account, you will be prompted that the connection is rejected.

This is the end of this article about how to use Navicat Premium to remotely connect to a MySQL database. For more information about how to use Navicat Premium to remotely connect to a MySQL database, please search for previous articles on 123WORDPRESS.COM or continue browsing the following related articles. I hope you will support 123WORDPRESS.COM in the future!