Cheatography
https://cheatography.com
At times we need to get a database, saving steps here.
This is a draft cheat sheet. It is a work in progress and is not finished yet.
Installation
brew update |
brew install mysql |
Secure after install
mysql_secure_installation |
MySQL comes with a script that helps you secure your installation. Run the following command and follow the on-screen prompts |
| |
This script will prompt you to set a root password, remove anonymous users, disallow root login remotely, and remove the test database. |
|
|
Starting MySQL As A Service
Start MySQL Service |
brew services start mysql |
Stop MySQL Service |
brew services stop mysql |
Start MySQL only when you need it
mysqld start |
start the daemon that way the service is not always running. |
mysqld stop |
Troubleshooting
is MySQL running? |
ps aux | grep mysql |
|
|
|
