Resultado de búsqueda
10 de ene. de 2015 · I ran into this issue having previously deleted a user of the same name directly from the user table: DELETE FROM mysql.user WHERE User='aquaman'; But this isn't the right way to delete a user!
7 de oct. de 2021 · The MySQL ERROR 1396 occurs when MySQL failed in executing any statement related to user management, like CREATE USER or DROP USER statements. This error frequently appears when you run statements to create or remove users from your MySQL database server.
Obtendrá este error si intenta eliminar el usuario borrando el registro de usuario de la tabla mysql.user (delete from user wehre user =...) en lugar de llamar a la sentencia drop user. Para solucionar el problema, simplemente elimine el usuario con el comando drop y luego ejecute "flush privileges" y listo.
How to resolve MySQL error "ERROR 1396 (HY000): Operation ALTER USER failed for 'myuser'@'localhost'?"
建立用户的时候报告这个错误：ERROR 1396 (HY000): Operation CREATE USER failed for 'abc'@'localhost'原因是mysql中已经有了这个用户，从mysql.user中直接删除delete，然后刷新权限FLUSH PRIVILEGES，再建用户就不会有这个问题了。
1 de jun. de 2017 · Recibo el siguiente error: ERROR 1396 (HY000) at line 11: Operation DROP USER failed for 'garen'@'localhost' Cuando ejecuto este código: -- DATABASE -- Creamos la base de datos DROP DATABASE IF
Server version: 10.0.23-MariaDB Fedora 23 64 bit. I am logged in as root. MariaDB [(none)]> create user brown@localhost ; ERROR 1396 (HY000): Operation CREATE USER failed for 'brown'@'localhost'. Syntax is correct, yet, as can be seen, it fails.
