Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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

Discussion in 'Database Discussion' started by mitchkill, Nov 22, 2013.

  1. mitchkill

    mitchkill Member

    Joined:
    Dec 26, 2008
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    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?
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,749
    Likes Received:
    1,885
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. mitchkill

    mitchkill Member

    Joined:
    Dec 26, 2008
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    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?
     
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,749
    Likes Received:
    1,885
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice