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.

  • 5
    Have you granted those users the necessary permissions on the database?
    – eggyal
    Commented Dec 26, 2012 at 11:40
  • Might be better on server fault or dba stack exchange
    – DWright
    Commented Dec 26, 2012 at 11:52
  • Are you sure you mean error 1164 "The used table type doesn't support AUTO_INCREMENT columns"??
    – eggyal
    Commented Dec 26, 2012 at 12:26
  • Probably ERROR 1146 (42S02): Table 'missing.table' doesn't exist... which definitely points to missing grants if the schema and table are really there and visible to another user. Commented Dec 27, 2012 at 3:57

2 Answers 2


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.


Also check the permissions on the files to make sure mysql is the owner:

chown -R mysql:mysql yourdatadir
  • If the database were restored from a dump file and visible to any user, the permissions on the data directory shouldn't be an issue. The username "root" has no intrinsic meaning within MySQL and doesn't correlate to any OS-level "root" privilege. Commented Dec 27, 2012 at 3:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.