I am am trying to learn mysql 101. Doing so, I broke my ability to login as root.
At first I could simply connect to mysql by running
In an attempt to alleviate a problem, I thoughtlessly copy and pasted some sql into the mysql prompt.
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
Now when I try to log in using sudo mysql, I get the error...
Access denied for user 'me'@'localhost' (using password: NO)
What exactly did I do, and how can I rectify it?