Setting up MySql with MacOs
Step1: Installation from brew.
brew install mysql
Step2: Run this command if we don’t want to run MySql in background.
/opt/homebrew/opt/mysql/bin/mysqld_safe –datadir=/opt/homebrew/var/mysql
or for running it in background or at login run this command.
brew services start mysql
I prefer not to run it in background or when i login into my mac.
Step3: Let’s check it is working correctly.
Connect to MySQL.
mysql -u root -p
Run the Query.
SHOW DATABASES;
Step4: For turning it off we can use this command (Only if you not running it in background).
/opt/homebrew/opt/mysql/bin/mysqladmin -u root -p shutdown
Step5:(Optional): We can add alias for it for starting it and stopping it.
add alias in ~/.zshrc file or if you bash add it in ~/.bashrc file.
sql-start
alias sql-start=‘/opt/homebrew/opt/mysql/bin/mysqld_safe –datadir=/opt/homebrew/var/mysql’
sql-stop
alias sql-stop=“/opt/homebrew/opt/mysql/bin/mysqladmin -u root -p shutdown”
By doing this you can start and stop it when need.
Please follow and like us:
