I had an issue that prevented me from editing and exporting Routines stored in databases. So I assumed it was because normal users doesn’t get these privilages by default.
So I logged in as root, and tried again. To my surprise, the same issue persisted with the root user too.
When I checked if I can edit the user permissions, the User Accounts Tab is showing “Not enough privilege to view users”.
I don’t understand why even the root user doesn’t have the permission to view or edit other users’ permissions, or even the basic permission to edit or export a stored procedure in routines tab.
If anyone could help me solve this, I’d be really greatful.
Just now I tried the steps mentioned in the link you shared. But while executing the query on step 4, I’m getting the error: The user specified as a definer (‘mariadb.sys’@‘localhost’) does not exist.
I tried to open the table mysql.user but it’s showing a blank screen.