Cannot change dbuser password of MariaDB, when changing password of virtual server's administrator from virtualmin GUI.

Centos7.7

install virtualmin and upgrade to MariaDB10.4 like below

$stop mariadb

$ vi /etc/yum.repos.d/MariaDB.repo

[mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.4/centos7-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1

$ yum clean all

$ yum update mariadb-server -y

$ systemctl start mariadb

$ systemctl enable mariadb

$ mysql_upgrade -u root -p

in 「Virtualmin」> 「Edit Virtual Server」>「Configurable settings」

Cannot change dbuser password of MariaDB, when changing password of virtual server's administrator from "Administration password".

And

in 「Virtualmin」> 「Edit Databases」>「Passwords」

Cannot change dbuser password from "Change database passwords"

Status: 
Active

Comments

When you say "Cannot change dbuser password", what error message do you get exactly?

it shows no errors. but, the password of mariadb user is not changed.

and I find that it is maybe related error.

・Webmin > Servers > MySQL Database Server > User Permissions > "select user" > Password "set to" hogehoge;

Failed to save user : SQL update user set 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 = ?, Delete_history_priv = ? where host = ? and user = ? failed : Column 'Select_priv' is not updatable

It looks like you are hitting a compatibility issue with MySQL 10.4.