When you use the Navicat for mysql client to connect to a remote mySql database, the system may prompt 2003-Can't connect to MySQL on '100. 210.102.21 '(10061). How can I solve this problem?
In fact, this problem occurs because MySQL does not allow remote connection. The solution is as follows:
1: Find the my. ini file in the MySQL folder on the server. Modify bind-address = 127.0.0.1 to bind-address = 223.210.102.21 (this item is not found in my. ini of MySQL 5)
2: restart the MySQL service.
In addition, the error "1045-Access denied for user root @ IT (using password: NO)" will also be prompted during the connection test, the cause of this error is that the remote logon user is not authorized to access all machines. The corresponding solution is as follows:
To add permissions, run the following command:
Grant all on *. * to username @ "%" identified by "password ";
Flush privileges;
After completing the above two steps, your problem should have been solved. If the problem persists, please leave a message below.
Articles you may be interested in
- Navicat for mysql registration code
- Steps for synchronizing and backing up mysql Databases in windows
- Select into from prompt Undeclared variable... solution to the error
- Mysql Server master-slave Database Synchronization Configuration
- Mysql database cache function analysis, debugging, and performance summary
- PHP reports Fatal error Allowed memory size of... how should we solve the problem of insufficient memory?
- Performance Comparison of using in_array () foreach array_search () to find whether an array contains
- Rational use of MySQL database indexes to make the database run efficiently