MySQL: 4.1.20 DB from external servers. Why ?

[Pseudonyme]

Hi,
No multi-post because we read that it was not pleasant, and lead to a
waste of time.

****

Question : Do you know how to access a MYSQL DB from an external
server.

MYSQL

We Created a user on SERVER1
Name : bobbob
Data Privilege : SELECT
INSERT
UPDATE
DELETE
FILE
Information related to connections
Server : % (all servers)
FLUSH PRIVILEGES ;
Then, on SERVER2 :
<?
$host = "207.36.16.15";
$user = "bobbob";
$pass = "bobbob";
$bdd = "adv_database";
?>

And HTML says : cannot connect to DB.
We tried tons of things.
We many thanks for any potential help.

My Regards

Noman Robert Cougloff

[J.O. Aho]

Pseudonyme wrote:

Hi,
No multi-post because we read that it was not pleasant, and lead to a
waste of time.

****

Question : Do you know how to access a MYSQL DB from an external
server.

1. The mysql-server machine must have open ports for the incomming connection
(default 3306)
2. There must be a mysql-user who has the privileged to connect from the
remote server.

Both must have been done, or else all connections will be failing.
--

//Aho