Unable to connect to the new mysql third-party tool
Mysql cannot be connected from the client to the server. The company uses Mysql for a test and starts to build a local Mysql database and connect it to it. No connection failure has been encountered.
When the database is on the server, the connection from the local client is rejected.
ERROR 1130: Host '123456. 168.5.3 'is not allowed to connect to this MySQL server www.bkjia.com after checking the information, this problem is usually encountered. The Mysql database is different from other databases, you need to set permissions to control which machine can access the database and which tables can be accessed. Therefore, You need to log on to the server. C: \ Documents ents and Settings \ Administrator> mysql-h localhost-u root-p Enter password: *** Welcome to the MySQL monitor. commands end with; or \ g. your MySQL connection id is 5 Server version: 5.1.43-community MySQL Community Server (GPL) Type 'help; 'or' \ H' for help. type '\ C' to clear the current input statement. www.bkjia.com mysql> grant all privileges on *. * to root @ '%' identified by '000000' w Ith grant-> option; Query OK, 0 rows affected (0.00 sec) means to grant all resources on the server to the root user, % indicates that the password must be included here. Log On with the password 123. Mysql> flush privileges; Query OK, 0 rows affected (0.00 sec. In this way, the client with the IP address 192.168.5.3 is connected to the server.