Can't see wordpress db on phpmyadmin??? What to do

Posted July 18, 2017 8k views
MySQLPHPWordPressUbuntu 16.04

I’ve installed phpmyadmin following the tutorial. WordPress was already installed. I’m able to access phpmyadmin, and it works fine. Although i’m unable to see the wordpress db there. What am i doing wrong?

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
3 answers

Hi @cpinho

Are you connecting with the same user as WordPress or root, when you connect via phpMyAdmin?
Which tutorial have you followed to install phpMyAdmin - link please?
And did you use the One-Click App to setup the droplet with WordPress already installed?

With your first question, i got it!!! eheheh

If i use the wordpress config file db user name and pwd, i was able to enter in phpmyadmin!!!

This was funny.

Sorry for my happiness but i’m not a developer or system guy. Just a n00b!!!!

Hi @hansen

Thank you for getting back to me.

I’m using root

I’ve followed this tutorial

I really can recall if i’ve done the one click install for this droplet, as it was months ago.

by Brennen Bearnes
While many users require access to a database management system like MySQL, not all users feel comfortable interacting with the MySQL prompt on a daily basis. In this guide, we'll discuss how to install and secure phpMyAdmin, a web management interface for MySQL, on an Ubuntu 16.04 server.
  • @cpinho

    Just a question: You installed phpMyAdmin on the same droplet as WordPress is installed on and using the same domain to access it, right?

    Can you run this command on the droplet and post the output:

    egrep "DB_(NAME|HOST)" /var/www/html/wp-config.php