Mysql remote client connection failure

The remote mysql client cannot be connected. By default, the installed mysql cannot be accessed remotely, mainly due to the following two reasons: www.2cto.com 1. the mysqld service does not monitor IP addresses that can be remotely accessed. Solution: Modify the mysqld startup parameters (or my. cnf), comment out bind-address = 127.0.0.1 in the [mysqld] section, or modify it to an accessible IP address. Services mysql restart; 2. The account used for client connection has no permission. View mysql. the user table shows all accounts and the HOST configurations available for access, and checks whether the account used has the access permission on the current client (IP, if not, you can use the following statement: SQL code GRANT ALL PRIVILEGES ON *. * TO 'root' @ '%' identified by '000000' with grant option;