以下的权限和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';