|
|
|
|
||||||
![]() |
|
|
LinkBack | Outils de la discussion |
|
|
#1 |
|
Messages: n/a
Hébergeur: |
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 . My Regards Noman Robert Cougloff |
|
|
|
#2 |
|
Messages: n/a
Hébergeur: |
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 |
|
![]() |
| Outils de la discussion | |
|
|