How to query which users are there in mysql

Mysql method to query which users are: First click the start menu button and search for cmd; then command [mysql -u root -p] in the window; finally enter the code [select user, host from mysql.user; 】Just make a query.

Mysql method to query which users are:

1. Click the start menu button in the lower left corner

2. Search for cmd in the search box below the start menu

3. Press the Enter key to open the cmd window

4. Enter the mysql -u root -p command and press Enter

5. When prompted to enter the password, enter it correctly. Password, enter the mysql command line

6. Enter the command

select user,host from mysql.user; in the mysql command line to return a list of all users

More related free learning recommendations: mysql tutorial(Video )

The above is the detailed content of How to query which users are there in mysql. For more information, please follow other related articles on the PHP Chinese website!