Question

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

Posted May 13, 2021 621 views
MySQL

I have followed this document to give access to the mysql database remotely, changed the bind address to 0.0.0.0 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 ‘110.xxx.xxx.xxx’ is not allowed to connect to this MySQL server. I wonder what the public IP is and what I am doing wrong.

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.

    <?php
    $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 0.0.0.0 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 ‘rs09de.01cloud.com’ is not allowed to connect to this MySQL server