Thursday, December 3, 2020

mySQL: Find users

 How do I find the list of users in my server?

mySQLExplinationSQL Server
select * from mysql.user;

Gets the list of users in the serverselect * from sys.syslogins;

** Don't forget to end your mySQL query with "\G" if running from the command line, as the user table is wide

No comments:

Post a Comment