/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

0 vote182 views1 answer
Sql query contains multiple ids
SQL
8 votes186 views1 answer
Oracle add auto_increment column to existing table
SQL
0 vote176 views1 answer
Get number of rows in every table mysql
SQL
0 vote187 views1 answer
Sql how to get courses that i have made prerequisites
SQL
7 votes171 views1 answer
Forge server hosting
SQL
0 vote233 views1 answer
Joomla execute raw sql
SQL
0 vote185 views1 answer
Sql offfset
SQL
0 vote176 views1 answer
Sql constarint
SQL
0 vote158 views1 answer
Store query result in variable sql
SQL
1 vote196 views1 answer
Create table variable in sql stored procedure
SQL

Share