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

Submitted by irieyuusuke on Fri, 11/22/2019 - 01:38

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

Submitted by JamieCameron on Sat, 11/23/2019 - 13:54

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

Submitted by irieyuusuke on Mon, 11/25/2019 - 00:29

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

Submitted by JamieCameron on Wed, 11/27/2019 - 00:39

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

Submitted by dowell22 on Mon, 12/16/2019 - 06:42

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.

Submitted by IssueBot on Sat, 11/07/2020 - 07:30

Status: Fixed » Closed (fixed)

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