Host is not allowed to connect to this mysql server when making a local connection

database, mysql, putty

Solution

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 <username>@'%' IDENTIFIED BY '<password>';`

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

Problem

Original source