How to Install Latest MySQL on Lubuntu 14.04

Installing

2. 2. Downloading MySQL Server

   Download Latest MySQL Server for Ubuntu

   Latest MySQL .deb 32/64-bit

   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