#author("2019-02-06T16:32:35+09:00","default:kuji","kuji") CONTENTS #contents ---- Lastmodified &lastmod; ---- *mysql57 [#efe61741] mysql_upgrade: [Warning] Using a password on the command line interface can be insecure. mysql_upgrade: Got error: 1862: Your password has expired. To log in you must change it using a client that supports expired passwords. while connecting to the MySQL server Upgrade process encountered error and will not continue. root@localhost [(none)]> alter user root password expire default; ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. root@localhost [(none)]> SET PASSWORD FOR root@localhost=PASSWORD('hoge'); Query OK, 0 rows affected, 1 warning (0.00 sec) root@localhost [(none)]> SET PASSWORD FOR root@localhost=PASSWORD('xxxxxxxx'); Query OK, 0 rows affected, 1 warning (0.00 sec) root@localhost [(none)]> exit Bye ---- Total access &counter(total);:本日 &counter(today);:昨日 &counter(yesterday); #counter([total|today|yesterday]);