Pulling the bullet out of your feet with a bad mysql install
Submitted by bingomanatee on 22 June, 2010 - 16:16
How to back out of a crappy install where you enter a wrong password in mysql and can't figure it out.
- read /etc/mysql/debian.cnf. It will have the username and password of a valid mysql user.
- Log into mysql with that user/pw.
- http://www.cyberciti.biz/faq/mysql-change-root-password/ trick:
-
use mysql; update user set password=PASSWORD("NEWPASSWORD") where User='root'; flush privileges; quit; -
Test your new password to regain confidence in your own brain.
Post new comment