LinuxQuestions.org - phpmyadmin for each user

- Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)

- - phpmyadmin for each user (https://www.linuxquestions.org/questions/linux-newbie-8/phpmyadmin-for-each-user-169545/)

phpmyadmin for each user

hey, i have multiple users hosted on my red hat 9 box... is ther anyway i can like give each user their own phpmyadmin, so they can only see their own db's.... but they would have to login to the phpmyadmin thru http://mywebaddress.com:99 ? and it would ask for their user / pass....????

thanks

digital

I just recently set up phpMyAdmin on one of my hosting servers and that thing you'd like to set up is possible.

It's actually pretty simple because you need to set it within the config.inc.php file itself

open up config.inc.php file, and look for the following line:

Code:

...

$cfg['Servers'][$i]['auth_type']    = 'config';    // Authentication method (config, http or cookie based)?

...

All you need to do is change it to:

Code:

...

$cfg['Servers'][$i]['auth_type']    = 'http';    // Authentication method (config, http or cookie based)?

...

That's it, when you have people go to http://www.yourdomain.com/yourphpMyAdminfolder/
it should ask each visitor for the username/password of the MySQL database

Oh and it's always good to read the documentation of phpMyAdmin :P