I have successfully set up the phpmyadmin for my clients and now they have their own user/pass/databases. But they all can access their databases from one site like www.site.com/phpmyadmin/.

How could it possible that every client can access the phpmyadmin from his website like www.clientsite.com/phpmyadmin/ for managing his database and he will not have to go to the one centeral site from where he manage his database.

Also one more thing is it possible that I can add a link for database management (Phpmyadmin link button) in clinet control pannel

Any will will be appreciated.

Aamir

Here's a sample line that you most likely already have in your httpd.conf file:
Alias /icons/ "/usr/local/apache/icons/"

Just like the line above, you can add your own Aliases, for example:
Alias /phpmyadmin/ "/path/to/phpmyadmin/"

Thanks for reply.
Globlaizing the phpmyadmin for all the websites. I tried it before but when ever I tried to open the site form users website its open directly without any authentication and gives me an error on both frames.

For the other question in which file should i need to change for adding the phpmyadmin link forclients siteadmin

Munaf,

Can you explain me in some steps how to setup phpMyAdmin Globally?

Originally posted by munaf
Thanks for reply.
Globlaizing the phpmyadmin for all the websites. I tried it before but when ever I tried to open the site form users website its open directly without any authentication and gives me an error on both frames.


Try to start up a new browser window ( not by File New, but through the startmenu ) The enter the clientdomain.com/phpmyadmin. Old authentications are kept when you go from one page to another so if you are already authenticated by some other application phpmyadmin will use that.

Originally posted by munaf
For the other question in which file should i need to change for adding the phpmyadmin link forclients siteadmin
You dont. The code is messy and there are a lot of CGI scripts and CGI classes to mess with. Also, if you do you loose your warranty.

Dear dominet

I am still searching the way to do that I was did it but its gives me lots of error. and ASPCode.net also describe that but I havent check that problem that ASPCode.net tells about the authetication.

ASPCode.net

what if I use the adavnce authentication and is the authentcation failuler will still take [lace.


I have an Idea to to redirect the customers to the phpmyadmin page that I will made a default page for all the clients that when ever the site is created this file will place in the clients directory and he can open this file and access the phpmyadmin page. Actually the point is that this page will redirect the user to the main site where the actual url of phpmyadin is recide and then the user can do authentication and use his database.

What you think is it a good approach or not :)

Munaf :confused:

Greatn was just about to do this then I discover that there are 2 different posts that say how to do this but 1 says to do it in httpd.conf and the other in srm.conf !

Which one is the correct one?

Hoot

Using advanced authentication is a must for this, then, you edit the srm.conf and add a symlink to the primary phpmyadmin installation, then each site will have site1.com/phpmyadmin/ available, next issue and the reason for advanced auth is that you create the DB from phpmyadmin, then from main panel add a user with no permissions, then from users table select the user and choose GRANTS, select the radio button for the DB drop down and select the correct DB then give that user all permissions for the users DB, then save then restart the mysql and the user/s will only be able to see/edit thier own DB's from /phpmyadmin/ from thier website. search forum.rackshack.net for a more detailed how-to of what I just explained.. keywords phpmyadmin

Mouse

Well I think that there is no need to do a symlink, I prefere the alias methode and it works fine !
Here is a how to for people who aren't very good with telnet (like me a few weeks ago !)

1) su the root ("su") and enter password
2) go beck to root cd ../../../../../ (I don't know why but when I do "su -" I cant access the filders afterwards
3) "cd etc" etc... till you get to the conf folder where srm.conf and httpd.conf are
4) You can edit either but I chose srm.conf and it works fine !
5) so make a backup :
cp -a srm.conf srm.conf.bak
then edit srm.conf
pico srm.conf
Go to bottom of srm.conf and add alias
then controlx choose yes the press enter
now restrat apache
su -
etc/rc.d/init.d/httpd restart
Should work now !

hoot :stickout