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…
For better security we should use public key authentication on the server. Here is steps how to do it. 1. Generate SSH key pair on your local computer. Skip if you already have ssh key pair in your local computer ssh-keygen Output: Generating public/private rsa key pair. Enter file in Read more…
Before starting installation PHP-FPM and configurations you should have Nginx installed and configured. If you don’t have it ready please follow my previous post about installing and configuring Nginx on Mac OS X. Here is the link https://www.hrupin.com/2017/11/how-to-install-nginx-webserver-on-mac-os-x So, here we have installed and configured NGinx. Let’s install and configure PHP-FPM. Read more…
Before start you should ensure that you have Command Line Tools installed in your mac. It is part of XCode. You should have it installed and updated. Install Command Line Tools if not exist xcode-select –install Install Nginx using Homebrew brew tap homebrew nginx brew install nginx Test Installation ## Start Read more…
Operations which will be described can be done normally using mouse or trackpad. But if you want to make your working process really fast and productive then you in the right place. I’ll tell you about the most common shortcuts which you probably already know. Hope this page will help Read more…
To make automatic renew you Letsencrypt certificates you need create crontab job. Here is simple instructions 1. Create /root/certrenew.sh file with content: #!/bin/bash PATH=/usr/sbin:/usr/bin:/sbin:/bin sudo service nginx stop /home/igor/letsencrypt/letsencrypt-auto renew service nginx start exit 0 2. Make it executable `chmod +x /root/certrenew.sh` 3. `sudo crontab -e` 4. Add crontab job. 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…
Here is instruction how to launch Nginx server after close unexpectedly. 1. Create /root/nginxfix.sh file with next content: #!/bin/bash PATH=/usr/sbin:/usr/bin:/sbin:/bin if [[ ! “$(/etc/init.d/nginx status)” =~ “active (running)” ]] then echo $(date -u) “NGINX server has been stopped. It has now been restarted.” service nginx start fi 2. Make it Read more…