User cannot access new databases created through their account

[edward144]

I have a single user who is not granted access to any new MySQL databases created through their cpanel account. They can create the database and see it in the list, however it will not show up in phpMyAdmin. If I SSH in and login to MySQL directly as their user then use SHOW DATABASES, it will not show up. USE `database` also give an access denied error.

I have tested creating databases for other users as well and this is the only one having this issue. I believe it is due to me having to grant them the SUPER permission as one of their databases requires stored procedures which would not work otherwise.

I'm not sure what I can do to get things working for them again?

 

[cPanelAnthony]

Hello! Could you confirm if the grants on the database are correct when this issue occurs?

MySQL :: MySQL 8.0 Reference Manual :: 13.7.7.21 SHOW GRANTS Statement

dev.mysql.com

Also, when this issue occurs, can you manually map the database to the cPanel user?

Database Map Tool | cPanel & WHM Documentation

This feature allows server administrators to grant ownership of database objects (databases and database users) to a cPanel user.

docs.cpanel.net

 

[edward144]

I think that has pointed me in the right direction. The only grants were GRANT SUPER ON *.* TO 'user'@'%' IDENTIFIED BY 'password'. The database map tool is also very useful and not something I was aware of before. Everything seems to be working now and I have tested adding a new database successfully. Thanks.