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?
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?