- 使用mysql
mysql -u root -p
- 查看所有用户
select user,host from mysql.user;
3.查看所有数据库
show databases;
4.创建数据库
create database wp;
5.删除数据库
drop database wp;
6.创建用户
create user '${userName}'@'localhost' identified by '${password}';
5.删除用户
delete from mysql.user Where user='${userName}';
6.用户授权
grant all privileges on ${databaseName}.* to '${userName}'@'localhost';
7.退出mysql命令行
exit;