203

HTTP code 203: Non-Authoritative Information

HowTo: Reset Your MySQL Root Password

In case you forgot your root password for MySQL installed with Homebrew on OS X Mountain Lion.

(reroot.sh) download
1
2
3
4
5

launchctl unload ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
/usr/local/opt/mysql/bin/mysqld_safe --skip-grant-tables --skip-networking &
mysql -e "UPDATE mysql.user SET Password=PASSWORD('new password') WHERE User='root'; FLUSH PRIVILEGES;"
/usr/local/bin/mysql.server stop
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

Different versions may have different paths to be used with launchctl load/unload

Comments