ARTICLE DETAIL

建站实战干货

来自一线的建站与推广经验沉淀，每一条都经过真实交付验证。

首页 / 资讯中心 / 正文

MYSQL 创建用户

2026/9/28 18:14:05 拓冰建站 浏览量
MYSQL 创建用户

CREATE USER 'portUser'@'%' IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON port_sys.* TO 'portUser'@'%';
FLUSH PRIVILEGES;

 

ALTER USER 'root'@'%' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
FLUSH PRIVILEGES;