March 21

MYSQL: Retrieve user information

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;

Copyright 2021. All rights reserved.

Posted March 21, 2013 by Timothy Conrad in category "Databases

About the Author

If I were to describe myself with one word it would be, creative. I am interested in almost everything which keeps me rather busy. Here you will find some of my technical musings. Securely email me using - PGP: 4CB8 91EB 0C0A A530 3BE9 6D76 B076 96F1 6135 0A1B