mysql5.7 修改root密码登录

su mysql

mysqld --skip-grant-tables

update mysql.user set authentication_string=password('123qwe') where user='root' and Host = 'localhost';

alter user user() identifity by '123qwe';

GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY '123qwe' WITH GRANT OPTION;

flush privileges;

quit;