Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

phpmyadmin don't see new created databases

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

like image 923
user123321 Avatar asked Nov 11 '12 05:11

user123321


People also ask

Why database is not showing in phpMyAdmin?

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…

How do I see all created databases in MySQL?

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”.

How do I find my database in phpMyAdmin?

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.


1 Answers

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.

like image 129
JackSparrow Avatar answered Nov 15 '22 15:11

JackSparrow