![]() | Alter_routine_priv | enum('N','Y') | NO | | N | | | Create_routine_priv | enum('N','Y') | NO | | N | | | Create_tmp_table_priv | enum('N','Y') | NO | | N | | | References_priv | enum('N','Y') | NO | | N | | | Field | Type | Null | Key | Default | Extra | For that you will need to get the columns list using the following command: mysql> DESC er In most cases, you might want to look at more information other than just the users’ names. +-+įrom the response, we can see that there are four users in this MySQL database server. The output will look something similar to this. With the above information, we can see that all we need is a SELECT query as shown here: SELECT Users’ information on the other hand is handled just like any other data stored in the database. MySQL has special commands that allow you to list databases and tables. ![]() In MySQL, users are stored in the user table in a special database called mysql. This tutorial shows you how to list all users in a MySQL database server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |