MySql Configuration

MySQL CONNANDS :-

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

     //for getting permission for remote access

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

sudo ufw allow 3306/tcp

sudo service ufw restart 

sudo service mysql restart

sudo mysql

select user, authentication_string, plugin, host from mysql.user;

control+c for exit