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:

1. Log into your cPanel web server via Secure Shell (SSH) as the root user.
2. Open the phpMyAdmin config.inc.php file using the following command:
   pico /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php
3. Within this file, find the following line of code:
   $cfg['Servers'][$i]['socket'] = '';
4. Change this line to the following:
   $cfg['Servers'][$i]['socket'] = '/var/lib/mysql/mysql.sock';
5. Next, find the following line of code:
   $cfg['Servers'][$i]['connect_type'] = 'tcp';
6. Change this line to the following:
   $cfg['Servers'][$i]['connect_type'] = 'socket';
7. Save and exit the file.
8. Restart MySQL using the following command:
   /etc/rc.d/init.d/mysql restart