How to Install MySQL 8.0 in Ubuntu 18.04

 #### How to Install MySQL 8.0 in Ubuntu 18.04 ####

## Step 1: Add MySQL Apt Repository

$ wget -c https://repo.mysql.com//mysql-apt-config_0.8.13-1_all.deb 

# Then install the MySQL repository package using the following dpkg command.

$ sudo dpkg -i mysql-apt-config_0.8.13-1_all.deb 

# Step 2: Install MySQL Server in Ubuntu 18.04

       Next, download the latest package information from all configured repositories, including the recently added MySQL repository.

$ sudo apt update

# Then run the following command to install packages for the MySQL community server, client and the database common files.

$ sudo apt-get install mysql-server

# Step 3: Secure MySQL Server Installation

$ sudo mysql_secure_installation

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

##################### CREATE Database User and ALTER Password #############################

#SET GLOBAL validate_password.policy=LOW;

#CREATE USER 'india'@'%' IDENTIFIED WITH mysql_native_password BY 'SF9kh77hjjg8g';(8 ok)

mysql> ALTER USER 'india'@'localhost' IDENTIFIED BY 'SF9kh77hjjg8g';

mysql> flush privileges;

#ALTER USER 'india'@'%' IDENTIFIED WITH mysql_native_password BY 'SF9kh77hjjg8g';(8 ok)

#GRANT ALL PRIVILEGES ON * .* TO 'india'@'%';