Related

Product Now Available: Managed MySQL Databases Product
Install MySQL on New Droplet Question Question
How can I solve error "SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)" Question Question

Question

Access Digital Ocean Managed MySQL Database through phpmyadmin

Posted September 24, 2020 162 views
MySQL

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.

Add a comment
mbrantley
By:
mbrantley
edited by bobbyiliev
Add a comment

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
bobbyiliev September 24, 2020

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

Reply Report
  • andystorey 1 day ago

    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

    Reply Report
    • bobbyiliev 1 day ago

      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

      Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help