|
|
Posted by Jerry Stuckle on 09/27/07 03:52
Chenky wrote:
> I've been trying to nut this error out for the last three days to no
> success. Here's the code:
>
> $usern = "myusername";
> $passw = "mypassword";
> $db="mydatabase";
>
>
> $link2 = @mysql_connect("localhost", $usern, $passw);
> if (! $link2) {
> die("Connect error.");
>
>
> }
>
>
> mysql_select_db($db) or die("DB Select error");
>
> $status = mysql_query("SELECT * FROM members WHERE usern='$user'");
>
>
> while ($display = mysql_fetch_array($status)) {
>
>
> print $display['usern'];
>
>
>
> }
>
>
> mysql_close($link2);
>
> (Obviously Ive change the real database name, user and password, but
> rest assured the real ones are correct - this i have triple and
> quadruple checked)
>
>
> On a whim I changed the $status variable to:
> $status = mysql_query("SELECT * FROM members WHERE usern='$user'") or
> die (mysql_error());
> and was given this error:
>
>
> Access denied for user 'myusername@localhost' (Using password: NO)
>
>
> This is what confuses me - why isn't it recognising the use of
> password? All help appreciated.
>
You're using the wrong userid/password combination.
Talk to your host to see what the should be.
Of, if it's your own server, set the permissions in MySQL correctly,
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|