MySQL 新建用户并赋予权限

创建一个用户:

  create user 'oukele'@'%' identified by 'oukele'; 

提示下面所列出的信息的话,得刷新一下权限表

  The MySQL server is running with the --skip-grant-tables option so it cannot execute this st...

步骤如下:

  

 

 

MySQL8 ---->

flush PRIVILEGES;
create user
'oukele'@'%' identified by 'oukele';
grant all privileges on
*.* to 'oukele'@'%';
flush PRIVILEGES;

 

posted @ 2019-11-09 22:57  追梦滴小蜗牛  阅读(671)  评论(0编辑  收藏  举报