From: Ashley Sheridan [mailto:ash@xxxxxxxxxxxxxxxxxxxx] Sent: Saturday, January 12, 2013 10:03 AM To: admin Cc: 'Rick Dwyer'; php-general@xxxxxxxxxxxxx Subject: RE: Can't connect to MySQL via PHP On Sat, 2013-01-12 at 12:56 -0800, admin wrote: > -----Original Message----- > From: Rick Dwyer [mailto:rpdwyer@xxxxxxxxxxxxx] > Sent: Saturday, January 12, 2013 8:26 AM > To: php-general@xxxxxxxxxxxxx > Subject: 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); Please at least use mysqli_* functions. Every time someone recommends we use mysql_* functions, a kitten kills a programmer. Thanks, Ash http://www.ashleysheridan.co.uk Ash, The question was asked about mysql functions. As much as the php list would like to force people from using mysql, I guess you should not have invented it, if you don't want people to still use it. Shoots a small fluffy kitten with big blue eyes... Waste a cap save a gui!!!!
