UPDATE USER SET HOST = '%' WHERE USER = 'root';
SELECT HOST, USER FROM USER;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root用户密码' WITH GRANT OPTION ;
FLUSH PRIVILEGES ;
mysql 开启远程连接
最新推荐文章于 2023-04-18 16:43:06 发布
UPDATE USER SET HOST = '%' WHERE USER = 'root';
SELECT HOST, USER FROM USER;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root用户密码' WITH GRANT OPTION ;
FLUSH PRIVILEGES ;