Remote Access to Mysql on Linux

Remote Access to Mysql on Linux solution Description: the server is deployed in the Debian system and can use Mysql normally on the server side. However, when remotely connecting to Mysql, the system prompts errors such as 10061, and so on.
Solution: 1. Modify/etc/init. d/my. in the cnf file, change "bind-address = 127.0.0.1" to "bind-address = 0.0.0.0" to allow all IP addresses to access www.2cto.com 2, modify the user table using mysql-u root-p <ENTER> ENTER the password use mysql <ENTER> select user, host from user; <ENTER> the following result is displayed: using mysql> select user, host from user; + ------------------ + ----------- + | user | host | + ------------------ + ----------- + | Root | 127.0.0.1 | root | debian-sys-maint | localhost | root | localhost | + ------------------ + ----------- + 4 rows in set (0.00 sec) www.2cto.com modify localhost in the last line to % update user set host = "%" where user = "roor" and host = "localhost"; <ENTER> 3, restart mysql service/etc/init. d/mysql restart <ENTER> solution: After configuring the preceding steps, the remote test can connect to the database and. Author Magoo