MySQL: 4.1.20 DB from external servers. Why ?

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

Re: MySQL: 4.1.20 DB from external servers. Why ?

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