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!

MySQL user not present in cPanel afer migration from Plesk...

Discussion in 'Migrate to cPanel' started by fucine, Mar 18, 2012.

  1. fucine

    fucine Member

    Joined:
    Jan 28, 2005
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    151
    I've recently migrated some domains from a Plesk 9.5.2 box into a WHM/CPanel (11.30.6.4) one. Everything worked out flawlessly, so both MySQL databases and PHP files were correctly transferred, and email accounts as well.
    The strange situation is that under "cPanel > MySQL Databases" I can see the original DBname, but no way to have any reference to originale DBuser (which in this particular case is identical to DBname). Anyway the PHP socket to the DB has been migrated and preserved as it originally was:

    // database values
    $phpwcms['db_host'] = 'localhost';
    $phpwcms['db_user'] = 'string';
    $phpwcms['db_pass'] = '*******';
    $phpwcms['db_table'] = 'string';

    In fact site is up&running, so I do suppose that also "string" DBuser is present, and furthermore I can access phpmyadmin by logging with "string" as DBuser and the corresponding password "*******" as well. I can see the DBname, and manipulate tables, ecc.
    On the other hand the box "Current Users" under "cPanel > MySQL Databases" page states: "There are no users associated with your account".

    Selezione_001.png

    Can someone help in finding where the error resides?
    Should I remap DBuser to DBname via WHM?
    Thanks in advance!
     
    #1 fucine, Mar 18, 2012
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    Would you be able to open a support ticket so we can take a closer look? You can submit a ticket via:

    Submit A Ticket

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelMichael, Mar 20, 2012
  3. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,608
    Likes Received:
    32
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Is the database name the same as the cPanel account username? If the cPanel account username is string, the database name is string and the database username is string, only the database would show up in cPanel > MySQL databases as we automatically map cPanel username to have access to the databases under the account.

    I only mention this as I'm not certain if the above is the case or not, since we don't know the actual cPanel account username. That's the only scenario where I know the user will not be listed in cPanel > MySQL databases area. If you have database prefixing turned off (which we recommend for Plesk to cPanel migrations), then you can certainly have a database named string for a cPanel user named string. With database prefixing enabled, you'd end up with string_string instead, since we always force the cPanel username to prepend to the database name with an underscore under prefixing.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 cPanelTristan, Mar 20, 2012
  4. fucine

    fucine Member

    Joined:
    Jan 28, 2005
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    151
    Yes, I do confirm: database name is just the same as database user. And it's also the same as cpanel user. And if I try adding a new database user then I have: "string_" + the name of the user which I'm allowed to freely choose. This is not a weird situation, but quite a strange one. So no way to have - via WHM tweaks (or command line) - the database user "string" beeing mapped to the database name "string", so that it (dbuser named "string") will magically appear in cPanel? Thanks in advance for any possible suggestion.
     
    #4 fucine, Mar 20, 2012
  5. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,608
    Likes Received:
    32
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    If the cPanel username is string and the cPanel database username is string, then no you cannot have that user appear in cPanel > MySQL databases area for database users listed. That is because the cPanel username is always allowed to access the MySQL databases and automatically granted privileges to them (for PhpMyAdmin access as one example).

    The cPanel username is also a database user that cannot be removed, which is another reason why it doesn't appear in cPanel > MySQL databases area. If it did show up there, then the client could remove that user and break functionality with services like PhpMyAdmin access.

    That's simply how cPanel works.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 cPanelTristan, Mar 20, 2012
  6. fucine

    fucine Member

    Joined:
    Jan 28, 2005
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    151
    That's simply a great reply. Case closed and solved. Thanks for in depth explanations!
     
    #6 fucine, Mar 20, 2012
(You must log in or sign up to post here.)
Loading...
Similar Threads - MySQL user present
  1. Maning

    limit user connections on mysql

    Maning, Oct 11, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    60
    cPanelLauren
    Oct 12, 2018
  2. ca2236

    Question on mysql and usernames

    ca2236, Sep 7, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    75
    cPanelMichael
    Sep 11, 2018
  3. Bert de Jong

    Change MySQL User Password in WHM Issue

    Bert de Jong, Sep 6, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    105
    cPanelLauren
    Sep 11, 2018
  4. planetjoin

    SOLVED MySQL usernames with no underscore?

    planetjoin, Aug 22, 2018, in forum: Database Discussion
    Replies:
    3
    Views:
    105
    cPanelLauren
    Aug 23, 2018
  5. udee

    The system failed to drop the MySQL user error

    udee, Jul 14, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    171
    cPanelMichael
    Jul 16, 2018

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.
    Accept Learn More...
    Dismiss Notice