The only time I get this error is when I do DROP USER user; like the doc suggests, but MySQL does not treat the '%' as a wildcard in a way It has been closed. In any case, After the problems I have had, I consider deleting the user row from mysql.user a deprecated method of removing users. FROM '[email protected]'; // remove certain privileges DROP USER '[email protected]'; // completely delete the account Best to use the tools provided rather than mucking around in the background. have a peek here
It still puzzles me how many differences are there between Oracle and MySQL, and how difficult is to create a simple deployment script. I start with a "he” and end the same Fast algorithm to write data from a std::vector to a text file Which file formats are used to make viruses in Ubuntu? Create new user. After deleting them from the user table by hand, I could re-add them.
Assuming we want to create the user admin @ localhost, these would be the commands: drop user [email protected]; flush privileges; create user [email protected] identified by 'admins_password' Cheers share|improve this answer answered As of MySQL 5.0.2, you can remove an account and its privileges as follows: DROP USER user; The statement removes privilege rows for the account from all grant tables. I'm too shy to ask, but will you say yes? US travel visa after an overstay How did the Booze-Rat evolve its defensive mechanism?
Some install specifics: Server Version: 5.0.51a-3ubuntu5.4 Operating System: Ubuntu 8.04.1 cheers, Matt [22 Nov 2010 17:52] Francis Huston After 3 years can we have useful error messages? [1 Mar 2011 19:19] According to this issue over at mysql, you will see that error if the user already exists. Which period is this game map supposed to represent? http://stackoverflow.com/questions/17008610/error-1396-hy000-operation-create-user-failed-for-usernamelocalhost-iden The upgrade is of no cost to them.
Back to top Send to Email Address Your Name Your Email Address Cancel Post was not sent - check your email addresses! Mysql Grant How do I directly display a man page? Why did companions have such high social standing? And stop working when you are tired!
Would the one ring work if it was worn on the toe instead of the finger? https://cournape.wordpress.com/2010/08/30/fixing-error-1396-hy000-operation-create-user-failed/ The shrink and his patient (Part 2) In a hiring event is it better to go early or late? Mysql Create User Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account. (LogOut/Change) You are Mysql Show Users I ended up having to flush the tables, privileges, and query cache to fix the problem (you may not have to flush all of these, I just did out of desperation).
REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'saravanakumar'@HOSTNAME; DELETE FROM mysql.user WHERE user='saravanakumar'; FLUSH PRIVILEGES; CREATE USER 'saravanakumar'@HOSTNAME [IDENTIFIED BY 'password']; "user" requires you to specify an account name Syntax for account navigate here I would recreate the user the same way you deleted it: INSERT INTO mysql.user (user, host, password) VALUES ('root', 'localhost', PASSWORD('pasw')); Then FLUSH PRIVILEGES; GRANT ALL ON *.* TO 'root'@'localhost'; Yet DROP USER always works. [1 Apr 2009 10:13] Alessandro Vercelli I had to delete an account, so i used 'drop user
So i tried deleting username references from mysql.user and mysql.db and after re-inserting account failed with: ERROR 1396 (HY000): Operation CREATE USER failed for '
powered by phorum Content reproduced on this site is the property of the respective copyright holders. Mysql List Users Any idea what is going wrong? Related 4MySQL cluster error 1114 (HY000): The table 'users' is full237MySQL ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES)15Importing 1GO SQL File => ERROR 2013 (HY000) at line
On a new install (version 5.5), if the first user that gets created is immediately dropped, the entry *does not appear* in the database. Join them; it only takes a minute: Sign up ERROR 1396 (HY000): Operation CREATE USER failed for 'username'@'localhost' IDENTIFIED BY 'mypassword'; up vote 8 down vote favorite 2 Mistakenly I deleted What are these spots? Mysql Error 1396 Create User Failed I see no vestiges of this in that table.
The server caches information in memory as a result of GRANT, CREATE USER, CREATE SERVER, and INSTALL PLUGIN statements. using MySQL 5.7.12-enterprise-commercial-advanced-log Content reproduced on this site is the property of the respective copyright holders.It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Multiple-Key Sorting Dot message on a Star Wars frisbee team Cohomology of the mapping class group of a non-orientable surface? this contact form more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed
Why did companions have such high social standing? Remember: this does not necessarily revoke all the privileges this user may have (like table privileges), you will have to do this yourself - if you don't you may not be Email check failed, please try again Sorry, your blog cannot share posts by email. %d bloggers like this: Dev Issues Search Primary Menu Skip to content Search for: Database, Errors, System The official MySQL docs do talk about stuff like delete from user where user = 'jack'; and flush privileges.