full phpmyadmin access from root user

MaRiOsGR66

Well-Known Member
Feb 18, 2011
112
1
68
cPanel Access Level
Root Administrator
Hello,
is there any way to be able as root user to check every mysql database in the server via phpmyadmin?
because when I'm trying to check (see some tables) a mysqldb for a customer and logged in as root
I get a denied message and I have to login as client (which is time consuming etc).
 

quietFinn

Well-Known Member
Feb 4, 2006
2,028
542
493
Finland
cPanel Access Level
Root Administrator
Hello,
is there any way to be able as root user to check every mysql database in the server via phpmyadmin?
because when I'm trying to check (see some tables) a mysqldb for a customer and logged in as root
I get a denied message and I have to login as client (which is time consuming etc).
AFAIK as root you should be able to access any database in the server.

Did you try if resetting mySQL root password would help?
 

MaRiOsGR66

Well-Known Member
Feb 18, 2011
112
1
68
cPanel Access Level
Root Administrator
thank you for your reply,

I only used to press on phpmyadmin throught the clients'page in which there wasn't a login page, for phpmyadmin,
only the message to logout cpanel and relogin as client,

after reading your message I checked on the search box of WHM for phpmyadmin and I found the link :)
didn't thought of it earlier!

thank you anyway for the reply quietFinn


Also Infopro thanx!!!
i was so "blind"....