can not connect to mysql server

[niroshan]

Hi,
I have a small script that connect to the mysql server which is installed in local host. This is my code,

mysql_connect("localHost","<userName>","<password>") or die ("Error connecting to mySQL Server");
mysql_select_db("<db name>") or die ("Could not select database: ");

print "Connection success!!!!!!";

This is simply print "Connection success!!!!!!" if the connection is ok..

This has no error its works fine.. But my problem is i need to access this mysql server from another server. (Basically from another web site)

becasue my application is running on a different server and my database is reside in a different server.

so i remove locahost and replece it with with the domain name such as ,

mysql_connect("www.whatever.com","<userName>","<password>") or die ("Error connecting to mySQL Server");

But it says "Error connecting to mySQL Server" !!!

whats worng with my code... can i access the server like this??? if not how???

need a speedy reply....

regards,
niroshan

[RossC0]

If you are trying to access from another server - you need to put the right server in instead of 'LocalHost'.

Also you will have to make sure that your user has permission to access the database from another server and not just localhost.

[niroshan]

Hi,

thanx for your reply... yes you are right i didn`t had any Access Hosts other than localhost.

then i added new Access Hosts called my domain.com.. eg:

niroshan.com (here i dont have to add www right??? )

but it gave me the same error!!!1 whats worng???

this is my code,

<?php

mysql_connect("niroshan.com","<user name>","<password>") or die ("Error connecting to mySQL Server");
mysql_select_db("<dbName>") or die ("Could not select database: ");

print "Connection success!!!!!!";

?>

[drew010]

if you add a username, make sure it contains their full ip or domain and when you pass username in, it needs to be like mysql_connect("niroshan.com", "someuser@11.11.11.11", "password");

[niroshan]

Hi,
thanx for the reply...

Please specify whether i need to add username plus domain name as,

[e-mail]

normally in local host the username is specified as loginName_username.
the login name is the 'username' that i used for FTP and username is the database user name.

so as you suggested i wrote the code as below,

mysql_connect("niroshan.com","[e-mail]","password") or die ("Error connecting to mySQL Server");
mysql_select_db("dbName") or die ("Could not select database: ");

print "Connection success!!!!!!";

but still it gives me the same error?????

[RossC0]

This should work:

mysql_connect("username","hostname","password") or die ("Error connecting to mySQL Server");
mysql_select_db("dbName") or die ("Could not select database: ");

print "Connection success!!!!!!";

Your mysql user will look like: usename@hostname - in mySql Admin or phpAdmin - whichever you use. Simply split the two elements at the @:

Username is your mysql user. - Who MUST have access from the hostname.

Hostname - the full hostname i.e. www.niroshan.com (niroshan.com may work not 100% sure).

So if configured in MySQL correctly this should be fine:

mysql_connect("username","niroshan.com","password") or die ("Error connecting to mySQL Server");
mysql_select_db("dbName") or die ("Could not select database: ");

print "Connection success!!!!!!";