MySQL default is to turn off remote links, only through the
localhostAccess the local database if it is not local access you need to open MySQL remote connection; The basic steps are simple: 1. Go to MySQL
2. Run the following command (Yellow for command) in turn:mysql>Use
MySQL;
mysql>
select Host,user,password from user;
mysql>
Update user set host= '% ' where user= ' root ';mysql>
flush Privileges;mysql>
quit;
3, through the CMD, into the MySQL installation directory, restart MySQL (bold for the installation directory, yellow for the command):
D:\Program files\mysql-5.5.25\bin>
net stop mysql The MySQL service is stopping.The MySQL service has stopped successfully.
D:\Program files\mysql-5.5.25\bin>
net start MySQLThe MySQL service is starting.The MySQL service has started successfully.
4. Go to MySQL and run the following command (yellow for the command, where YourPassword is replaced with your MySQL password):mysql>
Grant all privileges on * * to ' root ' @ '% ' identified by 'YourPassword
' with GRANT option;mysql>
flush Privileges;
to successfully open the MySQL remote link feature! (Note: I'm sure you can all see if the command is performing properly, so don't add the command when it's running ...) )Reference:http://jingyan.baidu.com/article/60ccbceb05804164cab1978c.html
From for notes (Wiz)
MySQL open remote link (2014.12.12)
