I cannot connect to digitalocean mysql database within the droplet from external site

Posted May 13, 2021 1.1k views

I have followed this document to give access to the mysql database remotely, changed the bind address to and even with the IPv4 IP and did all the steps. I have tried to connect to the database using sequel pro and from local environment to the server database but its not connecting.

I get this error: MySQL said: Host ‘’ is not allowed to connect to this MySQL server. I wonder what the public IP is and what I am doing wrong.

1 comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
1 answer

Oh, looks like the link didn’t stick. This is the article I am following.

  • Ok, I just tried a script on a server thinking my ip might be banned or something but still I get the same error.

    $dbServerName = "mydigitalocean_ip";
    $dbUsername = "xxxx";
    $dbPassword = "xxxx";
    $dbName = "xxxx";
    // create connection
    $conn = new mysqli($dbServerName, $dbUsername, $dbPassword, $dbName);
    // check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    echo "Connected successfully";

    bind_address is set to so it should allow all kinds of remote ips. The Host in the user table is set to my DO ip address.

    The error I am getting is
    Connection failed: Host ‘’ is not allowed to connect to this MySQL server