Article 5STQ7 upgrade mysql-server (mariadb) can't log into root stuck in secure-auth

upgrade mysql-server (mariadb) can't log into root stuck in secure-auth

by
Mental-Octopus
from LinuxQuestions.org on (#5STQ7)
It kept saying Server is running in --secure-auth mode, but 'root'@'localhost' has a password in the old format; please change the password to the new format on debian

I tried adding skip-grant-tables and secure-auth=off to mysqld in my.cnf
but then it says
error: 'Access denied for user 'root'@'localhost' mysql debian

I'm using debian

please someone helplatest?d=yIl2AUoC8zA latest?i=d1iWF2GOtXU:B1ddrqWUu08:F7zBnMy latest?i=d1iWF2GOtXU:B1ddrqWUu08:V_sGLiP latest?d=qj6IDK7rITs latest?i=d1iWF2GOtXU:B1ddrqWUu08:gIN9vFw
External Content
Source RSS or Atom Feed
Feed Location https://feeds.feedburner.com/linuxquestions/latest
Feed Title LinuxQuestions.org
Feed Link https://www.linuxquestions.org/questions/
Reply 0 comments