MySQL: Necessary Command

sudo service mysql status

sudo service mysql restart

sudo mysql_secure_installation

—-- Disable root password

Sudo /etc/mysql/mysql.conf.d/mysqld.cnf

[mysqld]

skip-grant-tables

———— Setup Mysql 

sudo apt update

sudo apt install mysql-server

sudo mysql_secure_installation

--- Remove MySQL 

sudo apt purge mysql-server mysql-common

sudo apt autoremove mysql-server mysql-common

— Grant remote permission to user

GRANT ALL PRIVILEGES on *.* to root@'%' identified by ‘password’;

FLUSH PRIVILEGES;