关于修改mysql root 用户密码问题

1、查看文件

sudo gedit /etc/mysql/debian.cnf

里面有user和password了；

2、暂时登陆mysql;

mysql -u debian-sys-maint -p

密码就是文件里的那个

然后执行

3、连接数据库

use mysql;

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

4、查看表单并修改

select user,authentication_string from user;

update user set authentication_string=password('new password') where user='root';

 退出重新登陆试一试！！！！！