From: Ashley Sheridan [mailto:a...@ashleysheridan.co.uk]
Sent: Saturday, January 12, 2013 10:03 AM
To: admin
Cc: 'Rick Dwyer'; php-general@lists.php.net
Subject: RE: [PHP] Can't connect to MySQL via PHP
On Sat, 2013-01-12 at 12:56 -0800, admin wrote:
> -----Original Message-----
> From: Rick Dwyer [mailto:rpdw...@earthlink.net]
> Sent: Saturday, January 12, 2013 8:26 AM
> To: php-general@lists.php.net
> 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);
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!!!!
