Hello,

Sorry if someone has already asked this however i have looked high and low. Anyway, i am running Webmin on Ubuntu server and continuously experiencing issues with the MySQL database.

Everything is installed and I did get it working after i had fixed it ( lost the fix ) so basically when ever i try to create a new database user i receive the below error, I know it has something to do with the SSL Cipher. Can anyone help????

P.S. treat me a s a newbe as i know very little, but enough to figure things out

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, authentication_string) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) failed : Column 'ssl_type' cannot be null

Since the values that are being inserted are listed as "?", I'm assuming that there's a script somewhere that is populating those values. The value for the field "ssl_type" is being passed as NULL, and the schema for the table "user" does not allow for NULL values. You need to specify a non-null value for this field.

I also count 2 more "?"s than there are fields in the query; that could cause a problem (unless I'm counting wrong).