search

hankinsoft / SQLPro

SQLPro bug & features tracking.
100 stars 26 forks source link

Host 'xxx' is not allowed to connect to this MySQL server. (Error #1130) #962

Closed vvruan closed 4 months ago

vvruan commented 4 months ago

I just downloaded sqlpro for mySQL.

After I entered host address, username and password and clicked 'connect', it shows Host 'xxx' is not allowed to connect to this MySQL server. (Error #1130). -- xxx is my ip address.

How can I change my system setting to make successful connection? Many thanks!

hankinsoft commented 4 months ago

You will need to configure mysql to allow your current ip address. https://stackoverflow.com/questions/8348506/grant-remote-access-of-mysql-database-from-any-ip-address is an example of how to do this, but your mysql provider should have some details as well.