Client Issue:

I’m having difficulty connecting to my MySQL db. I’m fairly sure I have the correct username and password. For the host, I just used my server’s IP and for the Port, I have 3306. When I try to connect, I receive the following error…

MySQL Error Number 1130
Host ‘<IP address>’ is not allowed to connect to this MySQL server.

Resolution:

In addition to allowing your IP in WHM, you have to create a new user account on your mysql server with a host specification that will allow you to connect. you can do this in phpmyadmin. In WHM->SQL Services->PHPMyAdmin->Privilidges->add a new user
Create a new mysql user with a very strong password under options:Database for user, Grant all privileges on wildcard name (username\_%) Select all Global Priviledges. Hit Go, and now you should be able to connect to this account using tools like Navicat.