up vote 2 down vote To me works, I set hostname in UPPERCASE: DROP USER 'user'@'LOCALHOST' share|improve this answer answered Jan 23 '15 at 21:01 Luferquisa 585 add a comment| Your In order to fix it I just had to use the DROP USER statement. This also may not even be a bug. This MySQL bug post on that error code appears to report some success in a case similar to yours after flushing privs. http://rlegsoftware.com/mysql-error/150-mysql-error.php
Browse other questions tagged mysql or ask your own question. Thank you very much. –Russ Bateman Apr 5 '11 at 17:03 add a comment| up vote 3 down vote two method one : setp 1: drop user 'jack'@'localhost'; setp 2: create Of course, the formal answer today was "not to be stupid" and to use REVOKE and DROP USER to do it right. How does the Booze-Rat fuel its defensive mechanism? http://stackoverflow.com/questions/5555328/error-1396-hy000-operation-create-user-failed-for-jacklocalhost
What are these spots? Additional reading: http://dev.mysql.com/doc/refman/5.1/en/account-names.html Please read those bug reports for further clarification http://bugs.mysql.com/bug.php?id=28331 http://bugs.mysql.com/bug.php?id=62255 share|improve this answer edited Sep 2 '13 at 8:06 answered Sep 2 '13 at 7:41 Xevelion 66937 I'm indebted to all three answers (this one just happens to be the one that bailed me out of my present predicament). –Russ Bateman Apr 5 '11 at 17:05 3 Did Donald Trump call Alicia Machado "Miss Piggy" and "Miss Housekeeping"?
Success case; mysql> create user [email protected]; Query OK, 0 rows affected (0.00 sec) mysql> drop user [email protected]; Query OK, 0 rows affected (0.00 sec) mysql> create user [email protected]; Query OK, 0 Create new user. In a previous poster's comments, the success cases are demonstrative. Mysql Error 1045 Not the answer you're looking for?
Which period is this game map supposed to represent? Mysql Error 1396 Drop User How to repeat: mysql> create user 'world'; Query OK, 0 rows affected (0.00 sec) mysql> create user 'world'; ERROR 1396 (HY000): Operation CREATE USER failed for 'world'@'%' Suggested fix: mysql> create Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the internet Terms Privacy Security Status Help You can't perform that action at this time.
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? Mysql Grant Reloads the privileges from the grant tables in the mysql database. 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 This memory is not released by the corresponding REVOKE, DROP USER, DROP SERVER, and UNINSTALL PLUGIN statements, so for a server that executes many instances of the statements that cause caching,
Thanks. https://cournape.wordpress.com/2010/08/30/fixing-error-1396-hy000-operation-create-user-failed/ If you have to add user with same username later, you can use FLUSH PRIVILEGES command to completely remove privileges from the mysql memory. Mysql Create User Reply TechNazgul says: January 27, 2011 at 05:41 Thanks for posting this. Mysql Show Users How to write down a note that is sustained while there are other simultaneous in the same bar?
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. weblink Then I did my normal "create user …" command and it worked like a champ. Why did companions have such high social standing? It also shows up as an entry before the "root" user. Mysql Delete User
Flush privileges. I did like that: CREATE USER 'jimmy'@'localhost' IDENTIFIED BY 'test123'; UPDATE mysql.user SET USER='jack' WHERE USER='jimmy'; share|improve this answer answered Jan 8 '15 at 20:45 Litter 512 add a comment| up If I execute this command for some other, random username, say 'jimmy', it works fine (just as it originally did for 'jack'). navigate here Join them; it only takes a minute: Sign up while creating and deleting user in mysql ERROR 1396 (HY000): Operation CREATE USER up vote 8 down vote favorite I am trying
Still having trouble deleting the user. [1 Mar 2011 19:19] N Delfeld There is another wrinkle to this bug. Mysql List Users Test case that includes the word "user"; mysql> CREATE USER [email protected]; ERROR 1396 (HY000): Operation CREATE USER failed for 'spamuser'@'localhost' Test case that keeps "use" but not "user"; mysql> CREATE USER This really helped!
Viewing the error logs, I noticed that it said to run mysql_upgrade. There seems to be no need to waste time digging in the grant tables looking for ghosts as one poster suggested. Do I send relative's resume to recruiters when I don't exactly support the candidate's track record? Mysql Error 1396 Create User Failed Whether that bug has been fixed, I don't know; but I don't recall that happening lately and I'm up to ver 5.5.27 at this time.
Thanks. –Jake Feb 27 '12 at 17:35 2 ditto - imho this should be the answer –LeonardChallis Mar 29 '12 at 8:54 Same for me. Sometimes, there is an anonymous user ''@'localhost' or ''@'127.0.0.1'. Reply Abhishek says: January 2, 2012 at 19:17 i just wrote: drop user foo; and got success for user foo.. http://rlegsoftware.com/mysql-error/145-error-mysql.php I issued a DROP USER command and was greeted with: mysql> drop user userguy;
ERROR 1396 (HY000): Operation DROP USER failed for 'userguy'@'%'
That didn't work either.
Did that and my create user statement worked fine! How can I recreate the following image of a grid in TikZ? Are belt conditioners safe? 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
FROM [email protected] share|improve this answer answered Oct 2 '13 at 9:29 Prabhu 1,68921428 add a comment| up vote 1 down vote This user must be referenced in other tables from the Elegant in it's simplicity (not to mention helpful). cheers Uki says: July 9, 2012 at 9:28 am If your hosting piovrder is using an up-to-date version of cPanel/WHM, simply login and in the Databases section of the interface, click Following this, I received the error: 'ERROR 1396 (HY000): Operation CREATE USER failed ...'.
DailyProgrammer 284: Wandering Fingers Fast algorithm to write data from a std::vector to a text file Did Donald Trump call Alicia Machado "Miss Piggy" and "Miss Housekeeping"? 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 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