WampServer
Apache, PHP, MySQL
on Windows
Passwords
Posted by:
Larsson
(62.119.163.---)
Date: June 15, 2006 11:31AM
Hello!
I want to open the MySQLconsole but it asks for a password. How can I fix the password? I have just installed wamp.
I want to open the MySQLconsole but it asks for a password. How can I fix the password? I have just installed wamp.
Re: Passwords
Posted by:
SkareCrow
(---.dhcp.wnch.wa.charter.com)
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';
type: FLUSH PRIVILEGES;
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
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';
type: FLUSH PRIVILEGES;
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
Sorry, only registered users may post in this forum.
