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

systems84601

• September 18, 2014 11:01

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 */

• 

  cPanelMichael

  • September 18, 2014 16:12

  [quote="systems84601, post: 1732951">This user doesn't have permissions to see databases that I havin imported from the mysql commandline.
  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.

  0

Please sign in to leave a comment.