sudo apt update
sudo apt install mysql-server
sudo service mysql start
sudo mysql_secure_installation
sudo mysql -u root
In mysql console:
DROP USER 'root'@'localhost';
CREATE USER 'root'@'%' IDENTIFIED BY 'YOURPASSWORD';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

sudo apt update
sudo apt install mysql-server
sudo mysql_secure_installation

sudo apt install mysql-server
sudo mysql_secure_installation utility

# Installing MySQL
sudo apt update
sudo apt install mysql-server
# — Configuring MySQL
sudo mysql_secure_installation
|-----> # Creating a Dedicated MySQL User and Granting Privileges
|	sudo mysql, mysql -u root -p,sudo mysql --defaults-file=/etc/mysql/debian.cnf
|	CREATE USER 'user'@'localhost' IDENTIFIED BY 'user1122';
|	# Change User Password
|	ALTER USER 'user_name'@'localhost' IDENTIFIED BY 'newPassword';
|	FLUSH PRIVILEGES;
|	# IF ERROR 1819 (HY000): Your password does not satisfy
|	# The current policy requirements (Source: ostechnix.com)
|	SET GLOBAL validate_password.policy = 0;
|	SET GLOBAL validate_password.length = 6; # If Required.
|	SET GLOBAL validate_password.number_count = 0; # If Required.
|	SHOW VARIABLES LIKE 'validate_password%'; # Show password level.
|
|	# Granting privileges
|	GRANT ALL PRIVILEGES ON * . * TO 'user'@'localhost';
|	SHOW GRANTS FOR 'user'@'localhost';
|	FLUSH PRIVILEGES;
|
|	# Delete User
|	DROP USER 'user'@'localhost';
|	# Show All Users
|	SELECT User, Host FROM mysql.user;
|
|-----> # Creating database
|	create database db_name;
|	# Show DataBase
|	SHOW DATABASES;
|	# Delete Database
|	DROP DATABASE db_name;
|-----> # Creating table
|	USE db_name;
|	CREATE TABLE t_name (id int, name varchar(100));
|	# Insert Data
|	INSERT INTO t_name VALUES (1, 'AliRaza');
|	# Delete Table
|	DROP TABLE t_name;
|	# Show All tabales in DB
|	USE db_name;
|	SHOW TABLES;
|
|-----> # Import Sql File
|	mysql -u username -p db_name < file.sql
|
|-----> # Export Sql Database
|	mysqldump -u username -p db_name > file.sql

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

GRANT CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, REFERENCES, RELOAD ON *.* TO 'mysqluser'@'localhost' WITH GRANT OPTION;