CODEWITHSUNDEEP
phpmysqlphpmyadminmysqli
user123321
user123321

Reputation: 235

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

Upvotes: 15

Views: 31072

Answers (3)

Maneet
Maneet

Reputation: 71

Clearing the browser cache, logging out and then logging in again worked. Originally found the solution here: https://www.godaddy.com/community/cPanel-Hosting/Database-not-showing-up-in-phpmyadmin/td-p/112397

Upvotes: 0

JackSparrow
JackSparrow

Reputation: 958

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.

Upvotes: 33

ellipse-of-uncertainty
ellipse-of-uncertainty

Reputation: 1035

You need to give your user access to that database, log into phpMyAdmin as the mysql administrator, go to the database in question and click on "permissions", then proceed to add your desired users to the database. Alternatively you can use the mysql client and issue the commands as SQL such as:

GRANT ALL ON db1.* TO 'finn'@'localhost';

http://dev.mysql.com/doc/refman/5.0/en/grant.html

Upvotes: 15

Related Questions