Probleme mysql_connect : Connaissez ?
2 Message(s) by 2 Author(s) originally posted in php sql
| From: goodmann |
Date: Thursday, August 30, 2007
|
Paris,
Le 30 08 MMVII,
Hi,
I have a problem : MYSQL from one
server and PHP on 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 not 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
I ensured that my.cnf doesn't 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@xxxxxxxxxxx/
My_Account_Name(A)_
database Name';
Many thanks for your help from your
knowledge and experience.
Bob
| From: Captain Paralytic |
Date: Thursday, August 30, 2007
|
Don't multi-post. Cross-post if you must but do not multi post
It wastes people's time.
http://www.blakjak.demon.co.uk/mul_crss.htm
You continue to do this. Please stop.
You are unlikely to get much help whilst you continue to multi-post!
Next Message: mysql_connect : Here OUTSIDE connection.