/SQL/List mysql users

List mysql users

Show list of users in mysql

//To show all data use following query
select * from mysql.user;
// To show user and host use following query
select User,Host from mysql.user;

9

List mysql users

mysql> select host, user, password from mysql.user;

8

Source: alvinalexander.com

Display users in mysql

#display all user data
select * from mysql.user;
#display username and host
select user, host from mysql.user;

4

Mysql list users on ubuntu

SELECT User FROM mysql.user;

2

Source: fastwebhost.in

SELECT User,Host FROM mysql.user;

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

1

Similar codes

1 vote255 views1 answer
Return size of tables in mysql
SQL
6 votes256 views1 answer
What is where clause in sql
SQL
0 vote277 views1 answer
Change permission to database mysql
SQL
-1 vote263 views1 answer
Add bool column in sql
SQL
0 vote269 views1 answer
Open postgresql.conf in centos
SQL
3 votes303 views2 answers
Synonym oracle
SQL
0 vote276 views1 answer
Get date ISO in psql
SQL
1 vote253 views2 answers
How to check username in mysql command line
SQL
0 vote318 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
1 vote258 views1 answer
How to make a select in sql
SQL

Share