user_variables_by_thread password identified for error dba datos code all mysql mysql-error-1142

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