Re: Can't connect to MySQL via PHP

On January 12, 2013 11:25:58 AM Rick Dwyer wrote: > 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 > > are navcat and php on the same machine? mysql user accounts can and often do take into account which machine the connection is comming from? > > $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