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?
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.
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.
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.
Thank you.