The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

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

  1. mitchkill

    mitchkill Member

    Joined:
    Dec 26, 2008
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  3. mitchkill

    mitchkill Member

    Joined:
    Dec 26, 2008
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page