- start mysql
- type "use mysql"
- type "update user set password='' where user='root';"
- type "flush privileges"
Showing posts with label MYSQL. Show all posts
Showing posts with label MYSQL. Show all posts
Thursday, November 25, 2010
MySQL root password reset
The other day MySQL Workbench somehow set the password for the localhost root account from None to some other value while I tried to change the password of another user. Don't know exactly what happened, but to rest the password you should:
Subscribe to:
Posts (Atom)