Installing MySQL and MySQL Workbench on Linux

#mysql

Simple Guideline on installing MySQL and Workbench on Ubuntu , Pop_OS or any Debian Linux.

Install MySQL

Update apt to ensure you get the latest packages and install mysql-server

$ sudo apt-get update
$ sudo apt-get install mysql-server

Next to setup and Configure MySQL

$ sudo mysql_secure_installation

Selecting Y ('yes') for all the setting is reasonabe.

To access MySQL

$ sudo mysql -u root -p

Install MySQL Workbench

Download the installer which is compatable for your system and Linux version .

click here to download

Just click on the deb file and install or use dpkg command to install

$ sudo dpkg -i path_to_deb_file

To Uninstall MySQL and MySQL Workbench

If u want to remove both this softwares completely from your system use the following commands

To remove MySQL

$ sudo apt-get remove --purge mysql-server mysql-client mysql-common -y
$ sudo apt-get autoremove -y
$ sudo apt-get autoclean

To remove MySQL Workbench

$ sudo apt-get remove mysql-workbench-community
or
$ sudo dpkg -r mysql-workbench-community
$ sudo dpkg --purge mysql-workbench-community

To Start, Stop, Restart or check Status of MySQL Service

$ sudo service mysql start 
$ sudo service mysql stop
$ sudo service mysql restart
$ sudo service mysql status

To Access MySQL without SUDO

When we try to access MySQL without sudo ERROR 1045 (28000): Access denied for user 'username'@'localhost' (using password: NO)

this error pops up

Follow this steps to overcome this error

$ sudo mysql  -u root -p
Enter password:
mysql> show databases;
mysql> use mysql
mysql> select user, host, plugin from mysql.user;
mysql> update user set plugin="mysql_native_password" where User="root";
mysql> flush privileges;
mysql> exit;
$ mysql -u root
mysql> SET GLOBAL validate_password.policy=LOW;
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Enter_password';
mysql> exit
$ sudo service mysql restart

now we can access MySQL by using