Connecting to a MySQL Database

[dhanyavnair]

Hi,

I am creating an application in PHP and MySQL.In the database connection statment I have written
$link = mysql_connect('localhost', 'root', '');
if (!$link)
{ die('Not connected : ' . odbc_error());}

This is working fine.But could u please tell me the statement , if the MySQL Server is installed is in another system.
I tried
$link = mysql_connect('servername', 'root', '');
if (!$link)
{ die('Not connected : ' . odbc_error());}

But is giving error:
Warning: mysql_connect(): Host '192.168.136.200' is not allowed to connect to this MySQL server in D:\project\files\PROJECT1\dbtest1.php on line 8
Not connected :

Thanks in advance,
Dhanya

[LordShryku]

The code will work, but the mysql server needs to be setup to allow an outside connection with that login information. Check the mysql manual under user management.

[dhanyavnair]

Hi ,

I am trying to connect from a another system which is connectd to the MySQL Server system using LAN.Can I use ODBC connection in PHP for MySQL.If Yes , how can it be done.I installed MYSQL ODBC driver 3.5.I

thanks and regards,
Dhanya