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

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

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.
Chris
twcinnovations
richard.wilson
richard.wilson
richard.wilson
rich
64c835749e2e4bf7a2259c9e896737
Yakin
caio_fr_sp
Abhishek M S
lnxfsf