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

mitchkill

• November 22, 2013 10:04

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

  • November 22, 2013 16:10

  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.

  0
• 

  mitchkill

  • November 22, 2013 16:22

  Michael, Thanks for getting back to me. To the best of your knowledge, should disabling the prefixing fix the problem that I am experiencing?

  0
• 

  cPanelMichael

  • November 22, 2013 17:14

  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.

  0

Please sign in to leave a comment.