Install MySQL

sudo apt install mysql-server

Check installation status & run MySQL

sudo mysql

Add SQL auth access for root: Replace YourRootPassword with a new password

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourRootPassword';

once done, type exit to leave

Set to secure mode for sql settings/overwrite default settings

sudo mysql_secure_installation

When this script runs, you will be prompted to answer yes (y) or no (n) to several questions.

Following are the prompts with suggested responses:

• Enter password for user root: (enter the password you set in 6.3 above)
• Would you like to setup VALIDATE PASSWORD component? n
• Change the password for root? n