关于添加MySQL用户遇到的问题

You can use:

SET PASSWORD FOR 'root' = PASSWORD('elephant7');
or, in latest versions:

SET PASSWORD FOR root = 'elephant7'
You can also use:

UPDATE user SET password=password('elephant7') WHERE user='root';
but in Mysql 5.7 the field password is no more there, and you have to use:

UPDATE user SET authentication_string=password('elephant7') WHERE user='root';
Regards

**注意**：在 MySQL5.7 中 user 表的 password 已换成了**authentication_string**。
**注意**：**password()** 加密函数已经在 8.0.11 中移除了，可以使用 MD5() 函数代替。