Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question

migrated from stackoverflow.com Dec 26 '12 at 15:16

This question came from our site for professional and enthusiast programmers.

5  
Have you granted those users the necessary permissions on the database? –  eggyal Dec 26 '12 at 11:40
    
Might be better on server fault or dba stack exchange –  DWright Dec 26 '12 at 11:52
    
Are you sure you mean error 1164 "The used table type doesn't support AUTO_INCREMENT columns"?? –  eggyal Dec 26 '12 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. –  Michael - sqlbot Dec 27 '12 at 3:57
add comment

2 Answers

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.

share|improve this answer
add comment

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

chown -R mysql:mysql yourdatadir
share|improve this answer
    
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. –  Michael - sqlbot Dec 27 '12 at 3:52
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.