MYSQL新建用户并赋权

测试环境mysql：root/****

– 登入账号

mysql -u root -p 密码

– 所有数据库

show databases;

– 删除数据库

drop database xxxx;

–删除用户

Delete FROM mysql.user Where User=‘xxxx@%’ ；

– 查询所有用户

select user,host from mysql.user;

– 创建用户

CREATE USER ‘xxxx’ IDENTIFIED BY “xxxx”;

– 创建数据库

create database bbbb;

create database aaaa;

– 赋予所有权限

grant all privileges on bbbb.* to ‘xxxx’ identified by ‘指定密码’;

grant all privileges on aaaa.* to ‘xxxx’ identified by ‘指定密码’;

– 刷新权限

flush privileges;