mysql57 の履歴(No.2)

• 履歴一覧
• 差分 を表示
• 現在との差分 を表示
• ソース を表示
• 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)

CONTENTS

Lastmodified　2019-02-12 (火) 14:30:18

mysql57†

https://qiita.com/unbabel/items/b784459356686641dabe

https://qiita.com/garicchi/items/822ec2a074f09e0451c5

https://yoku0825.blogspot.com/2015/06/mysql-574defaultpasswordlifetime.html

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 1235：本日 1：昨日 0