mysql8修改数据库密码，报错ERROR 1064 (42000)
原来的修改密码语句为UPDATE user SET authentication_string = password('123456') WHERE User='root';在mysql8中会报错：ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use ne
