Setting up phpmyadmin with my mysql managed database

Question

i have created a managed mysql database, i have a hosting account and upload the phpmyadmin and set the config.inc.php as follows

/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'db-mysql-blr1-63272-do-user-4986520-0.b.db.ondigitalocean.com';
$cfg['Servers'][$i]['port'] = '25060';
$cfg['Servers'][$i]['ssl'] = true;
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = false;

Then i opened the phpmyadmin and i give the username and password for the defaultdb, but i got the following error.

Cannot log in to the MySQL server mysqli::real_connect(): (HY000/2002): Connection refused

i tried with all ways but i cant login to view my database. my hosting is running on php 7.4, even i tried with php 8.0 but getting the same error. Anybody help please.

Rajkishore J · Answer

Hi @binujohn , Our below community article can guide you in setting up and connecting to MySQL Managed database via phpMyAdmin with SSL. https://www.digitalocean.com/community/tutorials/how-to-connect-to-mysql-managed-database-via-phpmyadmin I hope this helps! Regards,Rajkishore