1、增加用户:
CREATE USER 'user_name'@'%' IDENTIFIED BY '123456';
2.增加权限:
GRANT SELECT ON *.* TO 'user_name'@'%' WITH GRANT OPTION;
3.删除用户:
drop USER 'user_name'@'%';
4.查询用户:
SELECT * FROM mysql.user;
1、增加用户:
CREATE USER 'user_name'@'%' IDENTIFIED BY '123456';
2.增加权限:
GRANT SELECT ON *.* TO 'user_name'@'%' WITH GRANT OPTION;
3.删除用户:
drop USER 'user_name'@'%';
4.查询用户:
SELECT * FROM mysql.user;