MariaDB 10.4 mysql.user moved ot mysql.global_priv

Submitted by dowell22 on Thu, 01/30/2020 - 20:50

Since MariaDB 10.4, the User Permission portion of the MySQL Database module cannot modify data nor add new users. There is a small change with mysql.user.

All user accounts, passwords, and global privileges are now stored in the mysql.global_priv table. The mysql.user table still exists and has exactly the same set of columns as before, but it’s now a view that references the mysql.global_priv table. Tools that analyze the mysql.user table should continue to workas before.

Reference: https://mariadb.com/kb/en/authentication-from-mariadb-104/

Related issues: 
#67870: Cannot change dbuser password of MariaDB, when changing password of virtual server's administrator from virtualmin GUI.
Status: 
Closed (fixed)

Comments

Ilia's picture
Submitted by Ilia on Fri, 01/31/2020 - 01:42

Assigned: Unassigned »

Hi,

I will pass this to Jamie for a review. Thanks for the feedback.

Submitted by JamieCameron on Sun, 02/02/2020 - 11:14

There's ongoing work to switch Webmin from editing mysql.user directly to using alter user commands.

Ilia's picture
Submitted by Ilia on Sat, 10/24/2020 - 06:34

This has been implemented in Webmin 1.960 and Virtualmin 6.13 is going to have support for it (MariaDB 10.4+ and MySQL 8+) too. Let us know if it works for you.

You can continue discussion here as well.

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

Status: Fixed » Closed (fixed)

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