Two ways to resolve MySQL remote connection failure

---restore content starts---

(This is reproduced others, because I think it is very useful, each time is the reference to the second method to solve, whether you can not hear, first say thank you!) Also remember to make it easy for everyone to see)

MySQL solves two kinds of methods that cannot be accessed remotely, and needs a friend to refer to:

1, in the/ETC/MYSQL/MY.CNF [MYSQLD] paragraph commented out bind-address = 127.0.0.1
2, log in with Mysql-uroot-p MySQL, and then use the following methods to open remote access permissions:

Method 1:mysql>use MySQL;
Mysql>update User Set host = '% ' where user = ' root ';
Mysql>flush rivileges;

Method 2:mysql>grant all privileges on * * to ' myuser ' @ '% ' identified by ' MyPassword ' with GRANT OPTION;

Reproduced original address: http://www.jb51.net/article/35267.htm

---restore content ends---

Two ways to resolve MySQL remote connection failure