mysql报ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password)错误或者远程用户不能登录

1、停止mysql服务：mysqld stop

2、使用跳过受权表访问mysql：mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

3、登录mysql：mysql -u root mysql

4、查询用户信息表：select * from user

5、添加用户认证：INSERT INTO user(host, user, password, select_priv, insert_priv, update_priv) VALUES ('localhost', 'username', PASSWORD(‘password'), 'Y', 'Y','Y');
//localhost 需要登录的地址
//username 需要登录的用户
//password 登录用户密码
6、启动mysql服务：mysqld start