Opensuse 13.1


I got difficulties with opensuse, and with mariadb (i've installed by mistake, i'm not usually use for me).

Anyway,if i put add user with server mysql with webmin and fill each box , i got these message:

Fail to sab user : SQL insert into user (Host,User,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,Create_user_priv,Event_priv,Trigger_priv,Create_tablespace_priv,ssl_type,ssl_cipher,x509_issuer,x509_subject) values ('localhost', 'elim', '', 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','') falló: Field 'authentication_string' doesn't have a default value


Daniel Witoszek Arias



Howdy -- while I may take a look at that at some point in the future, Suse/OpenSuse isn't actually one of the distributions supported by Virtualmin.

You can see the ones that are supported here:

We haven't had much demand for Suse though, and it may be some time before we're able to look into that to see if it's resolvable.

I'd be interested to see the structure of the mysql.user table on your system though. Can you login to MySQL and run desc mysql.user and post the output here?

Ok , i will send you the output here

I haven't a user with mariadb.All my website use mysql.

~/mysqlbackup> mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 126 Server version: 5.5.33-MariaDB openSUSE package

Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> desc mysql.user -> mysql.user ->