Question
Connection timed out on MySQL Managed Database Cluster
Hi guys,
we start up with a new Managed Database MySQL cluster but unfortunately we cant connect with any PHP tool AND also phpMyAdmin.
The config for the phpMyAdmin:
$cfg['Servers'][$i]['verbose'] = 'CLUSTER';
$cfg['Servers'][$i]['host'] = 'nottheprivatehost-0.db.ondigitalocean.com';
$cfg['Servers'][$i]['port'] = 3306;
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['ssl'] = true;
The system is running on default settings with one additional user and database. Here I performed already successfully the “GRANT ALL ON” command for the additional user and database. The user can connect with the mysql command via shell and see the database.
I looks like an firewall timeout, but there are no “trusted sourced” defined. Also the cluster has currently no tags (in case of Firewalls).
So finally, I can connect like this without any problem (also with my own created user and database:
mysql -u doadmin -dPASSWORD -h nottheprivatehost-0.db.ondigitalocean.com -P 25060 -D defaultdb
But from other droplets it’s no chance (phpMyAdmin, PHP test, WordPress). I’ve also check the outbound firewall settings of this droplet. It also works.
Thanks a lot for your help! :)
Best
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.
×