Skip to content

Instantly share code, notes, and snippets.

@tranc99

tranc99/homebrew_mysql_pass_reset.txt

Forked from fallwith/homebrew_mysql_pass_reset.txt
Last active August 29, 2015 14:27
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save tranc99/151acbb0dea89379b4ab to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save tranc99/151acbb0dea89379b4ab to your computer and use it in GitHub Desktop.
Download ZIP
Reset MySQL root password (Homebrew)
Raw
homebrew_mysql_pass_reset.txt
$> launchctl unload -w ~/Library/LaunchAgents/com.mysql.mysqld.plist
$> /usr/local/Cellar/mysql/5.5.9/bin/mysqld --basedir=/usr/local/Cellar/mysql/5.5.9 --datadir=/usr/local/Cellar/mysql/5.5.9/data --plugin-dir=/usr/local/Cellar/mysql/5.5.9/lib/plugin --log-error=/usr/local/Cellar/mysql/5.5.9/data/errors.err --pid-file=/usr/local/Cellar/mysql/5.5.9/data/pidfile.pid --skip-grant-tables
$> mysql
mysql> UPDATE mysql.user SET Password=PASSWORD('root_password') WHERE User='root';
mysql> FLUSH PRIVILEGES;
$> kill `cat /usr/local/Cellar/mysql/5.5.9/data/pidfile.pid`
$> ps auwx | grep mysql
$> launchctl load -w ~/Library/LaunchAgents/com.mysql.mysqld.plist
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment