--依次执行以下三条SQL
ALTER USER ‘dykj‘@‘%‘ IDENTIFIED BY ‘password‘ PASSWORD EXPIRE NEVER; --‘dykj‘@‘%‘ 为登陆不上的用户
ALTER USER ‘dykj‘@‘%‘ IDENTIFIED WITH mysql_native_password BY ‘123456‘; FLUSH PRIVILEGES; --123456 为新密码
原文：https://www.cnblogs.com/-hao/p/13190049.html