Web Hosting Geeks | Web Hosting Experts
Need help? Call us 1(866)TOP-HOST

14625 reviews 1734 hosting providers

Questions & Answers

Access phpMyAdmin as a non-administrative user

Apr 25, 2012 by MirrorXYZ
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 votes
Apr 25, 2012 by RalphK
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 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