Connecting to MySql

[Chuckie]

I've done this before.. but from some reason I can't connect to MySql sucessfully

Here is what I have:

 
 <?php
 error_reporting  (E_ERROR | E_WARNING | E_PARSE);
 
 $dbhost = "localhost";
 $dbuser = "root";
 $dbpasswd = "IceCream";
 $dbname = "shields";
 
 
 /*Connect to the database*/
 if(!$db = @mysql_connect("$dbhost", "$dbuser", "$dbpasswd"))
     die('Could not connect to database');
 if(!@mysql_select_db("$dbname",$db))
     die('Could not connect to database $dbname');
 ?>

Is there a way to get a more specific error?

What are some common problems when connecting from PHP to MYSQL

I gave root access to the DB in question. The pw, username and DBname are correct.

Any Idea's

Chuck

[swdev]

try this

   $dbhost = 'localhost';
   $dbuser = 'root';
   $dbpasswd = 'IceCream';
   $dbname = 'shields';
   
   /*Connect to the database*/
 $db = @mysql_connect($dbhost, $dbuser, $dbpasswd) or die ('Could not connect to server ' . $dbhost . ' due to ' . mysql_error());
   mysql_select_db($dbname, $db) or die ('Could not connect to database ' . $dbname . ' due to ' . mysql_error()); 

[Chuckie]

try this

    $dbhost = 'localhost';
    $dbuser = 'root';
    $dbpasswd = 'IceCream';
    $dbname = 'shields';
    
    /*Connect to the database*/
 $db = @mysql_connect($dbhost, $dbuser, $dbpasswd) or die ('Could not connect to server ' . $dbhost . ' due to ' . mysql_error());
    mysql_select_db($dbname, $db) or die ('Could not connect to database ' . $dbname . ' due to ' . mysql_error()); 

Thanks for the code. It worked great!

With that said here is what I got...

 Could not connect to server 127.0.0.1 due to Client does not support authentication protocol requested by server; consider upgrading MySQL client

[Chuckie]

Here is what I found from MySql on the issue: http://dev.mysql.com/doc/mysql/en/old-client.html

[swdev]

My pleasure