MariaDB 10.4 mysql.user moved ot mysql.global_priv

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/

Status: 
Active

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.

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