for - mysql grant all privileges identified by password

Comando CREAR denegado al usuario?

Question

show grants for charm@''localhost'';
---------------------+
| Grants for charm@localhost |
+-----------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO ''charm''@''localhost'' IDENTIFIED BY PASSWORD ''*EDD1CD76B1331E363B2BAED3F0B7EAF28559FBEWD'' |
| GRANT ALL PRIVILEGES ON `charmstyle_com`.`charmstyle_com` TO ''charm''@''localhost'' 

solía

grant all on charmstyle_com to charm@''localhost'' IDENTIFIED BY ''t1q4gytrur'';
flush privileges;

Luego importo la base de datos, se muestra un error:

 ERROR 1142 (42000) at line 29: CREATE command denied to user ''charm''@''localhost'' for table ''adminnotification_inbox''

Answer 1

Usted le otorgó permisos de usuario solo a la tabla ''charmstyle_com'' dentro de la base de datos ''charmstyle_com''. Lo que probablemente quieras es otorgar permisos a todas las tablas en ''charmstyle_com'' (o al menos a la tabla ''adminnotification_inbox'')

 GRANT ALL PRIVILEGES ON `charmstyle_com`.* TO ''charm''@''localhost'' 

alternativamente

 GRANT ALL PRIVILEGES ON `charmstyle_com`.`adminnotification_inbox`
TO ''charm''@''localhost''