Home / server / Questions / 571993
Accepted
lucasmx
Asked: 2014-02-04 18:37:11 +0800 CST

Cant connect remotelly to MySQL Server from DigitalOcean

  • 772

I've just finished setting up my Server on Digital Ocean (Ubuntu 12.10 x64) using nginx, but i want a separate MySQL Server to decrease the load to the web server.

The problem is, im unable to connect to my server.

I've tried to setup iptables to open port 3306, I've commented the line bind-address The server works fine locally, tested with wordpress, nginx and phpmyadmin.

I cant connect from anywhere, keep getting ERROR 1130 (HY000): Host '192.XXX.XXX.XXX' is not allowed to connect to this MySQL server.

And yes i reloaded all services all the times...

mysql

1 Answers

  1. Best Answer

    An ERROR 1130 MySQL error is a grant issue within MySQL. That you're getting this is good news - your remote host (let's call it R1) is connecting to your MySQL host (My1). My1 is checking against it's GRANT table and sees that you're not allowed to connect to the database you'd like to as the user you're trying from that remote host (R1).

    You need to add a new GRANT to allow the connection.

    To see existing grants connect to MySQL as root on My1 (mysql -u root -p mysql) and then run:

    SELECT host,user FROM user;
    • 2