Here I want to describe tutorial which works on my Mac. MySQL version: mysql Ver 14.14 Distrib 5.7.20, for macos10.12 (x86_64) using EditLine wrapper Mac OS version: Sierra 10.12.6 Please take care about root access in production environment. I’m feel free to connect to my MySQL db using root because it is Read more…
In previous post I’ve talked about installing MySQL in Mac OS X. Today I want to talk about PhpMyAdmin. Tool which help work with MySQL databases. Here steps how to install it and configure under Nginx webserver. 1. Create virtualhost for PhpMyAdmin. Create /usr/local/etc/nginx/sites-available/phpmyadmin file with next content server { listen Read more…
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 export Read more…
Here is instruction how to launch MySQL server after close unexpectedly. 1. Create /root/mysqlfix.sh file with next content: #!/bin/bash PATH=/usr/sbin:/usr/bin:/sbin:/bin if [[ ! “$(/usr/sbin/service mysql status)” =~ “active (running)” ]] then echo $(date -u) “MySQL service on the server has been stopped. It has now been restarted.” sudo service mysql Read more…