User cannot access new databases created through their account

Operating System & Version
CentOS 7.9.2009
cPanel & WHM Version
100.0.4

edward144

Registered
Nov 29, 2021
2
0
1
UK
cPanel Access Level
Root Administrator
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

Administrator
Staff member
Oct 18, 2021
1,045
112
118
Houston, TX
cPanel Access Level
Root Administrator

edward144

Registered
Nov 29, 2021
2
0
1
UK
cPanel Access Level
Root Administrator
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.