jump to navigation

phpMyAdmin Multiple Users Setup January 11, 2009

Posted by ModelR in UBUNTU LAMP Project.
trackback
THIS IS A SUBSECTION OF THE VERY VITAL UBUNTU LAMP SERVER PROJECT

You can find the full outline of this project here:
LINK: Very Vital Ubuntu LAMP Server Project Outline

Please support this project.
Make A Donation

Also see this website for more options: Configuring phpMyAdmin for multiple users

The goal that we wish to achieve, is to allow multiple users to use phpMyAdmin only seeing and having permissions for their own databases. The root user will be able to see all databases. To get to this goal we will have to make a few changes to the config file located here: /etc/phpmyadmin/config.inc.php

Before we begin we will make a backup of the file before editing it
$ sudo cp /etc/phpmyadmin/config.inc.php /etc/phpmyadmin/config.inc.php.master

Here is what will have to be changed:
Uncommented the following
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';

Uncommented and changed mysql to mysqli in the following line
$cfg['Servers'][$i]['extension'] = 'mysqli';

After this line
// $cfg[‘Servers’][$i][‘controlpass’] = ‘pmapass’;
We added this
$cfg['Servers'][$i]['hide_db'] = 'information_schema';

Then we added this line as the last line
$cfg['AllowUserDropDatabase'] = true;

That’s it.

Advertisements

Comments»

1. James - April 25, 2013

will this allow 250 people to use the same phpmyadmin at the same time?

2. phpmyadmin - Separate account for each users - January 26, 2014

[…] see each other's database as well as they can retrive data and delete other user's databases too. https://modelr.wordpress.com/2009/01/…e-users-setup/ http://alandoyle.com/blog/tutorials/…ultiple-users/ Please help me. Thanks & Kind Regards […]


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: