How to install MYSQL server on Centos 7

MySQL is an open-source database management program, usually installed as part of the popular LAMP (Linux, Apache, MySQL/MariaDB, PHP). It uses a relational database and Structured Query Language to manage it's data.

Installing MYSQL Server

 

Step1.

  In order to install MYSQL Server on CentOS 7 first you have to download and add MYSQL repository to local machine, and than update with the help of following commands one by one. Results will be as shown in images.

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum update

 

 

Step2.

Now install MYSQL as usual software by yum install command, It will ask you for confirmation. Type "y" to continue installation and then start mysqld service to start the server

sudo yum install mysql-server
sudo systemctl start mysqld

Step3.

Now run mysql_secure_installation command to secure your newly installed server.

Here it will ask you to change MYSQL root password, remove ad-on user accounts, database login permissions from local and network computers and to remove additional databases.

  

 

Installing L2TP IPSec Client on Ubuntu 16.04

As ppa warner repository does not support on Ubuntu 16.04, so we need to install it manualy.

I have did a lot work make configure and finally did it with the help of following steps.

First of all you must install the prerequisites with the help of following command, Just copy and paste as shown in image:

sudo apt-get install intltool libtool network-manager-dev libnm-util-dev libnm-glib-dev libnm-glib-vpn-dev libnm-gtk-dev libnm-dev libnma-dev ppp-dev libdbus-glib-1-dev libsecret-1-dev libgtk-3-dev libglib2.0-dev xl2tpd strongswan

Now you will need to install git, because we will need to clone and build network manager. So give following set of commands one by one:

sudo apt-get install git git clone https://github.com/nm-l2tp/network-manager-l2tp.git cd network-manager-l2tp autoreconf -fi intltoolize

 Cross check if there is any error build, and now configure build with the help of following command just copy paste and enter as it is:

./configure \ --disable-static --prefix=/usr \ --sysconfdir=/etc --libdir=/usr/lib/x86_64-linux-gnu \ --libexecdir=/usr/lib/NetworkManager \ --localstatedir=/var \ --with-pppd-plugin-dir=/usr/lib/pppd/2.4.7

Now run make command with the help of following commands.

make sudo make install

Now remove AppArmor settings for IPSec with following commands.

sudo apparmor_parser -R /etc/apparmor.d/usr.lib.ipsec.charon sudo apparmor_parser -R /etc/apparmor.d/usr.lib.ipsec.stroke

Now remove x2ltpd and install libpcap with the help of following commands:

sudo apt remove xl2tpd sudo apt install libpcap0.8-dev

Now download and install xl2tpd-1.3.6 with the help of following commands one by one:

wget https://github.com/xelerance/xl2tpd/archive/v1.3.6/xl2tpd-1.3.6.tar.gz sudo chmod 755 xl2tpd-1.3.6.tar.gz tar xvzf xl2tpd-1.3.6.tar.gz cd xl2tpd-1.3.6 make sudo make install

Now restart your computer and look at your network configuration wizard, here it will show you  L2TP VPN option. Configure it according to your server settings.