Category: Others

AWS reinvent 2018 Slides index

Let’s take a look at AWS reinvent 2018 from these slides Leadership Session: Machine Learning (AIM202-L) – AWS re:Invent 2018 Serverless:It All Started in Vegas (DVC306) – AWS re:Invent 2018 Best Practices for Securing an Amazon VPC (NET318) – AWS re:Invent 2018 How Amazon WorkSpaces Powers the Hands-On Labs (BAP317) – AWS re:Invent 2018 A […]

Bookmark/Favorites

How to fix: Mysql ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

The error means the logined user’s password was expired, you excute the sql to confirm:

Shell
1
mysql>SELECT user,host,password,password_expired FROM mysql.user;

  To resolve the error , you can reset the password:

Shell
1
mysql>SET PASSWORD=PASSWORD('your password');

  If you got error,  you also can drop the user and create it again.

Bookmark/Favorites