Skip to content

Instantly share code, notes, and snippets.

@braidn
Created May 16, 2012 15:15
Show Gist options
  • Save braidn/2711119 to your computer and use it in GitHub Desktop.
Save braidn/2711119 to your computer and use it in GitHub Desktop.
Fixing Brew Mysql
brew install mysql
mysql_install_db
sudo chown -R 'whoami' /usr/local"
CREATE USER 'root'@'localhost' IDENTIFIED BY 'YOUR_PASSWORD';
GRANT ALL PRIVILEGES ON TO 'root'@'localhost'
WITH GRANT OPTION;
CREATE USER 'root'@'%' IDENTIFIED BY 'YOUR_PASSWORD';
GRANT ALL PRIVILEGES ON TO 'root'@'%'
WITH GRANT OPTION;
CREATE USER 'admin'@'localhost';
GRANT RELOAD,PROCESS ON TO 'admin'@'localhost';
CREATE USER 'numbnuts'@'localhost';
mysqld_safe --skip-grant-tables
launchctl unload -w ~/Library/LaunchAgents/com.mysql.mysqld.plist
mysql.server start
mysql.server stop
mysql -u root
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment