MySQL How to open remote connections

Original Address http://www.cnblogs.com/linjiqin/p/5270938.html

Configure MySQL to allow remote connection methods

By default, MySQL only lets you log on locally, and if you want to turn on remote connections, you need to modify the/etc/mysql/my.conf file.

I. Modification of/ETC/MYSQL/MY.CONF
Find bind-address = 127.0.0.1 this line
Change to bind-address = 0.0.0.0

Ii. granting permissions to users who need to log on remotely
1. New user remote connection MySQL database
Grant all on * * to [e-mail protected] '% ' identified by ' 123456 ' with GRANT option;
Flush privileges;
A computer that allows any IP address (% to allow any IP address) to access this MySQL server with the admin account and password (123456).
Note that the admin account does not have to exist.

2, support the root user to allow remote connection to MySQL database
Grant all privileges on * * to ' root ' @ '% ' identified by ' 123456 ' with GRANT option;
Flush privileges;

Third, view system users

MySQL How to open remote connections