Report this

What is the reason for this report?

How to connect to Managed MySQL Database?

Posted on March 18, 2020

Hi.

How can I connect to DigitalOcean’s managed databases from PHP 5.6? I’m running a vps on CWP and I can’t seem to get it right.


$info = [
  "address" => "xxxxxxxxxxxxxxxxxxxxxxx.db.ondigitalocean.com", 
  "user" => "db_user", 
  "pass" => "db_pass", 
  "db" => "db_name", 
];

$link = mysqli_init();
if (!$link) {
    die('mysqli_init failed');
}

if (!mysqli_options($link, MYSQLI_INIT_COMMAND, 'SET AUTOCOMMIT = 0')) {
    die('Setting MYSQLI_INIT_COMMAND failed');
}

if (!mysqli_options($link, MYSQLI_OPT_CONNECT_TIMEOUT, 5)) {
    die('Setting MYSQLI_OPT_CONNECT_TIMEOUT failed');
}

if (!mysqli_real_connect($link, $info["address"], $info["user"], $info["pass"], $info["db"], '25060')) {
    die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error());
}

echo 'Success... ' . mysqli_get_host_info($link) . "\n";

mysqli_close($link);
?>```

$info["user"]'s host is set to my VPS's ip address.
$info["user"]'s is granted to access $info["db"].
$info["pass"] was created with IDENTIFIED WITH mysql_native_password.

But I'm keep getting error "Connect Error (2002) Connection refused."
http://testdb.fscchan.nl/connecttodb.php

I'm running PHP 5.6 on CWP.

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Start building today

From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.