PHP SQL - Password Problem

Author

Password Problem

Philippe Krait

2005-03-04, 8:56 am

Hello,

I am having a probably stupid problem but...

What happens is, when I put a password in the mysql_connect function
(mysql_connect('localhost', 'toto', 'toto')), I get an error message:

Warning: mysql_connect(): Access denied for user 'toto'@'localhost'
(using password: YES) in c:\program files\easyphp1-7\www\manage.php on
line 27
Could not connect : Access denied for user 'toto'@'localhost' (using
password: YES)

When I don't put the password, everything works fine (But this is
because I have all privileges for local users anyway, something that I
am trying to change).

I suspect a set-up somewhere about encryption somehwere, but can't find it.

Any good ideas ?

Thanks in advance,

Philippe

HawkEye

2005-03-04, 8:56 pm

Philippe Krait wrote:
> Hello,
>
> I am having a probably stupid problem but...
>
> What happens is, when I put a password in the mysql_connect function
> (mysql_connect('localhost', 'toto', 'toto')), I get an error message:
>
> Warning: mysql_connect(): Access denied for user 'toto'@'localhost'
> (using password: YES) in c:\program files\easyphp1-7\www\manage.php on
> line 27
> Could not connect : Access denied for user 'toto'@'localhost' (using
> password: YES)
>
> When I don't put the password, everything works fine (But this is
> because I have all privileges for local users anyway, something that I
> am trying to change).
>
> I suspect a set-up somewhere about encryption somehwere, but can't find it.
>
> Any good ideas ?
>
> Thanks in advance,
>
> Philippe

Doesn't look like your password is set. Try setting it again and then flush
the priviledges table.

Easier way is to install and use phpMyAdmin if possible.

--
Regards

Neil

Registered Linux User 324599
Time is nature's way of keeping everything from happening all at once.
Space is nature's way of keeping it all from happening to you.

Philippe Krait

2005-03-04, 8:56 pm

HawkEye wrote:
>
>
> Doesn't look like your password is set. Try setting it again and then
> flush the priviledges table.
>
> Easier way is to install and use phpMyAdmin if possible.

Thanks for your reply,, but I have phpmyadmin installed, and I can see
all my accounts with the encrypted passwords, and Ic an even see the
difference in the user table when I change the settings of mysql from
standard to the "OLD PASSWORD" setting.

But the problem above occurs whenever I try and set a password in a
client...

Philippe

Sponsored Links