/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 vote227 views1 answer
Select into table variable
SQL
11 votes228 views2 answers
Insert date sql
SQL
0 vote222 views2 answers
Wordpress change url in database
SQL
6 votes226 views2 answers
Oracle
SQL
0 vote228 views1 answer
Kill mysqld_safe process mariadb
SQL
0 vote217 views1 answer
Executescalar in sql server
SQL
0 vote241 views1 answer
Remove mysql from centos 7
SQL
0 vote219 views1 answer
Plsql check for string in numeric
SQL
0 vote238 views1 answer
Sql: extract day text from datetime value
SQL
6 votes232 views3 answers
How to delete table sqlite
SQL

Share