[MySql]

打开 mysql 的查询窗口(使用root),使用SQL:

-- 使用mysql库
use mysql;

-- 更新密码
update user set password=PASSWORD('xxxxxxxx') where User='root';

-- 开启外部访问权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'xxxxxxxx' WITH GRANT OPTION;
-- 提交
FLUSH PRIVILEGES;
原文地址:https://www.cnblogs.com/HD/p/4091825.html