Posted by: Larsson (62.119.163.---)
Date: June 15, 2006 11:31AM

I want to open the MySQLconsole but it asks for a password. How can I fix the password? I have just installed wamp.

Options: ReplyQuote
Re: Passwords
Posted by: SkareCrow (
Date: June 15, 2006 11:45AM

You do not need to login.
By default the mysql root user password is null.
Just press <enter> when it asks you for your password and you will login just fine.
If you want to set a password you do this...

get into mysql console..
type: USE mysql;
type: UPDATE user SET Password=PASSWORD('yournewpassword') WHERE User='root';

now you can logout of mysql and then when you open the mysql console again you will need to use that new password to login

Options: ReplyQuote

Sorry, only registered users may post in this forum.