/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 vote210 views1 answer
Sum sqlserver
SQL
0 vote210 views1 answer
Access mysql database docker container shell
SQL
0 vote187 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote204 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
0 vote234 views1 answer
List all permissions on a table in postgres
SQL
0 vote230 views1 answer
How to add mysql to path on termin after installation
SQL
0 vote190 views1 answer
Mysql shell ERROR: Not connected.
SQL
2 votes193 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
1 vote191 views1 answer
Influxdb export to csv
SQL
1 vote177 views1 answer
Launch sql script from docker in mysql
SQL

Share