Join our mailing list Subscribe Us

mysql 8.0: set Root password ubuntu

1. install mysql using cmd  sudo apt install mysql-server

2. after  install connect to mysql cmd: sudo mysql -u root

3. reset password using below cmds:

SELECT User,Host FROM mysql.user;

DROP USER 'root'@'localhost';

CREATE USER 'root'@'localhost' IDENTIFIED BY 'Welcome#1';

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;

FLUSH PRIVILEGES;

4. connect to mysql using new password cmd: sudo mysql -u root -p'Welcome#1'