MySQL – Igor Khrupin

Mac OS X

How to change/reset root MySQL password on Mac

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…

By Igor Khrupin, 2 years2 years ago

Mac OS X

How to install PhpMyAdmin + Nginx in Mac OS X

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   80; 

    server_name  phpmyadmin;
    
    root       /var/www/phpmyadmin/;

    index index.php index.html index.htm;
 
    access_log  /usr/local/etc/nginx/logs/phpmyadmin.access.log;
    error_log  /usr/local/etc/nginx/logs/phpmyadmin.error.log;
 
    location ~ \.php$ {
        try_files      $uri = 404;
        fastcgi_pass   127.0.0.1:9000;
        fastcgi_index  index.php;
        fastcgi_param  SCRIPT_FILENAME $document_root$fastcgi_script_name;
        include        fastcgi_params;
    }

    error_page  404     /404.html;
    error_page  403     /403.html;
}

server {

listen 80;

server_name phpmyadmin;

root /var/www/phpmyadmin/;

index index.php index.html index.htm;

access_log /usr/local/etc/nginx/logs/phpmyadmin.access.log;

error_log /usr/local/etc/nginx/logs/phpmyadmin.error.log;

location ~ \.php$ {

try_files $uri = 404;

fastcgi_pass 127.0.0.1:9000;

fastcgi_index index.php;

fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;

include fastcgi_params;

}

error_page 404 /404.html;

error_page 403 /403.html;

}

Edit hosts Read more…

By Igor Khrupin, 2 years2 years ago

Mac OS X

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

export PATH=/usr/local/mysql/bin:$PATH

1	export PATH=/usr/local/mysql/bin:$PATH

Linux

How to automatically restart MySQL service

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 start
fi

#!/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 start

2. Make it executable chmod +x /root/mysqlfix.sh 3. sudo crontab -e 4. Add crontab job. For 3 min period job will be next:

*/3 * * * * /root/mysqlfix.sh >> /var/log/mysqlfix.log 2>&1

1	/3 * * * /root/mysqlfix.sh >> /var/log/mysqlfix.log 2>&1

/var/log/mysqlfix.log – log file Let me know Read more…

By Igor Khrupin, 2 years2 years ago