Setting up and using mysql in rails app
brew install mysql
We've installed your MySQL database without a root password. To secure it run:
mysql_secure_installation
MySQL is configured to only allow connections from localhost by default
To connect run:
mysql -uroot
To have launchd start mysql now and restart at login:
brew services start mysql
Or, if you don't want/need a background service you can just run:
mysql.server start (stop, restart, status)
mysql -u root
-u
says login as user root
exit
msqladmin -u root password
mysql -u root -p
to logingem install mysql2
, not mysql