Skip to main content

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?

Comments

2 comments

Date Votes
  • cPanelAnthony
    Hello! Could you confirm if the grants on the database are correct when this issue occurs?
    0
  • 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.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post