accessing MySQL db created in Workbench in phpMyAdmin

[dharman]

Novice user of XAMPP and phpMyAdmin so I apologize if this is a dumb question. I have created a database in MySQL Workbench that I would like to control from phpMyAdmn. php is working fine. I have confirmed connectivity for root@127.0.0.1:3306 from Workbench. phpMyAdmin does not see my database. Am I thinking about this the wrong way? Do I need to move the database into a folder in htdocs? I appreciate any advice anyone cares to offer me.

I am running XAMPP 7.2.7 on Mac OS 10.15.6

[Nobbie]

When Xampps phpmyadmin does not see your database, there is only one conclusion to me: you are running another instance of MySQL besides Xampp. You have two different MySQL servers installed (i think so).

[Altrea]

Other possibility: phpmyadmins user to connect to the database has not the permission. Maybe you are logging in with an anonymous user by accident.
This is always the case if you redefine the root user to be permitted by any host and at the same time there is an anonymous user defined for any user @ localhost.
any@localhost has a higher priority then root@any

You can check which user is currently active by typing the following command in the phpmyadmin SQL Tab:

Code: Select all

SELECT CURRENT_USER();

You can check which MySQL instance you are talking to (Nobbies hint) by the following SQL statement:

Code: Select all

SHOW VARIABLES WHERE Variable_Name = "basedir"