这一部分没有太多可以说的内容,直接列代码:
[root@mysql-manager ~]# cat /etc/my.cnf | grep --color log-error log-error=/var/lib/mysql/log_data/mysql-error.log [root@mysql-manager ~]# [root@mysql-manager ~]# cat /var/lib/mysql/log_data/mysql-error.log | grep "A temporary password" 2017-02-21T08:23:22.195412Z 1 [Note] A temporary password is generated for root@localhost: sd:Fy-w mysql> show databases; ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. mysql> mysql> set password = password('Abcd1@34'); Query OK, 0 rows affected, 1 warning (0.01 sec) mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | ndbinfo | | performance_schema | | sys | +--------------------+ 5 rows in set (0.00 sec) mysql> exit Bye [root@mysql-manager ~]# mysql -u root -p'sd:Fy-wexit Bye [root@mysql-manager ~]#
——————————————
Done。