测试环境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;