mysql命令记录

1.创建新用户并赋予指定数据库权限给该用户(用户名:'root'@'localhost',密码:‘password’)

CREATE USER 'root'@'localhost' IDENTIFIED BY 'password';

grant all privileges on ctsida.* to root@localhost identified by 'password';

flush privileges;

posted @ 2018-04-19 11:23  赵庆-BUPT  阅读(67)  评论(0编辑  收藏  举报