mysql 创建 新用户 查看 所用 用户

查看所用用户

SELECT user, host FROM mysql.user;

SELECT user, host FROM information_schema.user_privileges;

删除用户

DROP USER 'john_doe'@'localhost';
FLUSH PRIVILEGES;

创建用户

CREATE USER 'abc'@'%' IDENTIFIED by '123qwe~k';

GRANT ALL PRIVILEGES ON *.* TO 'abc'@'%';

flush  privileges ;