Navicat and MySQL's story "A summary of MySQL server issues using Navicat remote connection installed on a virtual machine CentOS"

problem 1 : as shown

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M02/89/2C/wKiom1gJ0cmzs3t0AAA-lkYqVdQ504.png-wh_500x0-wm_3 -wmp_4-s_721336662.png "title=" 1.png "style=" Float:none; alt= "Wkiom1gj0cmzs3t0aaa-lkyqvdq504.png-wh_50"/>

Problem Tip:

1130-host ' localhost ' isn't allowed to connect tothis MySQL server

Fault Analysis: The following error occurred because a remote connection was not authorized by the MySQL server

Workaround:

Mysql> Grant all privileges on * * to [email protected] '% ' identified by ' 12345678 ' with GRANT option; Query OK, 0 rows Affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows Affected (0.00 sec)

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M02/89/29/wKioL1gJ0cnD1wtzAADkarIizNQ426.png-wh_500x0-wm_3 -wmp_4-s_2936630285.png "style=" Float:none; "title=" 2.png "alt=" Wkiol1gj0cnd1wtzaadkariiznq426.png-wh_50 "/>

problem 2 : As shown

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M00/89/2C/wKiom1gJ0cmj3QUNAAHyZZ9RDnI770.png-wh_500x0-wm_3 -wmp_4-s_1821439134.png "style=" Float:none; "title=" 3.png "alt=" Wkiom1gj0cmj3qunaahyzz9rdni770.png-wh_50 "/>

Problem Tip:

Navicat link remote database hint mysql connection error Can ' tconnect to MySQL server on IP (10060)

Problem Analysis :

The probable cause of the problem is:

(1) bind-address a limit to the connected IP

(2) The database user can only connect on the specified IP

(3) The system itself for remote access restrictions, the most common is: The network, the firewall may cause problems

Workaround :

This error occurs and the troubleshooting steps

(1) We first check the user's settings, you can see that the root user is allowed to connect any machine.

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M01/89/29/wKioL1gJ0cmyPD-WAABej6CRflg123.png-wh_500x0-wm_3 -wmp_4-s_3511988373.png "style=" Float:none; "title=" 4.png "alt=" Wkiol1gj0cmypd-waabej6crflg123.png-wh_50 "/>

(2) Check the configuration file,vi/etc/my.cnf , such as the discovery configuration file does not have bind-address settings, so you can determine the problem is not a profile. The rest is to check for network problems.

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M01/89/2C/wKiom1gJ0cvAQeTQAAMD3mpzzZc550.png-wh_500x0-wm_3 -wmp_4-s_2909038627.png "style=" Float:none; "title=" 5.png "alt=" Wkiom1gj0cvaqetqaamd3mpzzzc550.png-wh_50 "/>

(3) Check if the MySQL side Server firewall is open

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M01/89/29/wKioL1gJ0cvi1ltzAAI6imNibYU295.png-wh_500x0-wm_3 -wmp_4-s_1654814509.png "style=" Float:none; "title=" 6.png "alt=" Wkiol1gj0cvi1ltzaai6imnibyu295.png-wh_50 "/>

Shutting down the firewall

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M02/89/2C/wKiom1gJ0cvjoS8HAAC68aTEkHM239.png-wh_500x0-wm_3 -wmp_4-s_2484250503.png "style=" Float:none; "title=" 7.png "alt=" Wkiom1gj0cvjos8haac68atekhm239.png-wh_50 "/>

The connection was successful.

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M02/89/2C/wKiom1gJ0czS7gGGAAA9r62fEo0705.png-wh_500x0-wm_3 -wmp_4-s_678598670.png "style=" Float:none; "title=" 8.png "alt=" Wkiom1gj0czs7gggaaa9r62feo0705.png-wh_50 "/>

This article is from the "Persistent It Man" blog, please be sure to keep this source http://it3246.blog.51cto.com/7479386/1864314

Navicat and MySQL's story "A summary of MySQL server issues using Navicat remote connection installed on a virtual machine CentOS"