mysql cannot find database after dropped of it and restored Due to some errors   I decided to drop of all schema and then restore db structure from dump file.  After restoration all other mysql server clients cannot find it (error 1164 ). Only mysqlworkbench   root@localhost I can see that db. 
Using same connection data @localhost other clients cannot find that db.
From the root account do:


  show grants for data@'localhost';   


If it's empty then re-add the grants. Your dump file probably didn't contact the MYSQL db so it didn't restore the permissions.