/SQL/Show list of users in mysql

Show list of users in mysql

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

See all users mysql

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

SELECT User,Host FROM mysql.user;

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

1

Similar codes

1 vote187 views1 answer
Moodle query item quiz
SQL
0 vote214 views1 answer
Product of a column in mysql
SQL
-1 vote189 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
0 vote203 views1 answer
Reset keys in sql
SQL
0 vote199 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote188 views1 answer
Sql fetch next 10 rows pdo
SQL
0 vote183 views1 answer
Truncate table sql server foreign key
SQL
9 votes212 views1 answer
Alter table column change data type to text mysql
SQL
7 votes207 views1 answer
Oracle reset sequence
SQL
0 vote196 views1 answer
Sql how to get courses that i have made prerequisites
SQL

Share