cpinho
By:
cpinho

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

July 18, 2017 643 views
WordPress MySQL PHP 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?

3 Answers
hansen July 18, 2017
Accepted Answer

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?

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.

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
    

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

Have another answer? Share your knowledge.