Problem
You get the following error when executing scripts
ERROR 1820 (HY000) at line 20: You must reset your password using ALTER USER statement before executing this statement.
Solution
Log in as root
At the MYSQL prompt type SET PASSWORD= PASSWORD(‘newpassword’)
mysql> SET PASSWORD= PASSWORD(‘newpassword’)
Tested Platform
MySQL Server 5.7.19
Hits: 157