Web Hosting Talk : Web Hosting Main Forums : Dedicated Server : phpMyAdmin Multi User Setup

[Nology]

I'm running phpMyAdmin v 2.5.0 and wish to set it up so each of my virtual sites on my RaQ550 can have access to one central version of phpMyAdmin and to just there DB.

However, I have know idea how to do this. Can anybody do this for me (I'm happy to pay! ) or do they know of a 'simple' tutorial to walk me through it?.

NOLOGY

[Eric Lim]

Hmn.. Not sure I fully understand the questions.

If you want all users to see only their databases, edit the line in phpMyAdmin config at its directory:

$cfg['Servers'][$i]['auth_type'] = 'cookie';

or 'httpd'

If there is not what you asking for, sorry and please explain again.

[Pingouin]

Easy to do on a RAQ 550.
Use http authentication, and each user will only see their own databases.
Is your Apache server configured so that each user can access PHPMyAdmin ?
What is your current PHPMyAdmin config and what can you do / not do right now ?
Always accurately describe your problem

[Nology]

Use http authentication, and each user will only see their own databases.

How exactly is this done? Is it with a .htaccess file?

Is your Apache server configured so that each user can access PHPMyAdmin ?

Once again how is this done?

What is your current PHPMyAdmin config and what can you do / not do right now ?

My PHPMyAdmin config is set to 'config', should I change this to 'httpd' or 'cookie'?

[Pingouin]

quote:
How exactly is this done? Is it with a .htaccess file?

Yes, you get a prompt where username and pw are entered, then you only see DBs that the user is allowed to see, manage, etc.

quote:
Once again how is this done?
***
You didn't touch anything to your web server ?
If you want your users to use PHPMyadmin you have to instruct your Apache server to do so...
Here is our config added in smr.conf :

### Global phpMyAdmin pour tous les Virtual Hosts ###
Alias /phpmyadmin /home/PHPMyAdmin/
Alias /PHPMyAdmin /home/PHPMyAdmin/


restart Apache to apply

quote:
--------------------------------------------------------------------------------
What is your current PHPMyAdmin config and what can you do / not do right now ?
--------------------------------------------------------------------------------

My PHPMyAdmin config is set to 'config', should I change this to 'httpd' or 'cookie'?
Is your root account modified ? Can you access your mysql server on command line ?

[Nology]

Pingouin, great thanks... got it working.