There is an config.inc.php file that contains the settings. It actually connects to the mysql server in the same way that any PHP script (or any other client) would, using a host name/host IP address, user name, and password. It does not actually need to know any directory information on mysql.
hmm thanks for the reply but could you go a bit more in depth
just how it knows where the mysql is.
reason im asking is imagine i installed mysql 5 and say phpmyadmin v1 say
and this was done via using apachefriends (all in 1)
if i wanted to change versions of phpmyadmin say how would i tell the
new installation where to point to the mysql server/installed dir
as the new phpmyadmin installed cannot find the db, but the old one can.
hmm yep all that infomation is saved and is identical to the old version of the phpmyadmin which when installed it finds the db,table,data the lot
installed a newer version added the same info but it cant find the mysql server
so there must be a setting somewhere to point to where the sql server is installed too as if i change the folder name of the mysql installed directory
it can't find the sql server with new or old.
maybe this is something that no-one seems to know about
Mysql servers run as a service and listen to TCP/IP traffic on port 3306 (default.) As long as the mysql server is running, any client (PHP, Administrator...) can connect to it with the a correct host name, user name, and password.
If you have installed a mysql server in a different directory, so long as the server is configured and running you can connect to it.