Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
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 1.9k 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

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
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

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
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 October 22, 2020

    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 October 23, 2020

      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
rediahila October 13, 2021

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

Reply Report

Related

Looking for something else?

Ask a new question Search for more help