登录mysql
mysql -u root -p
#注意创建用户密码应该设置更复杂一点包含大小写数字
#创建用户
mysql>create user test identified by 'Cv.123456';
# 授权用户 all privileges :代表所有权限, *.* :表示所有库的所有表,%是允许任意ip访问
mysql>grant all privileges on *.* to 'test'@'%';
#刷新权限
mysql>flush privileges;
#查看权限表
mysql>select host, user, plugin from mysql.user
注意如果:plugin是caching_sha2_password远程也无法连接,需要改成mysql_native_password
alter user 'test'@'%‘ identified with mysql_native_password by 'CV.123456';
flush privileges;
有可能会修改错误,修改前指定一下数据库就好了,每次修改记得flush privileges;
use mysql;
其它:
#更改任意主机可访问
mysql>update user set host = '%' where user = 'test';
mysql>select host, user, plugin from mysql.user
```