I've been try to install mysql on my Ubuntu 22, considering that i follow some code from my instructor like this o

sudo mysql
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
FLUSH PRIVILEGES;
quit

After that i try to re open mysql and showing error like this

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

what should i do?

CodePudding user response：

Mysql -u - p After that you please input your password