MySQL – Alter root password – ERROR 1820 (HY000)

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: 2

Leave a Reply