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

This article is about how to query all users in mysql. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

How to query all users in mysql: execute [SELECT DISTINCT CONCAT ('User:'', user,'''@''',host,''';') AS query FROM mysql.user;] to view it.

View all users in the MYSQL database

Mysql > SELECT DISTINCT CONCAT ('User:'', user,'''@''',host,''';') AS query FROM mysql.user

View the permissions of a specific user in the database

Mysql > show grants for 'cactiuser'@'%';mysql > select * from mysql.user where user='cactiuser'\ G

Viewing the user table structure requires specific items that can be queried in combination with the table structure

Mysql > desc mysql.user; Thank you for reading! This is the end of the method of querying all users in mysql. I hope the above content can be helpful to you so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.

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.