mysql服务器连接不上本地主机,在进行本地连接时，不允许主机连接到此mysql服务器...

When I try to connect with putty I get 'host is not allowed to connect to this mysql server'. Why is that happening? Host and client are on my machine.

When I connect with the command line it connects.

解决方案

You need to change how your configuration is set up.

Comment out the skip-networking section within your MySQL config: # skip-networking, if you have skip-networking it will discard any TCP/IP connection which is likely why your failing.

Once you have enabled your TCP/IP connections you will need to grant permission to your user to connect from other machines:

GRANT ALL PRIVILEGES ON *.* TO @'%' IDENTIFIED BY '';

This will let username connect from any machine to your database with the appropriate password.