Question

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

Posted July 18, 2017 4.7k views
MySQL PHP WordPress Ubuntu 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?

Add a comment
cpinho
By:
cpinho
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.

3 answers
hansen July 18, 2017

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?

Reply Report
cpinho July 18, 2017

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.

How To Install and Secure phpMyAdmin on Ubuntu 16.04
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.
Reply Report
  • hansen July 18, 2017

    @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
    Reply Report
cpinho July 18, 2017

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!!!!

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help