Shulou(Shulou.com)06/01 Report--

Editor to share with you how mysql query which users, I hope you will learn a lot after reading this article, let's discuss it together!

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

Mysql method for querying which users are available:

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 enter to open the cmd window

4. Enter the mysql-u root-p command, and then enter

5. Prompt for the password, enter the correct password, and enter the mysql command line

6. Enter the command in the mysql command line

Select user,host from mysql.user; returns a list of all users

After reading this article, I believe you have a certain understanding of mysql how to query which users, want to know more related knowledge, welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.