[Resolved] root password problems

[jadeddog]

hey there, so i setup mysql and php on a new puter and im having some password problems

im using winXP btw w/ IIS

the install went fine, and then i went to command line and entered:

set password for 'root' @ 'localhost' = password('newpwd');
set password for 'root' @ '%' = password('newpwd');

im pretty sure that is the correct method for setting up passwords, but then when i try and do something, im always getting "mysql_connect(): Access denied for user: 'root@localhost' (Using password: YES)" as an error

so obviously the password isnt set up properly.... the code is fine (since i just copied it from a working maching) and the user/password is the same onthe working maching as it is on the new machine

so what im asking is: am i doing this wrong? and is there a way to see the username/passwords in MySQL from command line in XP?

thx for any help

[luxluxlux]

If your password hasn't been set correctly, the default 'root' MySQL account has no password. Try logging in with an empty password and see if that works. Also, if you didn't "flush privileges" in the DB (it's an SQL command), then MySQL will continue to use the old settings.

Also, make sure MySQL is running -- sometimes error messages seem like a connection failure but the actual problem is MySQL isn't running. This is often the case with the error message "Can't connect to local MySQL through socket /tmp/mysql.sock".

Hope this helps. 🙂

Cheers,

Lux

[jadeddog]

i thought the flush command was only for when you were updating the user table directly, through an "update" command?

[jadeddog]

figured it out, it was something that i was doing, thx for the help