mySQL 5.7版 解决密码登录失败mysql中Access denied for user 'root'@'localhost' (using password:YES)

登录mysql时报错！解决方案如下：

http://www.ithao123.cn/content-10849306.html

MySql5.7.17操作时报错：You must SET PASSWORD before executing this statement解决mysql>  SET PASSWORD = PASSWORD('123456');Query OK, 0 rows affected (0.03 sec)mysql> create database roger;Query OK, 1 row affected (0.00 sec)也就是用mysql>  SET PASSWORD = PASSWORD('123456');这句话重新设置一次密码！