The “User Permissions” portion of the MySQL Database Server config appears to be broken. I use Maria DB 10.4.13. Users listed under “User Permissions” have the “Permissions” column reading “None”, except for the “root” user, who has “All”. When attempting to add permissions to any user, I get the following error:
" Column ’ select_priv’ is not updatable ".
I could probably figure out how to adjust permissions for users using SQL commandline, but it would be a lot nicer to adjust via the UI.
The “Database Permissions” tab also has issues. It took me forever to figure out that trying to give a user access to “Any” database or “Matching pattern” has no effect whatsoever. A separate permission entry for each database, per user, is required to get this working.
FoulFoot