Mysql no access allowed for root user

youriv

Registered
Jul 17, 2020
1
0
1
uk
cPanel Access Level
Website Owner
How can I have access as the main login via Cpanel for mysql? When I connect tot the terminal and run any mysql commands I receive an access denied.

I need root access because logging in the assigned user is not allowing me to see the full features such as SHOW PROCESSLIST.
 

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,296
1,252
313
Houston
In order to have root access to MySQL you would also need root access to the server. This is not possible when hosting on a shared server. Your hosting provider would have root access to run this command.