创建用户并初始化密码

以下的权限和root一样权限

创建用户

CREATE USER 'fengye'@'localhost' IDENTIFIED BY '';

授予所有权限

GRANT ALL PRIVILEGES ON *.* TO 'fengye'@'localhost' WITH GRANT OPTION;

错误信息 ：

1251 client does not support

解决方法：

修改用户密码存储方式

ALTER USER 'fengye'@'localhost' IDENTIFIED WITH mysql_native_password BY '';