|
|
Posted by Captain Paralytic on 08/30/07 10:26
On 30 Aug, 10:55, goodm...@fiduciairedefrance.com wrote:
> Paris,
> Le 30 08 MMVII,
>
> Hi,
>
> I have a problem to connect to MYSQL from one server to another
> server.
>
> In other words, On server A, I have my PHP files, and on server B, I
> have MySQL installed.
> Localhost is fine, but an I.P. as a host lead to an error : Warning:
> mysql_connect(): Can't connect to MySQL server on '207
>
> Here is what I got :
>
> 1) CONFIG.PHP
> $dbtype = "mysql"; ##Defines Database type
> $dbhost = "207.36.15.13:3306"; ##Your host
> $dbuname = "maincontheaderbox"; ##Database Name
> $dbpasswd = "bobyken"; ##Database Password
> $dbase = "z_extras";
> maincontheaderbox is the root user getting all previleges.
>
> Comment : I mentioned PORT 3306. Not sure at all of that port (from
> OVH french.hosting services)
>
> 2) my.cnf MYSQL
>
> I ensured that my.cnf does not forbid outside mysql connections.
> skip-networking.http://guides.ovh.com/ConnexionDistanteMySQL
>
> 3) Doc
> -http://forum.ovh.com/archive/index.php/t-5716.html
> -http://fr.php.net/mysql_connect
>
> http://drupal.org/node/55108
> $db_url = 'mysql://My_Account_Name(A)_username:password@localhost/
> My_Account_Name(A)_databaseName';
>
> Many thanks for your help from your knowledge and experience.
>
> Bob
Do not multi-post. Cross-post if you must but don't multi post
It waste's people's time.
http://www.blakjak.demon.co.uk/mul_crss.htm
Navigation:
[Reply to this message]
|