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.

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.

×
1 answer

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_password and not caching_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 Bobby.

    Looking at migrating an office-based LAMP server onto DO.

    Looking at creating a DO managed database cluster using mySQL 8, but am concerned about losing PHPMyAdmin which I use for various weekly tasks.

    Would I have to create an additional general-purpose droplet to run PHPMyAdmin? Budget is limited, so would rather put that money towards a standby node for the cluster.

    Thanks in advance.

    Andy

    • Hi there @andystorey,

      What you could do is install an SQL client like DBeaver or TablePlus or Sequel Pro for example on your laptop, and then use it to connect to your Managed Database Cluster.

      That way you will not have to spin up a separate Droplet to install just PHPmyAdmin.

      Also, I personally believe that the user experience on those SQL clients is much better nowadays.

      Hope that this helps!
      Regards,
      Bobby

Submit an Answer