Answered by : said-hr

{"tags":[{"tag":"textarea","content":"ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'NEWPASSWORD';","code_language":"whatever"}]}

Source : https://askubuntu.com/questions/766334/cant-login-as-mysql-user-root-from-normal-user-account-in-ubuntu-16-04 | Last Update : Fri, 28 Apr 23