Unable to create database on virtual server

Ver 15.1 Distrib 10.2.27-MariaDB
Webmin version 1.942
Usermin version 1.791
Virtualmin version 6.09
Virtualmin host PRETTY_NAME="Debian GNU/Linux 10 (buster)"
Database remote host PRETTY_NAME="Debian GNU/Linux 9 (stretch)"

After installing virtualmin with the install.sh script
wget http://software.virtualmin.com/gpl/scripts/install.sh.

Added the remote MySQL host correclty.

When creating a new virtual server I got the next error:

Failed to create database : SQL insert into db (host, db, user, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Create_tmp_table_priv, Lock_tables_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Execute_priv, Event_priv, Trigger_priv, Delete_history_priv) values ('localhost', 'test3', 'test3', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y') failed : Unknown column 'Delete_history_priv' in 'field list'

However, If i change the MySQL server to the local one it works perfectly, without issues.



That's an odd error, as Virtualmin should check when creating a user which columns exist. Are you running the standard version of MySQL that was installed by your Linux distribution?

Ver 15.1 Distrib 10.2.27-MariaDB

That's the version of MariaDB, it's a galera cluster. We have the DB as external DB.

Please, anyone?

Is the version of MySQL on your local system different from the remote version?