MySQL 远程访问

#进入数据库 后使用 mysql数据库查看用户概况  后面的host 是是否远程访问

use mysql;

SELECT User, Password, Host FROM user;

 

#创建remote用户 给上密码 123
CREATE USER remote IDENTIFIED BY '123';

#给remote用户远程访问权限   不限制IP地址  ‘%’
GRANT ALL PRIVILEGES ON *.* TO 'dadeity'@'%' IDENTIFIED BY 'remote' WITH GRANT OPTION;

-- 授权'remote'用户可以操作'zabbix'库的所有权限
GRANT ALL PRIVILEGES on zabbix.* TO remote@'%';
 
-- 授权用户'user'可以操作'db_test'库的所有权限,密码为'passwd'
GRANT ALL PRIVILEGES ON db_test.* TO user@'%' IDENTIFIED BY 'passwd';
 
-- 授权user可以操作db_test库的指定的权限
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, REFERENCES, INDEX, ALTER ON db_test.* TO user@'%';
 
-- 刷新权限
FLUSH PRIVILEGES; 

 

 

参考网址

https://blog.csdn.net/github_38336924/article/details/82455500

https://blog.csdn.net/besteternity/article/details/88342723