Connection timed out on MySQL Managed Database Cluster

Posted December 8, 2019 6k views
MySQLClusteringDatabasesDigitalOcean Managed MySQL Database

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'] = '';
$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 -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! :)

edited by bobbyiliev

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
2 answers

Failed with;
$cfg['Servers'][$i]['port'] = 3306;

Success with;
-P 25060

You’re simply using the wrong port in your application. Try changing it to the latter and retry connection.