MySQL修改密码和设置远程登录

MySQL5.5

# 修改 root 用户密码
UPDATE USER SET PASSWORD = PASSWORD('123') WHERE HOST = 'localhost' AND USER = 'root'
# 给 root 用户远程权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123';
# 创建系统账号：
CREATE USER 'wenyuan'@'%' IDENTIFIED BY '123';
# 授权数据库： GRANT 权限 ON 数据库.对象 TO 用户;
GRANT ALL PRIVILEGES ON chenfeng.* TO 'wenyuan'@'%';
# 刷新权限
FLUSH PRIVILEGES;
# 查看账号
SELECT HOST,USER FROM mysql.user;

MySQL8

-- 1. 先创建允许远程的 root 用户
CREATE USER 'root'@'%' IDENTIFIED BY '你的数据库密码';

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

-- 3. 刷新权限（必须）
FLUSH PRIVILEGES;