It looks right on the function use, but you may want to check the
installation of the mySQL service to ensure you have the right setup. There
is normally always a password on root.

Also, I would be a little more careful of pasting your IP Address into a
message forum. I'm sure we are all honest people but you never know. Coupled
with your DB name we can now look at your data if we get in.

You didn't tell us what the error was when using 'localhost' versus the IP
address. What does it say then?

-----Original Message-----
Sent: Wednesday, March 29, 2006 2:31 PM
Subject: [PHP-DB] Cannot connect to MySQL using

Dear All,



I need some help. I`m trying to connect to MySQL using these script :




      $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




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
'' 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,




PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to