mysql -u root
update mysql.userset authentication_string=PASSWORD('root') whereUser='root';
flush privileges;
然后改回my.cnf重启mysql。
方法2:
先暂停mysq l以不检查权限的方式启动
bin/mysqld_safe --skip-grant-tables&
登陆mysql后就可以修改密码了
mysql -u root
update mysql.userset authentication_string=PASSWORD('root') whereUser='root';
flush privileges;
然后重启mysql就ok了
service mysqld restart
登录后任何操作都会有这个提示:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server versionfortheright syntax to use near ''atline1