解决方法1:
SET PASSWORD = '123456'
解决方法2:
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
命令行展现:
报错:
解决:
特别感谢:https://blog.csdn.net/qq939782569/article/details/87344602
首页 > 技术文章 > 修改mysql密码出现报错:ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corres
hfclszs 2020-10-01 19:55 原文
SET PASSWORD = '123456'
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
报错:
解决:
特别感谢:https://blog.csdn.net/qq939782569/article/details/87344602