Ubuntu 22.04 mysql password

 

$ mysql -u root -p

mysql > SELECT user,plugin,host FROM mysql.user WHERE user = 'root';

mysql > ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'MrsLKYsuck5';

mysql > FLUSH PRIVILEGES;