原因:数据库版本较高
老版本
SET PASSWORD FOR ‘root’@localhost=PASSWORD(‘XXXXX’);
新版本
SET PASSWORD FOR root@localhost = ‘XXXXX’;
or
alter user ‘root’@‘localhost’ identified by ‘XXXXX’;
or
alter user user() identified by “XXXXXX”;
原因:数据库版本较高
老版本
SET PASSWORD FOR ‘root’@localhost=PASSWORD(‘XXXXX’);
新版本
SET PASSWORD FOR root@localhost = ‘XXXXX’;
or
alter user ‘root’@‘localhost’ identified by ‘XXXXX’;
or
alter user user() identified by “XXXXXX”;