> -----Original Message-----
> From: Rick Dwyer [mailto:[email protected]]
> Sent: Saturday, January 12, 2013 8:26 AM
> To: [email protected]
> Subject: [PHP] Can't connect to MySQL via PHP
>
> 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
Try this for me
-----------------------------------------------------------
$db = mysql_connect($vc_host, $vc_user, $vc_pass);
mysql_select_db($db_name, $db);
if (!$db) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($db);
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
