for - mysql grant all privileges identified by password
Comando CREAR denegado al usuario? (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''
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''