mysql 报这样错：（Access denied for user 'root'@'localhost' (using password: YES /NO”）的处方

 /etc/init.d/mysqld stop 

 mysqld_safe --user=mysql --skip-grant-tables --skip-networking & 

 mysql -u root mysql 

mysql> UPDATE user SET Password=PASSWORD(’newpassword’) where USER=’root’; 

mysql> FLUSH PRIVILEGES;

 

mysql> exit;

​
sudo mysql service restart;

​

重新登陆进去mysql :

 mysql -uroot -p 

Enter password: <输入新设的密码 > 

mthod 2 : 

mysql -udebian-sys-maint -p 

用户名和密码在这个文件里面　：

sudo  anno  /etc/mysql/debian.cnf的suer和passowrd : 

设置连接mysql不使用sudo

首先，登录
sudo mysql -uroot

接下来的都是在mysql里敲得
查看当前用户
select user,host from mysql.user;

 

删除root账号
drop user root@localhost;

重新创建root
create user root@localhost identified by 'mysql';//mysql is password

授权：
grant all privileges on *.* to root@localhost with grant option;

刷新权限：
flush privileges;

退出mysql，重新连接：
mysql -uroot -pmysql

不用加sudo了，搞定

重置密码
host为%时允许远程登录

重置密码：

#1:
SET PASSWORD FOR root@'localhost' = PASSWORD('password');

#2:
UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';

#3:
USE mysql;
UPDATE user SET Password = PASSWORD('newpwd') WHERE Host = 'localhost' AND User = 'root';