Specific Database grant role

[fufuutya]

I want to create a role that allows me to perform all actions within the database but prevents me from modifying any user or role settings. After creating the role, I encountered an issue where I couldn't access the database when logged in using Attu. To resolve this, I granted 'global *' privileges, allowing me to log in to the database. How should I configure this properly?

[yhmo]

Read this pdf to know how to crate a role for a specific database:
roles_users.pdf

[fufuutya]

I set up following your instructions, but when I was trying to log in, it showed:

These are the configurations I did:

[yhmo]

Login with the root user, edit the role_b/role_b, and add a privilege "ListDatabase" to them. The Attu requires this privilege to show the database list.

Then login with dbbuser, you will see an error "PrivilegeSelectOwnership", but it doesn't matter. You can switch to dbb database and do the operations with the privileges that you have.