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.

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

Discussion in 'Database Discussions' 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 Forums Analyst
    Staff Member

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

Share This Page