mysql8创建用户并授权,刷新权限

以下的权限和root一样权限

创建用户

CREATE USER 'zhangsan'@'%' IDENTIFIED BY zhangsan123';

授予所有权限

GRANT ALL PRIVILEGES ON *.* TO 'zhangsan'@'%' WITH GRANT OPTION;

错误信息 ：
1251 client does not support

解决方法：
修改用户密码

ALTER USER 'zhangsan'@'%' IDENTIFIED WITH mysql_native_password BY 'zhangsan111';

刷新权限

flush privileges;