Socials
  • Facebook
  • Instagram
  • Linkedin
  • Youtube
  • Stackoverflow
  • Github
  • AngelList

Igor Khrupin

  • Technical Blog
  • Archives

MySQL

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, 4 years8 January, 2018 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 Read more…

By Igor Khrupin, 4 years27 November, 2017 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 Read more…

By Igor Khrupin, 4 years27 November, 2017 ago
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 Read more…

By Igor Khrupin, 5 years7 July, 2017 ago
profile for ihrupin at Stack Overflow, Q&A for professional and enthusiast programmers
Categories
  • Algorithms (7)
    • Graph (1)
    • Linked List (2)
    • Searching (1)
    • Sorting (3)
  • Frameworks (4)
    • Flash (4)
  • Gradle (1)
  • Integrated development environment (IDE) (8)
    • Android Studio (8)
  • Mobile Software Development (75)
    • Android Development (74)
      • Android Accessibility (1)
      • Android NDK (3)
      • Android Performance (1)
    • iOS Development (2)
  • Operation Systems (28)
    • Linux (16)
      • Ubuntu (6)
    • Mac OS X (13)
      • Mountain Lion (2)
  • Programming Languages (10)
    • ActionScript (3)
    • Java (7)
  • Tech (112)
  • Tools (1)
  • Uncategorized (1)
  • Web Development (16)
    • Bots (1)
Tags
ActionScipt 3 Activity adb server Algorithm Android Android Keyboard Android Manifest Android SDK Android Studio Apache AsyncTask Balloon cron crontab Decomposition Eclipse embed Font Flash UI Google maps GPS HTML LatinIME Layout letsencrypt Linked List Linux Ubuntu ListView Lucid Lynx Mac OS X Map Overlays Maven media player mp3 MySQL NDK nginx Recursion Sorting ssl streaming media Style TextField Ubuntu UI VirtualHost
Categories

Hestia | Developed by ThemeIsle