Since Upgrade, Can't Edit DB or DB User Permissions

mitchkill

Member
Dec 26, 2008
9
0
51
I am running WHM 11.40.0 (build 24) and have a problem with editing the permissions on databases and users that were created in previous versions. These databases and users did not have a prefix when they were created several versions ago and now I receive an error message when attempting to edit them. For instance, I have database "genericdb" and db user "genericdbuser" for cPanel user "cpanelun." When I try to assign genericdbuser to genericdb and specify the permissions, I am greeted with the error message "You do not own the user (cpanelun_genericdbuser)!" I suppose that I could turn database prefixing off, but I'm a little worried that this will cause more issues in the future. Any ideas what I can do about this?
 

cPanelMichael

Technical Support Community Manager
Staff member
Apr 11, 2011
47,911
2,233
363
cPanel Access Level
DataCenter Provider
Twitter
Hello :)

I am not aware of any issues that disabling database prefixing would cause. It does not rename existing databases. Instead, it only ensures the account username prefix is not required for new database names. However, please note that disabling database prefixes is not reversible.

Thank you.
 

mitchkill

Member
Dec 26, 2008
9
0
51
Michael,
Thanks for getting back to me. To the best of your knowledge, should disabling the prefixing fix the problem that I am experiencing?
 

cPanelMichael

Technical Support Community Manager
Staff member
Apr 11, 2011
47,911
2,233
363
cPanel Access Level
DataCenter Provider
Twitter
It's difficult to say without knowing the full extent of the problem, however I don't see how it could cause any additional problems. It's also possible that you will need to modify the YAML file for the user in the /var/cpanel/databases directory to ensure it properly reflects the database ownership.

Thank you.