How to Setup MySQL on Ubuntu Server

sudo apt update 
sudo apt upgrade

sudo apt install mysql-server

mysql –version 
sudo mysql_secure_installation

• To remove anonymous users, enter Y and press enter.
• To prevent remote root login, enter Y and press enter.
• To remove the test database, enter Y and press enter.
• To reload the privilege tables, enter Y and press enter.

sudo mysql
mysql> CREATE USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost';
mysql> FLUSH PRIVILEGES;
mysql> ALTER USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
systemctl status mysql.service
sudo service mysql restart
sudo mysql --user=root -p[ROOT_PASSWORD] -e "show databases"

sudo mysql -u root -p

sudo lsof -i -P -n | grep LISTEN

SELECT user,authentication_string,plugin,host FROM mysql.user;

sudo cat /etc/mysql/mysql.conf.d/mysqld.cnf 
sudo service mysql restart