Tell me more ×
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.
up vote 1 down vote favorite

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
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

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

2 Answers

up vote 0 down vote

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
up vote 1 down vote

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

Your Answer

 
discard

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