☰ Categories

MYSQL: Retrieve user information

Login:
mysql -u user -p

List users:
select * from mysql.user;

Select users:
select username from mysql.user;

Delete users:
delete from mysql.user WHERE User=username;