mysql 添加用户并授权

Posted on 2016-05-07 22:00  LoveAI  阅读(182)  评论(0)  编辑  收藏  举报

mysql> create database dogDB;

mysql> CREATE USER 'dog'@'%' IDENTIFIED BY '123456';

mysql> grant all on dogDB.* to 'dog'@'%' identified by '123456';