mysql57 の履歴ソース(No.1)

• 履歴一覧
• 差分 を表示
• 現在との差分 を表示
• 履歴 を表示
• mysql57 へ行く。
  • 1 (2019-02-06 (水) 16:32:35)
  • 2 (2019-02-06 (水) 16:34:39)
  • 3 (2019-02-07 (木) 12:44:40)
  • 4 (2019-02-08 (金) 13:45:13)
  • 5 (2019-02-08 (金) 17:56:01)
  • 6 (2019-02-10 (日) 08:31:56)
  • 7 (2019-02-10 (日) 11:46:09)

#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]);