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

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,857
    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.
     
    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. udee

    The system failed to drop the MySQL user error

    udee, Jul 14, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    108
    cPanelMichael
    Jul 16, 2018
  2. tyuuu

    mysql_pconnect can not work after change password/username

    tyuuu, Jun 19, 2018, in forum: Database Discussion
    Replies:
    10
    Views:
    120
    cPanelLauren
    Jun 20, 2018
  3. SupraMario

    User mysql grant permission error + phpmyadmin blank screen

    SupraMario, Dec 11, 2017, in forum: Database Discussion
    Replies:
    10
    Views:
    984
    behinam
    Dec 28, 2017
  4. dilios

    MySQL users in DB but missing from cPanel

    dilios, Nov 7, 2017, in forum: Database Discussion
    Replies:
    1
    Views:
    427
    cPanelMichael
    Nov 7, 2017
  5. albatroz

    The system cannot grant privileges to the MySQL user

    albatroz, Oct 22, 2017, in forum: General Discussion
    Replies:
    2
    Views:
    545
    cPanelMichael
    Oct 24, 2017

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