Solve Mysql secure error

From rbachwiki
Revision as of 21:13, 19 May 2022 by Bacchas (talk | contribs) (Created page with "==How To Solve Failed! Error: SET PASSWORD has no significance for user ‘root’@’localhost’ as the authentication method used doesn’t store authentication data in the MySQL server Error?== mysql ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by 'mynewpassword';")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

How To Solve Failed! Error: SET PASSWORD has no significance for user ‘root’@’localhost’ as the authentication method used doesn’t store authentication data in the MySQL server Error?

mysql
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by 'mynewpassword';