Re: Problem mysql_connect : True PB ?
- From: Lammi <Lorenz.Lammersdorf@xxxxxxxxx>
- Date: Thu, 30 Aug 2007 10:32:36 -0000
hi,
port 3306 is default. should be ok, if you doesn't change my.cnf. in
my.cnf the line "port=3306" must exist.
is there a firewall between the servers?
it's never a good idea to post ip-adresses, usernames or passwords of
your enviroment!
regards
lorenz
On 30 Aug., 11:52, goodm...@xxxxxxxxxxxxxxxxxxxxxx wrote:
Paris,
Le 30 08 MMVII,
Hi,
I have a problem using 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
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
.
- References:
- Problem mysql_connect : True PB ?
- From: goodmann
- Problem mysql_connect : True PB ?
- Prev by Date: mod_rewrite problem
- Next by Date: Re: [PHP] Pragmatically changing a "Record Number"
- Previous by thread: Problem mysql_connect : True PB ?
- Next by thread: mod_rewrite problem
- Index(es):
Relevant Pages
|
