Access phpMyAdmin as a non-administrative user

asked Apr 25, 2012 in General by MirrorXYZ (1,400 points)
Hi there,

Since I installed phpMyAdmin,  only the root user could login successfully. Now I need to give another user access to phpMyAdmin, I want to access with a non admin user . Can anyone please tell me how to do this?

Thanks and regards,

1 Answer

0 like 0 dislike
answered Apr 25, 2012 by RalphK (5,800 points)
To give access to a user follow these steps:
1.Log into your cPanel web server via Secure Shell (SSH) as the root user.
2.Open the phpMyAdmin file using the following command:
pico /usr/local/cpanel/base/3rdparty/phpMyAdmin/
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