MySQL

Installing MySQL

• Option 1: From the MySQL website.
• Option 2: From Homebrew.

brew install mysql

Post Install

• To launch at login: ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchAgents
• To load now, without restart: launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

Control MySQL

• To start, stop, restart and see status:

mysql.server start
mysql.server stop
mysql.server restart
mysql.server stop

Connect to MySQL

• To connect to the database from the command line.
• To exit from MySQL run: exit.

mysql -u root
mysql -u -p root

Setting the Password

• Setting the password for the root user.

mysqladmin -u root password
mysqladmin -u -p root password