ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’

by

yes this bug is there. However, I found a small workaround.

  • Assume the user is there, so drop the user
  • After deleting the user, there is need to flush the mysql privileges
  • Now create the user.

That should solve it. Assuming we want to create the user admin @ localhost, these would be the commands:

drop user admin@localhost;
flush privileges;
create user admin@localhost identified by 'admins_password'

Cheers

More Related Contents:

  1. How to set root password to null
  2. how to generate report for attendance system
  3. How can I return pivot table output in MySQL?
  4. MySQL pivot table query with dynamic columns
  5. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
  6. Finding duplicate values in MySQL
  7. Error installing mysql2: Failed to build gem native extension
  8. How to debug Lock wait timeout exceeded on MySQL?
  9. MySQL : isn’t in GROUP BY
  10. Why does MySQL report a syntax error on FULL OUTER JOIN?
  11. SQL: Creating a Relational table with 2 different auto_increment
  12. CURRENT_DATE/CURDATE() not working as default DATE value
  13. How to extract the nth word and count word occurrences in a MySQL string?
  14. How do I add a custom CHECK constraint on a MySQL table?
  15. MySql Count cannot show 0 values
  16. How to store uuid as number?
  17. Cannot change column used in a foreign key constraint
  18. How does one create an index on the date part of DATETIME field in MySql
  19. How to delete a MySQL record after a certain time
  20. using (-) dash in mysql table name
  21. Force InnoDB to recheck foreign keys on a table/tables?
  22. Error: Tablespace for table xxx exists. Please DISCARD the tablespace before IMPORT
  23. Let MySQL users create databases, but allow access to only their own databases
  24. How can I enable MySQL’s slow query log without restarting MySQL?
  25. Does MySQL allows to create database with dot?
  26. Second SELECT query if first SELECT returns 0 rows
  27. Selecting multiple columns/fields in MySQL subquery
  28. connecting to a docker-compose mysql container denies access but docker running same image does not
  29. MySQL’s lower_case_table_names won’t change
  30. #1214 – The used table type doesn’t support FULLTEXT indexes

Leave a Comment