2,187
edits
Difference between revisions of "MySQL"
Jump to navigation
Jump to search
m
→Display Users: Added SyntaxHighlight
m (→Create Users: Added SyntaxHighlight) |
m (→Display Users: Added SyntaxHighlight) |
||
| Line 26: | Line 26: | ||
=== Display Users === | === Display Users === | ||
To display all configured users; | To display all configured users; | ||
<source lang="mysql"> | |||
SELECT CONCAT('SHOW GRANTS FOR \'', user ,'\'@\'', host, '\';') FROM mysql.user | |||
</source> | |||
Then use the displayed lines to see the detail of each user | Then use the displayed lines to see the detail of each user | ||