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;