I create db via mysql:
CREATE DATABASE `my_db` CHARACTER SET utf8 COLLATE utf8_general_ci;
mysql>show databases - my_db is shown,
then i'm login to phpmyadmin and don't see this db, only - information_schema, phpmyadmin, test
p.s. ubuntu 12.04, mysql 5, phpmyadmin 3.4.10.1deb1
If you have multiple xampp applications setup then it's possible it might be on a different phpmyadmin instance. If you are indeed only using the one xampp instance then technically it should show in the phpmyadmin area, unless it's configured in such a way that it's not showing…
SHOW DATABASES lists the databases on the MySQL server host. SHOW SCHEMAS is a synonym for SHOW DATABASES . The LIKE clause, if present, indicates which database names to match. The WHERE clause can be given to select rows using more general conditions, as discussed in Section 26.8, “Extensions to SHOW Statements”.
Navigate to your control panel and click the phpMyAdmin icon. Locate the database you want to search by clicking on the database in the left column. Once inside the database, a list of tables will be displayed. Click on the Search tab.
If you Still don't see it, Try to logout from cpanel and then log in again to cPanel or PHPMyAdmin. It worked for me.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With