-1

I installed mysql-server on Ubuntu 18.04 and then installed phpmyadmin. The issue I have now is when I do show databases in mysql, I get a different set of databases from what is shown in phpmyadmin.

How do I point phpmyadmin to the correct database?

Dan
  • 111
  • 6
  • 3
    Connect to the same database hostname with the same user and you should get the same list. If you're seeing different ones, you're either connected to the wrong server, or you're using a user with different privileges. – ceejayoz May 26 '18 at 13:52

1 Answers1

2

Then you're either using different credentials and/or logging onto different Mysql servers, check with the mysql query select @@HOSTNAME; and/or select USER(); and update either you PHPMyAdmin config or your ~/.my.cnf accordingly.

HBruijn
  • 77,029
  • 24
  • 135
  • 201
  • What's the path to the phpmyadmin config? I'm in /etc/phpmyadmin and there are several config files. – Dan May 26 '18 at 14:02
  • 2
    Please Read the fine manual https://docs.phpmyadmin.net/en/latest/config.html – HBruijn May 26 '18 at 14:05
  • Ah okay, the file is /etc/phpmyadmin/config-db.php. The issue was during setup I used the default `phpmyadmin` user. Switched it to a user with permission and it restored access. Thanks! – Dan May 26 '18 at 14:07