In Navicat for Mysql,postgresql and Oracle
The error occurred because the MySQL account does not have sufficient permissions to connect to the remote MySQL server.
Only "localhost" connections are allowed by default after MySQL installation. Therefore, most server-side scripting programs can easily connect to local databases on local servers. The client computer is blocked by the remote server until the user right is configured.
If you want to access a remote MySQL server from your desktop, you first need to know the permissions of the MySQL system to work.
User information is stored in the user, DB, host, Tables_priv, and Columns_priv tables named "MySQL" database. Read the contents of these tables when the MySQL server starts.
MySQL access control involves two stages：
1. The server checks your desktop (host address or IP address) is allowed to connect.
2. Suppose you can connect, the server checks each request to see if you have sufficient permissions to execute it. For example, you create a table's permissions, delete a table's permissions, or modify the table's permissions.
The MySQL server accesses the user, Db, and host tables in the two-stage access control using the MySQL database.
If your remote server supports an SSH connection, your navicat will be able to connect to the remote MySQL database via an SSH tunnel without making any changes to the existing MySQL permission settings. The main advantage of SSH for this tunnel is that it allows us to connect from behind to the port that the MySQL server is blocked by the firewall.
Steps：
You can run the following command at a command prompt at the MySQL server. Consult your database administrator because they typically have administrative rights to set permissions.
Copy Code code as follows:
GRANT all privileges on *.* to ' yourusername ' @ '% ' identified by ' YourPassword ';
Or
Copy Code code as follows:
GRANT all privileges on *.* to ' yourusername ' @ ' Yourip ' identified by ' YourPassword ';
