You should always start with a processlist. For MyISAM, there isn't a dead easy 'this is the offending query' solution. SELECT FROM er +-+ user +-+ andy root root +-+ 3 rows in set (0. 64 See Marko's link for InnoDB tables and the caveats. That would be: SELECT u., groupconcat (g.name) as groups FROM USERS u JOIN GROUPUSERS gu ON gu.USERID u.ID JOIN GROUPS g ON g.ID gu.GROUPID GROUP BY u.ID HAVING SUM (g.id ) > 0 In other words, you need to move the filtering to the HAVING clause.

As you can see, two of them are for user root. You want all groups for a subset of users that are in one group. On my test system, this returns 3 records. It is common practice, for example, for each unique MySQL database on a server to have its own unique user associated with it, such that only one single user has authentication access to one single database and vice-versa. You can get back a list of users by running a simple select statement against the er table. In most cases, you’ll be granting privileges to MySQL users based on the particular database that account should have access to. In order to list all the configured DB users in a MySQL or MariaDB, you must be logged in as an administrator: /home/grokman grokmanli598-26 sudo mysql -u. There are a wide range of flags and options available to the command, so you may wish to familiarize yourself with what GRANT can actually do by browsing through the official documentation. To get the list of all users present on a MySQL server, login to MySQL Server and run the following query in mysql command line interface. 7 Oct 21 12:08 Hi Everyone, I had this thread on SQL Server forum and was told since I am using MySQL to ask for this request here: I am a newbie getting started with SQL and did some search online but so far have not been able to solve and gather the data I need. The GRANT command is capable of applying a wide variety of privileges, everything from the ability to CREATE tables and databases, read or write FILES, and even SHUTDOWN the server. To find out all MySQL users and the permissions granted to each user, log in to your MySQL server, and run the following MySQL commands.

Now that you are at the mysqlcli prompt, you need only issue the GRANT command with the necessary options to apply the appropriate permissions.

Mysql get list of users