#4735 can't create mysql user

[Werner Flamme]

Hi Jamie,

I try to create a user without privileges, I only fill in the values for user name and password. The result is:

Failed to save user : SQL insert into user (host, user, 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, Create_user_priv, Event_priv, Trigger_priv, Create_tablespace_priv, ssl_type, ssl_cipher, x509_issuer, x509_subject) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) failed : Field 'authentication_string' doesn't have a default value

in a new page. After 'create user... identified by...' on the command line, I can work with the user in other parts of the Webmin MySQL module. I am using the mariadb-10.0.22 package for openSUSE Leap .

[Jamie Cameron]

In the MySQL module, what version does it show at the top of the main page?

[Werner Flamme]

MySQL version 10.0.22

[Jamie Cameron]

Thanks - it looks like the authentication_string field is mandatory on your system, but not on others.

The next Webmin release will fix this.