Mysql8.0 用户的的添加和修改

MySQL用户的添加和授权

创建用户：CREATE USER wangwei@127.0.0.1 IDENTIFIED BY 'passowrd';
给用户授权：GRANT ALL ON . TO wangwei@127.0.0.1 WITH GRANT OPTION;

修改用户密码

ALTER USER ‘wangwei’@‘127.0.0.1’ IDENTIFIED BY ‘wangwei’;

最后刷新一定要刷新下：flush privileges;