Nginx + MySQL configurations
Here is instructions how to install MySQL and PhpMyAdmin on Mac OS X
1. Download and install DMG file.
Link for downloading : https://dev.mysql.com/downloads/mysql/
2. Installer will generate temporary root password. Save it in text file for next steps.
3. Add /usr/local/mysql/bin to PATH
If you use ZSH open ~/.zshrc file and add
at the end of file. Save this file and restart all Terminal windows.
4. Change MySQL root password
mysqladmin -u root -p password root
5. start MySQL service
Open SystemPreferences and click on MySQL preferences.
Click on “Start MySQL Server” and put tick on “Automatically Start MySQL Server on Startup”
6. Check mysql from Terminal
Open Terminal and run. Enter password which you have setup in step number 4.
mysql -uroot -p
You should see output like this:
➜ ~ mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 123 Server version: 5.7.20 MySQL Community Server (GPL) Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>
To exit from MySQL console type exit and hit ENTER
You have installed MySQL.
To make work with MySQL more comfortable I suggest to install PhpMyAdmin.
Next post will be about it : https://www.hrupin.com/2017/11/how-to-install-phpmyadmin-nginx-in-mac-os-x