MySQL 打开关闭远程访问

Keva
阅读 730

在用户 mysql 下

1、查询远程权限:

SELECT
	HOST,
	USER,
	PASSWORD
FROM
	USER;

2、打开远程权限

UPDATE USER
SET HOST = '%'
WHERE
	USER = 'root'
AND HOST = 'localhost';

FLUSH PRIVILEGES;

3、关闭远程权限

UPDATE USER
SET HOST = 'localhost'
WHERE
	USER = 'root'
AND HOST = '%';

FLUSH PRIVILEGES;
回到顶部