mysql密码重置

213123

Mysql密码重置
■5.1修改配置文件为免授权
___________________________________________________________

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

[iyunv@lab-1-C6 ~]# mysqladmin -uroot password '111qqq...' [iyunv@lab-1-C6 ~]# mysql -uroot -p111qqq... [iyunv@lab-1-C6 ~]# vim /etc/my.cnf [iyunv@lab-1-C6 ~]# /etc/init.d/mysqld restart Shutting down MySQL. SUCCESS! Starting MySQL. SUCCESS! [iyunv@lab-1-C6 ~]# mysql mysql> update user set password=password('111qqq...') where user='root'; mysql> select * from user where user='root'\G; [iyunv@lab-1-C6 ~]#vim /etc/my.cnf   #删除以下内容 skip-grant   [iyunv@lab-1-C6 ~]#/etc/init.d/mysqld restart [iyunv@lab-1-C6 ~]# mysql      #无法登录 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) [iyunv@lab-1-C6 ~]# mysql -uroot -p111qqq...