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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    42,734
    Likes Received:
    1,706
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
    #2 cPanelMichael, Mar 20, 2012
  3. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,609
    Likes Received:
    31
    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.
     
    #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,609
    Likes Received:
    31
    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.
     
    #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. SupraMario

    User mysql grant permission error + phpmyadmin blank screen

    SupraMario, Dec 11, 2017, in forum: Database Discussions
    Replies:
    10
    Views:
    652
    behinam
    Dec 28, 2017
  2. dilios

    MySQL users in DB but missing from cPanel

    dilios, Nov 7, 2017, in forum: Database Discussions
    Replies:
    1
    Views:
    271
    cPanelMichael
    Nov 7, 2017
  3. albatroz

    The system cannot grant privileges to the MySQL user

    albatroz, Oct 22, 2017, in forum: General Discussion
    Replies:
    2
    Views:
    333
    cPanelMichael
    Oct 24, 2017
  4. electric

    Possible for end-user to see all their active mysql processes?

    electric, Sep 12, 2017, in forum: Database Discussions
    Replies:
    5
    Views:
    425
    cPanelMichael
    Sep 13, 2017
  5. Nirjonadda

    mysqldump: Got error: 1045: Access denied for user

    Nirjonadda, Aug 30, 2017, in forum: EasyApache
    Replies:
    13
    Views:
    1,648
    cPanelMichael
    Sep 11, 2017

Share This Page