Show all the users of mysql

Go to mysql prompt:
SELECT User FROM mysql.user;
mysql:root:(none)> select user from mysql.user
-> ;
+———+
| user |
+———+
| bigip |
| dce |
| gwap |
| myadmin |
| slave |
| dce |
| root |
+———+
7 rows in set (0.01 sec)

Related posts:

  1. Give grant of the database to other systems.
  2. Restore Mysql dump.
  3. Create Mysql user with all privileges.
  4. What is “cross apply” and “outer apply” keyword in SQL Server?
This entry was posted in Linux, My SQL and tagged on by .

About Rahul Thakur

Hi, this is Rahul working as Software Engineer at Orange Business Services. Responsible for Requirement analysis, design ,development, deployment, and testing. Working on Agile methodology and Scrum Experience on UML, OOAD, OOPS, Design patterns, Java / J2ee technologies, ORM, performance and load tests, code review and lot of SDLC activities.