Mysql Install - Root User Password set, MySQL GUI

install

sudo apt-get install mysql-server

sudo apt-get install libmysqlclient-dev

sudo apt-get install libmariadbclient-dev  

login
mysql -u root

Set password for Root
SELECT user,authentication_string,plugin,host FROM mysql.user;

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

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

exit;


GUI
mysql workbench GUI = LINUX, WINDOWS

sqlyog = windows