Nology
05-05-2003, 03:46 AM
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
05-05-2003, 04:34 AM
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. :D
Pingouin
05-05-2003, 05:53 AM
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
05-05-2003, 08:38 AM
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'? :eek:
Pingouin
05-05-2003, 09:26 AM
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
05-06-2003, 01:43 AM
Pingouin, great thanks... got it working.
