New mysql third-party tools cannot be connected, mysql third-party
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.2cto.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.2cto.com mysql> grant all privileges on *. * to root @ '%' identified by '000000' wi Th 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.
How can I use a tool to connect to the mysql database?
Don't you remind me: The self-opened server cannot be connected.
Try to use the mysql command line to connect and handle the problem as prompted. Generally, you need to open the required port and set the user's remote connection permission to connect. If the command line can be connected, the tool should also be OK.
If you only want to manage the database, you can install a web management server, which is quite convenient.
When the website is installed on the service, it is displayed that Mysql cannot be connected ??
Port 3306 cannot be connected by default .... Can ping?
The rest is that you use root, So what permissions do you grant to root on your server? The IP address is also specified ???
It is estimated to be an ip address. You can check all permissions.