show all users in mysql
snippet in sql

show all users in mysql

user5905

mysql> select * from mysql.user;

SELECT User,Host FROM mysql.user;

user2712

SELECT User,Host FROM mysql.user;
DROP USER 'testuser'@'localhost';

how to show all users in mysql

user3218

SELECT user FROM mysql.user;