Cannot connect to MySQL using
| From: | Nur_Adman at fmi dot com | Date: | Wed, 29 Mar 2006 22:31:20 +0000 |
| Subject: | Cannot connect to MySQL using | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-41627@lists.php.net to get a copy of this message | ||
Dear All,
I need some help. I`m trying to connect to MySQL using these script :
<?php
$dbHostname = "localhost";
$dbUsername = "root";
$dbPassword = "";
$dbName = "cms";
// Make connection to database
// If no connection made, display error Message
$dblink = mysql_connect($dbHostname, $dbUsername, $dbPassword) or
die("Error !! Unable to connect to database");
// Select database or print error message if unsuccessful */
mysql_select_db($dbName) or die( "Unable to select database
".$dbName);
?>
But if I changed the Hostname with the Server Name/IP Address (not using
localhost), the error message become :
Warning: mysql_connect() [function.mysql-connect
<http://tu-lip-nt4/CMS/forecast/function.mysql-connect>
]: Host
'157.47.115.180' is not allowed to connect to this MySQL server in
c:\wamp\www\CMS\forecast\includes\db_connection.php on line 10
Error !! Unable to connect to database
What should I do?
Thanks & Regards,
Anita