本地数据库被禁止连接 1130 - Host ‘DESKTOP- is not allowed to connect to this MySQL server

tomysql -u root -p -h localhost

-- 授权root用户从任意主机连接（%表示所有主机）
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

-- 1. 先创建允许所有主机连接的root用户（密码替换为你的实际密码）
CREATE USER 'root'@'%' IDENTIFIED BY 'root';

-- 2. 再授权权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;

-- 3. 刷新权限
FLUSH PRIVILEGES;