How do I access phpMyAdmin as a non-administrative user?
The following article explains how to access phpMyAdmin as a non-administrative user. By default, when phpMyAdmin is installed, only the root user may login successfully. This is done as a security precaution. If you need to give a different user access, you may do so by updating the phpMyAdmin configuration file directly on the server.
NOTE: The following instructions involve updating configuration files directly on your server. If you are not familiar with updating configuration files, please contact support for assistance.
To give access to a user, please follow these steps:
- Log into your cPanel web server via Secure Shell (SSH) as the root user.
- Open the phpMyAdmin config.inc.php file using the following command:
pico /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php - Within this file, find the following line of code:
$cfg['Servers'][$i]['socket'] = ''; - Change this line to the following:
$cfg['Servers'][$i]['socket'] = '/var/lib/mysql/mysql.sock'; - Next, find the following line of code:
$cfg['Servers'][$i]['connect_type'] = 'tcp'; - Change this line to the following:
$cfg['Servers'][$i]['connect_type'] = 'socket'; - Save and exit the file.
- Restart MySQL using the following command:
/etc/rc.d/init.d/mysql restart
