MySQL Remote Access cannot connect (10038) process of problem solving

Today, Navicat accesses MySQL on the virtual machine and cannot access the report cannot connect (10038).

First see if you can telnet, native cmd,telnet 192.168.209.128 3306, the result is a connection failure,

Confirm NETSTAT-ANP on the virtual machine and find "TCP 0 0 127.0.0.0:3306 0.0.0.0:* LISTEN"

(localaddress: 0.0.0.0 means listening on all local IP addresses, other computers are accessible, and modifying IP is not affected.) 127.0.0.1 indicates that only the native loopback address is being monitored and can only be accessed natively. x.x.x.x IP address, is only listening to this IP. The program will not be able to listen after modifying the IP. Need to manually modify the software listening address can be used)

Here localaddress is 127.0.0.0, which explains the problem here.

So, to/ETC/MYSQL/MYSQL.CONF.D, modify the to in the mysqld.cnf. bind-address = 127.0.0.1    bind-address = 0.0.0.0

Problem solved.

After that, only root can log in, but normal users log in to Access denied for user ' Shopsys ' @ ' 192.168.8.123 ' (using Password:yes)

View permissions separately:

Show grants for ' root ' @ '% ';
| GRANT all privileges on * * to ' root ' @ '% ' identified by PASSWORD ' *e995d71a1f13cce285e250b75338a9b93fe48c9b ' with GRANT OP tion |

Show grants for ' shopsys ' @ '% ';
| GRANT USAGE on * * to ' shopsys ' @ '% ' |
| GRANT all Privileges "Shopsys". * to ' shopsys ' @ '% ' |

The comparison is visible, the ordinary user does not have identified ....

Authorization action: Grant all privileges on * * to ' shopsys ' @ '% ' identified by ' 123456 ' with GRANT OPTION;

< Span class= "Apple-converted-space" > | GRANT all privileges on * * to ' shopsys ' @ '% ' identified by PASSWORD ' *84aac12f54ab666ecfc2a83c676908c8bbc381b1 ' with GRANT OPTION |
| GRANT all Privileges "Shopsys". * to ' shopsys ' @ '% '                                                                                   |

Reference: http://www.cnblogs.com/cnblogsfans/archive/2009/09/21/1570942.html

MySQL Remote Access cannot connect (10038) process of problem solving