MySQL用户

1:查询用户
select user,host from mysql.user;
2:删除用户
Delete FROM mysql.user Where User='wordpressusername' and Host='hostname';
3:创建用户
create database testDB;
4:为用户授权和设置密码
GRANT ALL PRIVILEGES ON testDB.* TO "testDB"@"localhost"
IDENTIFIED BY "root";
5:查询在那个用户下
select user();

原文地址:https://www.cnblogs.com/bulrush/p/9070430.html