Connection failed: Host 'xxx.xxx.xx.xxxx' is not allowed to connect to this MySQL server

June 7, 2019 600 views
MySQL Databases Ubuntu 18.04

Hello, can anyone help me with this issue?

Connection failed: Host 'xxx.xxx.xx.xxxx' is not allowed to connect to this MySQL server

1 Answer

Hi, mysql supports per host permissions which means that your database user must have permission to be able to connect from IP "xxx.xxx.xx.xxxx".

Here is the relevant mysql documentation:

https://dev.mysql.com/doc/refman/5.7/en/access-control.html

More specific to your issue, this sub-section details how it compares the user and the host the user is connecting from:

https://dev.mysql.com/doc/refman/5.7/en/connection-access.html

This stackoverflow answer has a good overview on making sure you can access your mysql database remotely, including example configs and permission statements:

https://stackoverflow.com/a/32716003

Good luck!

Have another answer? Share your knowledge.