|
am I being daft....
As regards accessing a mySQL db from a package other than the one it was bought with (I gather it's possible)....
FOR Example....
I buy a mySQL db for package 'Foo' and want to access it from package 'Bar'. All the connection I information I provide in the PHP is:
server IP: pear
db name: Fred
username: Jim
password: 1234
and I use something like
$link = mysql_connect('pears ip', 'Jim', '1234');
$usedb = mysql_select_db("Fred", $link);
all very well within the original package
I'm assuming that all the mysql dbs are on one IP. SO... does the server only allow _globally_ unique db names ... I'm guessing not ... How does the server know which database I want when i'm pointing to from another package? That is to say, if I create database Fred with Jim as a user, how does the server know that I want /that/ database from package 'Bar'. Or is there only one fred on the whole of pear?
I've explained that terribly badly.
Or am I missing something terribly, terribly simple?
|