1.mysql5.7
SELECT PASSWORD('123456')
UPDATE user
SET authentication_string=PASSWORD('123456')
WHERE user='root'
2.mysql8.0.11
移除了password()方法
https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html#function_password
1.mysql5.7
SELECT PASSWORD('123456')
UPDATE user
SET authentication_string=PASSWORD('123456')
WHERE user='root'
2.mysql8.0.11
移除了password()方法
https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html#function_password