admin <admin@xxxxxxxxxxxxxxxxxxx> wrote: > > > > >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!!!! > > > > > > Actually, the question never mentioned mysql_* functions, so telling someone to use them is wrong. Thanks, Ash http://www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
