ARTICLE DETAIL

资讯详情

深耕网站建设、视觉设计与SEO优化的一线实战洞察。

MYSQL 创建用户

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;

返回列表