Search This Blog

Friday, June 5, 2020

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



No comments:

Hit Counter


View My Stats