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

Try doing a FLUSH PRIVILEGES;. This MySQL bug post on that error code appears to report some success in a case similar to yours after flushing privs. 

Related Posts:

  1. Access denied for user ‘root@localhost’ (using password:NO)
  2. MySQL error 2006: mysql server has gone away
  3. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  4. Cannot delete or update a parent row: a foreign key constraint fails
  5. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  6. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  7. Your password does not satisfy the current policy requirements
  8. PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
  9. Duplicating a MySQL table, indices, and data
  10. Selecting data from two different tables without using joins
  11. Difference between VARCHAR and TEXT in MySQL
  12. MySQL: Invalid use of group function
  13. SELECT * FROM multiple tables. MySQL
  14. How can I loop through all rows of a table? (MySQL)
  15. Simple Random Samples from a Sql database
  16. What does SQL clause “GROUP BY 1” mean?
  17. LAST_INSERT_ID() MySQL
  18. MySQL foreach loop
  19. SQL select only rows with max value on a column
  20. Trying to perform MINUS operation in MySQL
  21. How do I find which transaction is causing a “Waiting for table metadata lock” state?
  22. mysql count duplicates
  23. MySQL Calculate Percentage
  24. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  25. Repair all tables in one go
  26. MySQL config file location – redhat linux server
  27. How to change collation of database, table, column?
  28. Failed building wheel for mysql-python
  29. Create boolean column in MySQL with false as default value?
  30. Is there a naming convention for MySQL?
  31. Error Code 1292 – Truncated incorrect DOUBLE value – Mysql
  32. MySql – HAVING vs WHERE 
  33. How to stop mysqld
  34. mysql: connection refused when trying to connect to localhost using remote IP
  35. Is merge statement available in MySQL
  36. GROUP_CONCAT comma separator – MySQL
  37. Complex meta query with 3 keys
  38. Set page template for all pages?
  39. Optimize Multiple Taxonomy Term MySQL Query?
  40. WordPress MySQL & PHP Performance
  41. What specific database privileges does WordPress need?
  42. Using source control with WordPress
  43. My WordPress site always displays a cached version of its homepage
  44. wpdb Custom Meta Data with 2 conditions
  45. Updating User Meta with SQL Query
  46. wpdb prepare syntax
  47. How to run this SQL query of wp_terms database
  48. Configure WordPress to connect to Mysql DB using SSH tunneling
  49. Proper way to work with wpdb to get user’s firstname
  50. How to change post format from Aside to Image for all posts?
  51. Inserting Hundreds of Thousands of Posts at Once
  52. wp_admin edit.php slow with lots of queries
  53. How to add and SQL query of posts only published
  54. Slow Mysql Queries
  55. can database and media folder be moved to a different drive?
  56. Find duplicate posts with same slug and author
  57. Rewrite database urls
  58. writing inner join in wpdb
  59. How to get data from WordPress site sql file
  60. Unknown collation when I import a dump from an existing site into a development database?
  61. PHP script can’t connect to Database on port 3307
  62. WordPress with php5-fpm and nginx
  63. Migrating from Existing MySQL Setup to WordPress
  64. How to split the a table in database?
  65. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  66. How to translate this mySQL query to $wpdb query
  67. $wpdb to insert html form information
  68. Proper usage of $wpdb->update()?
  69. MySQL 5.5 upgrade ‘broke’ WordPress [closed]
  70. Separate DB by yearly archive of WordPress
  71. What should a WordPress developer know about MySQL? [closed]
  72. Copyright: Get first and last date of post type
  73. Update MySQL query so that it functions again
  74. Query posts by custom taxonomy and sort by post_modified
  75. WordPress $wpdb get posts from category and sort by custom meta
  76. WordPress tables and aliases?
  77. Array Formation Issue
  78. How can I write a formal sql query to get data from a custom table
  79. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  80. WordPress $wpdb no result
  81. Word Press and database from another server sync
  82. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  83. How to run SQL query from WordPress ‘WP Crontrol’ plugin
  84. edit_user_created_user hook – using to update Groups
  85. Changes not being reflected on new server
  86. Mysql Error in querying form entries in Gravity Form plugin
  87. Improving performance of SQL sub-queries in WordPress
  88. MySQL – How to combine data from two tables into one?
  89. Saving custom term value to the database in new table
  90. Stop my loop to register data twice
  91. MySQL errors after a WordPress clone
  92. How to restore: Database intact but folders deleted
  93. XML RPC post produces immediate revision with odd post_date_gmt
  94. MYSQL Join on meta key value?
  95. Woocommerce: Grab total revenue of a product over all orders
  96. Complicated MySQL Query
  97. problem with quotes on new post
  98. SQL Database Lost
  99. InnoDB: Error: log file ./ib_logfile0 is of different size
  100. Postgres equivalent to MySQL’s \G?

Leave a Comment