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

July 18, 2017 4.2k views
WordPress Ubuntu 16.04 PHP MySQL
cpinho
By:
cpinho

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?

Log In to Comment
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
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
  • 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
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
Have another answer? Share your knowledge.

Related