???????????????????????MySQL??????root??????????
???????????????skip-grant-tables?????????崠?????￡?
????1. ???MySQL????????root???????????mysqladmin??????????????????kill pid??????
?????????????????kill ??kill -9??????
???????????￡?kill ????SIGTERM???????????????????????????????????????в??????
????kill -9 ????SIGKILL??????????????????????????????????????SIGTERM???????????????????????????????????????????????????????????κ?????
??????????????????????kill -9???????????????MySQL???????????????????????????
????2. ??my.cnf???[mysqld]???????skip-grant-tables????
????3. ???????????root?????????
?????????????root?????????????
????1> mysql> set password for 'root'@'localhost'=password('123'); ???????????
????2> mysql> update mysql.user set password=password("456") where user="root" and host="localhost";
????mysql> flush privileges;
????3> # mysqladmin -u root password "123"
????4. ????????????skip-grant-tables??????????????????
???????????????????????????и????????????????????????????????????????????????
???????????????????????е?“??????”??ζ??
??????????????????mysql.user?????MyISAM??????????
????1. ?????????mysql.user??copy???????????????￡???磬test??????????

????2. ?????????????????????????????????????????root????
????mysql> select user??host??password from test.user;
????+------+-----------+-------------------------------------------+
????| user | host      | password                                  |
????+------+-----------+-------------------------------------------+
????| root | localhost | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
????+------+-----------+-------------------------------------------+
????1 row in set (0.00 sec)
????mysql> update test.user set password=password("hello") where user="root" and host="localhost";
????Query OK?? 1 row affected (0.15 sec)
????Rows matched: 1  Changed: 1  Warnings: 0
????3. ?????????????copy????????

????4. ???mysqld??pid?????kill -HUP `pidof mysqld`?????mysqld??????????????????

????[root@keepalived01 ~]# mysql -phello
????Warning: Using a password on the command line interface can be insecure.
????ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
????[root@keepalived01 ~]# kill -HUP 4283
????[root@keepalived01 ~]# mysql -phello
????Warning: 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 2528
????Server version: 5.6.26 MySQL Community Server (GPL)
????Copyright (c) 2000?? 2015?? 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>
???????????????????????kill -HUP?????????????hello??????????kill -HUP???????????????
?????????????????????ο???????????????????????????У???????????????????