CODE EXAMPLE FOR SHELL

ubuntu default phpmyadmin password

sudo mysql --user=root mysql
//Once logged in, you will see the mysql> prompt.

UPDATE mysql.user SET authentication_string=null WHERE User='root';

flush privileges;

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

flush privileges;


exit