How to Install Latest MySQL on Lubuntu 16.04

Installing

2. 2. Downloading MySQL Server

   Download Latest MySQL Server for Lubuntu

   Latest MySQL .deb

   MySQL Deb

3. 3. Installing MySQL Server

   Then to Install MySQL Server
   First, access the Download location by default with:

   cd ~/Downloads

   To Check it’s there List the contents with:

   ls . | grep mysql

   The grep Command refine the output List showing only the Entries matching the Keyword.
   But if you are in Trouble to Find the Location on Terminal then See: How to Access Downloads Folder from Browser.

   sudo apt install ./mysql*debian*.deb

   Post-Installation Configuration.

   groupadd mysql

   useradd -r -g mysql mysql

   chown -R mysql:mysql /opt/mysql

   /opt/mysql/server*/scripts/mysql_install_db --user=mysql

   chown -R root /opt/mysql

   chown -R mysql /opt/mysql/server*/data

4. 4. Setting Up PATH

   So then again to Set the User PATH
   Run in succession the following Commands:

   su `whoami`

   cd  

   nano .bashrc

   Append:

   export PATH=$PATH:/opt/mysql/server-[Version]/bin

   Ctrl+x to Save & Exit from nano :)

   Load the New PATH with:

   bash

5. 5. Launching MySQL Server

   In case to Start the MySQL Server
   Run:

   sudo su -c "mysqld_safe --user=mysql &"

6. 6. MySQL Server Secure SetUp

   Strongly Recommended MySQL Server Secure SetUp

   MySQL Secure Server SetUp

   MySQL Secure Install