mysql局域网授权

– 1. 删除所有冲突的 root 用户
DROP USER IF EXISTS ‘root’@‘localhost’;
DROP USER IF EXISTS ‘root’@‘127.0.0.1’;
DROP USER IF EXISTS ‘root’@‘::1’;
DROP USER IF EXISTS ‘root’@‘WIN-U3HHLNHPALE’;
DROP USER IF EXISTS ‘root’@‘%’;

– 2. 新建一个允许所有主机连接的 root 用户
CREATE USER ‘root’@‘%’ IDENTIFIED BY ‘root’;

– 3. 给这个用户授予所有权限
GRANT ALL PRIVILEGES ON.TO ‘root’@‘%’ WITH GRANT OPTION;

– 4. 强制刷新权限，让设置立刻生效
FLUSH PRIVILEGES;

– 5. 验证结果，确认 root@% 已经创建成功
SELECT user, host FROM mysql.user WHERE user = ‘root’;