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: 
Closed (fixed)

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.

Hello,

Is Webmin/Virtualmin not compatible with Mariadb 10.4?

I'm still getting errors with the "User Permission" portion of the MySQL Database module - updating user and adding new user.

Webmin 1.932 / Virtualmin 6.08

Ilia's picture
Submitted by Ilia on Sat, 10/24/2020 - 08:16

Support for MariaDB 10.4+ and MySQL 8+ has been implemented in Webmin 1.960 and Virtualmin 6.13. Let us know if it works for you.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.