mysql修改密码以及忘记密码

数据库授权
grant all privileges on . to root@’%’ identified by “password”;

flush privileges;

权限收回
revoke 权限（select insert…）on 数据库 . 表名 from “用户名” @‘host地址’

flush privileges;

修改密码
方法1： 用SET PASSWORD命令

格式: set password for 用户名@localhost = password(‘新密码’);

例子： set password for root@localhost = password(‘123’);

方法2：用mysqladmin

格式：mysqladmin -u用户名 -p旧密码 password 新密码

例子：mysqladmin -uroot -p123456 password 123

方法3：用UPDATE直接编辑user表

use mysql;

update user set password=password(‘123′) where user=’root’ and host=’localhost’;

flush privileges;

忘记密码
解决linux-mysql 登录时，报异常：Access denied for user ‘root’@’localhost’

第一步：停服务

/etc/init.d/mysql stop

或者

service mysqld stop

第二步：跳过密码验证
执行命令行：

/usr/bin/mysqld_safe –skip-grant-tables

报：
151104 09:07:56 mysqld_safe Logging to ‘/var/lib/mysql/iZ23dq2wm0jZ.err’.
151104 09:07:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
第三步：无密码登录
执行命令行：
mysql -u root
第四步：授权

grant all privileges on . to ‘root’@’localhost’ identified by ‘root’ with grant option;
关键词解释：
root’@’localhost:是用户
root：是密码
问题一：发现无密码条件下，没有授权的写权限

The MySQL server is running with the –skip-grant-tables option so it cannot execute this statement解决方法：mysql> set global read_only=0;//（关掉新主库的只读属性）mysql>flush privileges;
再次执行第四步授权语句：grant all privileges on . to ‘root’@’localhost’ identified by ‘root’ with grant option;

mysql>set global read_only=1;//(读写属性)mysql>flush privileges;
（注意刷新是必须项）第五步：重启数据库/etc/init.d/mysql restart
或者service mysql restart
再次执行第四步授权语句：grant all privileges on . to ‘root’@’localhost’ identified by ‘root’ with grant option;

mysql>set global read_only=1;//(读写属性)mysql>flush privileges;
（注意刷新是必须项）第五步：重启数据库/etc/init.d/mysql restart
或者service mysql restart
再次执行第四步授权语句：grant all privileges on . to ‘root’@’localhost’ identified by ‘root’ with grant option;

mysql>set global read_only=1;//(读写属性)mysql>flush privileges;
（注意刷新是必须项）第五步：重启数据库/etc/init.d/mysql restart
或者service mysql restart
再次执行第四步授权语句：grant all privileges on . to ‘root’@’localhost’ identified by ‘root’ with grant option;

mysql>set global read_only=1;//(读写属性)mysql>flush privileges;
（注意刷新是必须项）第五步：重启数据库/etc/init.d/mysql restart
或者service mysql restar