By mbrantley
How can I connect to a Managed Digital Ocean Database? I tried started a new droplet using the one-click PHPMyAdmin and altered the /etc/phpmyadmin/config.inc.php with the following
$i++;
$cfg['Servers'][$i]['host'] = '';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['compress'] = FALSE;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';
Obviously I filled in the blanks with the information provided in the DB dashboard.
And yes I authorized the droplet to connect in the security settings.
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
hey mbrantley,
you have to ForeceSSL to do that edit /etc/phpmyadmin/config.inc.php
and add this line at the end of the file
$cfg['ForceSSL'] = true;
also set auth_type to cookie
$cfg['Servers'][$i]['auth_type'] = 'cookie';
hopefully, this will solve your issue.
cheers, Ali
Hello,
There are a couple of things that I could suggest:
- Make sure that you are using the latest PHP version
- Make sure that you are using
mysql_native_passwordand notcaching_sha2_password - If this still does not exist, I would recommend installing the latest version of PHPMyAdmin as described here rather than using the 1-Click installation:
https://www.digitalocean.com/community/questions/how-to-install-manually-phpmyadmin-on-ubuntu
This will allow you to have the latest PHPMyAdmin version which is compatible with MySQL 8.
Hope that this helps. Regards, Bobby
Hi @mbrantley,
Our below community article can guide you in setting up and connecting to MySQL Managed database via phpMyAdmin with SSL.
I hope this helps!
Regards, Rajkishore
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.