Can't connect to MySQL via PHP

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello all.

I used the code below successfully to connect to a MySQL db on one hosting provider.  I've moved the code to a new hosting provider with new values and it returns:

Access denied for user 'user'@'db.hostprovider.net' (using password: YES)

Even though I can copy and paste these three values (host, user and pass) and paste into Navicat to make a connection.  So the credentials are correct, but they are not authenticating when used in PHP.  I've tried making host "localhost" and "127.0.0.1"… both with the same result.

Can someone tell me what I am doing wrong here?

Appreciate it.

Thanks,
--Rick



$db_name = "mydb";
$vc_host    = "db.hostprovider.net"; 
$vc_user    = "user";
$vc_pass    = "pass";
                                                         
$connection = @mysql_connect($vc_host, $vc_user, $vc_pass);
$db = mysql_select_db($db_name, $connection);

echo mysql_error();




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux