Upgrade MySQL 5.6 to 5.7 on Centos 7

Reference: http://linuxresolved.com/upgrade-mysql-5-6-mysql-5-7-centos/ 1. # service mysql stop 2. Important backup your databases before upgrade. Create a backup of the original MySQL data. $ cp /var/lib/mysql /var/lib/mysql.original 2. Download the MySQL 5.7 RPM $ wget http://repo.mysql.com/mysql57-community-release-el7.rpm -P /tmp/ 3. Remove the MySQL-Community RPM that contains MySQL 5.6 $ yum remove mysql-community-release 4. Install the MySQL 5.7 RPM … Continue reading Upgrade MySQL 5.6 to 5.7 on Centos 7

Advertisements

PostgreSQL notes

In Ubuntu, the server is run as a service called postgresql (configured in /etc/init.d/postgresql). The postgresql service is started automatically upon startup. Like all other services, you could: $ sudo service postgresql stop // Stop the service $ sudo service postgresql start // Start the service $ sudo service postgresql restart // Stop and restart the service $ sudo service postgresql reload … Continue reading PostgreSQL notes

Enable SSH login to Ubuntu by root user

In Ubuntu 16.04 by default root login by SSH is blocked for security reason. To enable root to login by SSH we have to update the ssh configuration. NOTE: This may make your server insecure for hackers so just enable root login temporarily if needed. /etc/ssh# ssh root Permission denied (publickey). Next edit the file:  /etc/ssh# vi sshd_config Change the following … Continue reading Enable SSH login to Ubuntu by root user

Ansible script examples

EXAMPLE: Restart NTP daemon in Linux First create the playbook pbntprestart.yml as below and run using this command. The cdhservers is where you define all your hostnames. $ ansible-playbook pbntprestart.yml -u root -k The content of pbntprestart.yml  is below: $ cat pbntprestart.yml --- - hosts: cdhservers tasks: - name: NTPRESTART shell: service ntpd restart register: out1 … Continue reading Ansible script examples

Let’s Encrypt free SSL certificate authority (CA)

Let’s Encrypt is a free, automated, and open certificate authority (CA), run for the public’s benefit. It is a service provided by the Internet Security Research Group (ISRG). The key principles behind Let’s Encrypt are: Free: Anyone who owns a domain name can use Let’s Encrypt to obtain a trusted certificate at zero cost. Automatic: Software running on … Continue reading Let’s Encrypt free SSL certificate authority (CA)

Enable Linux subsystem on Windows

We need to enable Windows Subsystem for Linux (Beta) which is basically Ubuntu linux on Windows. 1. Before installing the Linux Subsystem, you have to have: Windows 10 (Anniversary update or later version) 64-bit installation (can’t run on 32-bit systems) 2. Go to Windows Settings and click on pushbutton to Enable developer mode. It may … Continue reading Enable Linux subsystem on Windows

Install Ansible on Windows 10 WSL-Ubuntu

Steps to install Ansible on Windows 10. First we need to enable Windows Subsystem for Linux (Beta) which is an Ubuntu linux on Windows. Complete the steps in this blog: https://plenium.wordpress.com/2017/11/21/install-linux-on-windows/   <<<NEXT STEPS>>> Install Ansible Latest Releases Via Apt (Ubuntu) To configure the PPA on your machine and install ansible run these commands: $ sudo … Continue reading Install Ansible on Windows 10 WSL-Ubuntu