phpmyadmin don't see new created databases

Question

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

Solution 1

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

Solution 2

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.

Comments

[Zoe stands with Ukraine]

Reviewers: this is an actual answer. There is a post in the link backing up the statement, meaning the necessary context is included