How to solve Navicat error 10441045 when installing Navicat in Mysql
BitsCN. comin Navicat for MySQL, PostgreSQL and Oracle
The error occurs because the mysql account does not have sufficient permissions to connect to the remote mysql server.
After mysql is installed, only "localhost" connections are allowed by default. Therefore, most script programs on the server can easily connect to the local database on the local server. The client computer is blocked by the remote server until user permissions are configured.
If you want to access the remote mysql server from your desktop, you must first know the permissions for the mysql system to work.
User information is stored in the user, db, host, tables_priv, and columns_priv tables named "mysql. When the mysql server is started, read the contents of these tables.
MySQL access control involves two phases:
1. the server checks that your desktop (host address or IP address) is accessible.
2. suppose you can connect to the server and check each request to see if you have sufficient permissions to execute it. For example, create a table, delete a table, or modify a table.
The MySQL server uses the User, Db, and Host tables of the MySQL database for access control in two phases.
If your remote server supports SSH connection, your Navicat will be able to connect to the remote MySQL database through the SSH tunnel without any modification to the existing MySQL permission settings. The main advantage of SSH in this tunnel is that it allows us to connect to the port blocked by the firewall on the MySQL server from the back,
Procedure:
You can run the following command at the MySQL server command prompt. Consult your database administrator because they usually have the permission to set permissions.
Grant all privileges on *. * TO 'yourusername' @ '%' identified by "YourPassword ";
Or
Grant all privileges on *. * TO 'yourusername' @ 'yourip' identified by "YourPassword ";
BitsCN.com