<div>
Query the `user` table of the `mysql` (built-in) database:<br />
SELECT * FROM mysql.user
</div>


Query the `user` table of the `mysql` (built-in) database:
SELECT * FROM mysql.user

<div>
but this does not show which databases each user has access to.
</div>


but this does not show which databases each user has access to.

<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
How can I get a list of all users and their privileges, and perhaps back them up?<br />
<br />
Thank you
</div>
</div>


Hello Experts,

How can I get a list of all users and their privileges, and perhaps back them up?

Thank you

List of Users and Their Privileges

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.