mysql 8.0 安装区别

安装成功后有一个默认密码，查看方式

sudo grep 'temporary password' /var/log/mysqld.log

复制代码

修改密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '*{your-password}*';mysql> flush privileges;

复制代码

创建新用户

 create user 'username'@'host' identified by 'password';

复制代码

为用户授权

 grant all privileges on *.* to 'username'@'%' with grant option;

复制代码

刷新权限

 flush privileges;

复制代码

撤销授权

#收回权限(不包含赋权权限)

REVOKE ALL PRIVILEGES ON *.* FROM user_name;

REVOKE ALL PRIVILEGES ON user_name.* FROM user_name;

#收回赋权权限

REVOKE GRANT OPTION ON *.* FROM user_name;

#操作完后重新刷新权限

flush privileges;

发布于: 刚刚阅读数: 2

关注

还未添加个人签名 2020-02-06 加入

还未添加个人简介

发布

暂无评论

评论