MySQL Bugs: #13654: Can't create new user

Bug #13654	Can't create new user
Submitted:	30 Sep 2005 13:28	Modified:	4 Oct 2005 8:00
Reporter:	Marcelo Andrieu	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.1.3	OS:	Windows (Windows 2000)
Assigned to:	Vladimir Kolesnikov	CPU Architecture:	Any

Description:
When attempting to add a new user, an error saying "Error while string user information. The user might have been deleted. Please refresh the user list".

How to repeat:
Administrator 1.1.3 - MySQL 5.0.13rc - on Windows
Click User Administration
Right Click - Add New User
Enter User Name and Password
Click Apply Changes
Error dialog box pops up

Could you please provide additional information, there are other bug
report with the same issue and I was unable to reproduce, I tried
also to remove the user using the mysql client while in MA I was
editing a new user but the refresh button worked, there is something
which provoke that behavior.

Thanks in advance.

I experience the same problem on Windows XP SP2 (same MySQL
and Administrator versions as stated above.
In the log I can see that the following query is issued:
INSERT INTO mysql.user(User, Host, Password) VALUES('username', '%', Password('password')).

Trying this insert in the SQL Query Browser, I receive
"Field ssl_cipher doesn't have a default value.    1364"

Maybe this is the root cause of this problem!

Yes, I get the same errors as reported by Miguel:

Here's the log when I try to create a user and click apply:
051001 18:53:38	      1 Query       SET collation_connection = utf8_bin
		      1 Query       INSERT INTO mysql.user(User, Host, Password) VALUES('myusername', '%', Password('mynewpassword'))
		      1 Query       SET NAMES utf8
		      1 Query       SET collation_connection = utf8_general_ci

When I execute this query in Query Browser I get:
Field 'ssl_cipher' doesn't have a default value (ErrorNr. 1364)

can't add new user in XP sp2

Error while storing the user information.The user might have been deleted.
Please refresh the user list.

After refrshing ,ther new user disappear in the list.

I have the same error as Nudge Qiu

I have exactly the same problem as the other users here (same error message from Admin, same error when executing query manually).

I was able to create a new user ID with the following query:

INSERT INTO mysql.user(User, Host, Password, ssl_cipher, x509_issuer, x509_subject) VALUES('username', '%',
Password('password'), '', '', '')

Alguien tiene noticias sobre este bug. Ya que si bien se puede hacer un create user, desde el admin, no se puede.
Nota. Cuando instale sl MYSQL luego de levantar el servicio genero un mensaje indicando que no podia aplicar la seguridad sobre la base y que podia reintentar, reintente y finalizo "correctamente " la instalacion.

Below the log when trying to add a new user with MA:

C:\Arquivos de programas\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.13-rc-nt-log. started with:
TCP Port: 3306, Named Pipe: (null)
Time                 Id Command    Argument
051003 17:43:05	      1 Connect     root@localhost on 
		      1 Query       SET SESSION interactive_timeout=1000000
		      1 Query       SELECT @@sql_mode
		      1 Query       SET SESSION sql_mode='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
		      1 Query       SET NAMES utf8
051003 17:43:06	      2 Connect     root@localhost on 
		      2 Query       SET SESSION interactive_timeout=1000000
		      2 Query       SELECT @@sql_mode
		      2 Query       SET SESSION sql_mode='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
		      2 Query       SET NAMES utf8
		      2 Quit       
051003 17:43:09	      1 Query       SELECT DISTINCT User FROM mysql.user ORDER BY User
051003 17:43:11	      1 Query       SELECT * FROM mysql.user WHERE 1=2
051003 17:43:22	      1 Query       SET collation_connection = utf8_bin
		      1 Query       INSERT INTO mysql.user(User, Host, Password) VALUES('miguel', '%', Password('a'))
		      1 Query       SET NAMES utf8
		      1 Query       SET collation_connection = utf8_general_ci
051003 17:43:29	      1 Quit       

and trying to do the same MA's command into mysql client:

C:\mysql5013\bin>mysql -uroot mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.13-rc-nt-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SET collation_connection = utf8_bin;
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO mysql.user(User, Host, Password) VALUES('miguel', '%', Password('a'));
ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
mysql>

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html