Mysql Error Adding Account Newuser@
11:18 Reporter: Tim Thorburn Email Updates: Status: Closed Impact on me: None Category:MySQL Workbench: Administration Severity:S1 (Critical) Version:5.2.31a OS:Microsoft Windows (Win7 Ultimate 64-bit) Assigned to: Maksym Yehorov Tags: mysql 5.5.8, mysql administrator, windows, workbench View Add Comment Files Developer Edit Submission View Progress Log Contributions [17 Dec 2010 13:48] Tim Thorburn Description: Upon installing MySQL 5.5.8 on my Windows 7 Ultimate 64-bit dev machine I was unable to add users with either Workbench (5.2.31a) or MySQL Administrator. The errors I received were as follows: Workbench ----------------------------- Unhandled exception: Error adding account accountName@%: MySQL Administrator ----------------------------- Error while storing the user information. The user might have been deleted. Please refersh the user list. - a command prompt window appeared behind MySQL Administrator which stated the following: ** Message: save user: error adding new user entry How to repeat: With MySQL 5.5.8 (64-bit) installed, start either MySQL Administrator or Workbench GUI tools. Attempt to add a user, in the case of both GUI tools, this will fail. When attempting to add a user via phpMyAdmin the operation is successful. Suggested fix: Correct issue with MySQL GUI tools to allow users to be added to MySQL 5.5.8 [18 Dec 2010 13:05] Marco Cianciaruso I have the same identical problem on Win2008 Server [18 Dec 2010 13:12] Marco Cianciaruso I tried to use old "MySQL Administrator" .. same problem I'd like to knwo how the developers tested the new server verision... all by command prompt? [19 Dec 2010 3:45] Ryan Ellison Same problem here - Upgraded from 5.1 to 5.5 Windows 2008 R2 running MySQL x64 [19 Dec 2010 12:26] Peter Holliday Exactly same issue on Vista [19 Dec 2010 18:17] Alfredo Kojima bug #58938 is a duplicate [22 Dec 2010 11:10] Frederick P
Status: Duplicate Impact on me: None Category:MySQL Workbench Severity:S1 (Critical) Version:5.2.31 CE OS:Microsoft Windows Assigned to: Tags: account, user Triage: Needs Triage: D1 (Critical) View Add Comment Files Developer Edit Submission View Progress Log Contributions [15 Dec 2010 6:31] Sidney van de Stouwe Description: Not able to add a user account did run mysql_update and all was reported ok. How to repeat: Start a new configuration with only root account Start workbench and try to add user --> error adding account Suggested fix: add user on mysql command line after adding user one is able to change users particulars as required not sure if this is a workbench or a server issue https://bugs.mysql.com/bug.php?id=59000 [15 Dec 2010 7:02] Valerii Kravchuk What exact version of MySQL Workbench, 5.x.y, do you use? [15 Dec 2010 7:26] Sidney van de Stouwe I'm using the latest version: 5.2.31 CE of the Workbench [15 Dec 2010 22:13] Bert Rodriguez I am having the same problem using 5.2.31. Even with no priveleges I get "Unhandled Exception: Error adding account user@%". [15 Dec 2010 22:25] Sean Young I am having the same problem as soon as https://bugs.mysql.com/bug.php?id=58938 I upgraded to the latest version. I am doing this on a new/clean MySQL install. [16 Dec 2010 7:23] Rob Gardner Hi, I had this problem on 5.5.7 and now on 5.5.8. When I click 'Apply' to add a new account I get the message 'Unhandled Exception: Error adding account xxxxx@xxx'. I tracked it down to being caused by the query that Workbench uses to insert a new user into the mysql.user table not providing a default value for the new authentication_string field. I turned strict mode off and I was able to create a user successfully. This is obviously just a workaround, so it appears that the query does need amending. I'm just surprised this hasn't affected more users. Regards Rob [18 Dec 2010 11:59] Sidney van de Stouwe Workbench related issue [18 Dec 2010 12:45] Valerii Kravchuk Bug #59024 was marked as a duplicate of this one. [19 Dec 2010 14:31] Valerii Kravchuk Verified with 5.2.31 on Mac OS X while working with server version 5.5.8. This is what we can see from the error message: Unhandled exception: Error adding account user2@%: Error executing 'Field 'authentication_string' doesn't have a default value' INSERT INTO mysql.user (User, Host, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Cre
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business http://dba.stackexchange.com/questions/34940/adding-a-user-to-mysql-with-name-fails-with-error-1396 Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. 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 mysql error to the top Adding a user to MySQL with 'name'@'%' fails with ERROR 1396 up vote 2 down vote favorite 1 I just tried to add a new user to MySQL using CREATE USER 'name'@'%' IDENTIFIED BY '...' However, it fails with the following error: ERROR 1396 (HY000): Operation CREATE USER failed for 'name'@'%' Adding the user just for localhost works fine: CREATE USER 'name'@'localhost' IDENTIFIED BY '...' I have no clue what could be the problem. mysql error adding I'd be grateful for any ideas. (I'm using mysql Ver 14.14 Distrib 5.1.66.) mysql mysql-5.1 users share|improve this question asked Feb 18 '13 at 13:17 Petr Pudlák 187229 add a comment| 1 Answer 1 active oldest votes up vote 6 down vote accepted According to the docs if you ommit the @'hostname' (that is CREATE USER 'name') MySQL will interpret it as it had a @'%'. The error message you provided suggests that there is already a user 'name'@'%' in the system: mysql> CREATE USER 'name'@'%' IDENTIFIED BY 'test'; Query OK, 0 rows affected (0.04 sec) mysql> CREATE USER 'name'@'%' IDENTIFIED BY 'test'; ERROR 1396 (HY000): Operation CREATE USER failed for 'name'@'%' mysql> CREATE USER 'name' IDENTIFIED BY 'test'; ERROR 1396 (HY000): Operation CREATE USER failed for 'name'@'%' If you delete the user and still get the message, try running FLUSH PRIVILEGES. Also see this SO question for additional info. share|improve this answer answered Feb 18 '13 at 13:27 redguy 796412 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagg