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!

How can I make cpanel/phpmyadmin use the same user (root) ever time I login?

Discussion in 'Database Discussion' started by systems84601, Sep 18, 2014.

  1. systems84601

    systems84601 Registered

    Joined:
    Sep 18, 2014
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I am having difficulty with phpmyadmin. It appears that when I connect to phpmyadmin from cpanel it creates a new user everytime I login i.e (cpses_blvv95hnn4@localhost). This user doesn't have permissions to see databases that I havin imported from the mysql commandline. I'm getting around it by giving the new cp user permissions, but this is not a real solution since I get a new user every time I log out and then in again.

    How can I make cpanel/phpmyadmin use the same user (root) ever time I login?

    ---------------------------------------------------------------
    THIS IS MY CONFIG.INC.PHP FILE SERVER PARAMETERS
    ------------------------------------------------------------------

    $cfg['Servers'][$i]['auth_type'] = 'cpanel';

    /* Server parameters */
    //cpanel:$cfg['Servers'][$i]['host'] = 'localhost';
    $cfg['Servers'][$i]['host'] = 'localhost';
    $cfg['Servers'][$i]['connect_type'] = 'tcp';
    $cfg['Servers'][$i]['compress'] = false;
    $cfg['Servers'][$i]['user'] = 'root'; // MySQL user
    $cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed
    // with 'config' auth_type)
    /* Select mysql if your server does not have mysqli */
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

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

    Have you mapped your databases to the account using the "/usr/local/cpanel/bin/dbmaptool" utility? If not, you can use that utility from the command line, or via:

    "WHM Home » SQL Services » Database Map Tool"

    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