Mysql5.6忘记root密码修改root密码的方法_Mysql_脚本之

mysql5.6忘记数据库的root密码:

[root@oraserver139 ~]# mysql -uroot -pEnter password: ERROR 1045 : Access denied for user 'root'@'localhost'

查看当前安装的mysql版本:

root@oraserver139 ~]# rpm -qa | grep MySQLMySQL-server-5.6.15-1.el6.x86_64MySQL-client-5.6.15-1.el6.x86_64MySQL-shared-compat-5.6.15-1.el6.x86_64MySQL-devel-5.6.15-1.el6.x86_64perl-DBD-MySQL-4.022-1.el6.rfx.x86_64

停止mysql服务:

[root@oraserver139 ~]# service mysql stopShutting down MySQL.. SUCCESS!

进入到skip-grant-tables模式:

[root@oraserver139 ~]# mysqld_safe --skip-grant-tables140211 15:37:49 mysqld_safe Logging to '/var/lib/mysql/oraserver139.err'.140211 15:37:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

现在就不需要密码就可以进入mysql了:

[root@oraserver139 ~]# mysqlWelcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 1Server version: 5.6.15 MySQL Community Server

Copyright 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

进入mysql系统数据库:

mysql> use mysqlReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changed

修改root账户密码:

mysql> update user set password=password where user="root";Query OK, 4 rows affected Rows matched: 4 Changed: 4 Warnings: 0

刷新权限:

mysql> flush privileges;Query OK, 0 rows affected mysql> exitBye

停止mysql进程:

[1] Stopped mysqld_safe --skip-grant-tables

启动mysql:

[root@oraserver139 ~]# service mysql startStarting MySQL SUCCESS!

使用刚才修改的密码进入mysql:

[root@oraserver139 ~]# mysql -uroot -p12345Warning: Using a password on the command line interface can be insecure.Welcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 3Server version: 5.6.15

Copyright 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

mysql> show databases;ERROR 1820 : You must SET PASSWORD before executing this statement

mysql> SET PASSWORD = PASSWORD;Query OK, 0 rows affected

mysql> show databases; -------------------- | Database | -------------------- | information_schema || mysql || performance_schema || test | -------------------- 4 rows in set

以上所述是小编给大家介绍的Mysql5.6忘记root密码修改root密码的方法,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对脚本之家网站的支持!

本文由澳门新萄京官方网站发布于信息数据库,转载请注明出处:Mysql5.6忘记root密码修改root密码的方法_Mysql_脚本之

TAG标签:
Ctrl+D 将本页面保存为书签,全面了解最新资讯,方便快捷。