1 在一个窗口输入如下命令https://www.cndba.cn/zhasir/article/3468https://www.cndba.cn/zhasir/article/3468https://www.cndba.cn/zhasir/article/3468https://www.cndba.cn/zhasir/article/3468
[root@zhasir ~]# mysqld --skip-grant-tables
2016-06-08 20:37:52 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-06-08 20:37:52 0 [Note] mysqld (mysqld 5.6.38-83.0-log) starting as process 3797 ...
2 打开一个新的窗口
[root@zhasir ~]# mysql
Welcome to the MySQL monitor. Commands end with ; or /g.
Your MySQL connection id is 1
Server version: 5.6.38-83.0-log Percona Server (GPL), Release 83.0, Revision dc97471bd40
Copyright (c) 2009-2017 Percona LLC and/or its affiliates
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.
mysql> 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
mysql> update user set password=password("mysql") where user="root";
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
[root@zhasir ~]# service mysql stop
Shutting down MySQL (Percona Server).. SUCCESS!
[root@zhasir ~]# service mysql start
Starting MySQL (Percona Server) SUCCESS!
[root@zhasir ~]# service mysql status
SUCCESS! MySQL (Percona Server) running (4640)
4 使用新密码登陆https://www.cndba.cn/zhasir/article/3468
[root@zhasir ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or /g.
Your MySQL connection id is 1
Server version: 5.6.38-83.0-log Percona Server (GPL), Release 83.0, Revision dc97471bd40
Copyright (c) 2009-2017 Percona LLC and/or its affiliates
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.
mysql> select version();
+-----------------+
| version() |
+-----------------+
版权声明:本文为博主原创文章,未经博主允许不得转载。
mysql