RE: Can't connect to MySQL via PHP

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

 



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



[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