![]() | max_connections | int(11) unsigned | NO | | 0 | | | max_updates | int(11) unsigned | NO | | 0 | | | max_questions | int(11) unsigned | NO | | 0 | | | Create_tablespace_priv | enum('N','Y') | NO | | N | | | 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 | Display Only Unique Usernames in MySQL Database Some of the fields are related to privileges and permissions that each user has (such as “Insert_priv” or “Drop_priv”), and some fields are for the general properties of the user account, such as “max_connections” or “max_updates”. This is why we suggest specifying the field names, that way the output will be easily readable, and you’ll only see the information that you need. Be aware that the number of fields is typically very long/extensive, so the output likely won’t be readable and you probably don’t need all of the information available for each user. This will return all possible field information for each user. ![]() It should look like this: SELECT * FROM er You may only need the names of the users, so you can use SELECT User FROM er Īnother way to see all users is to simply use the asterisk (*) wildcard when selecting fields from the user table. If you want to add more columns or exclude some, just edit the command with the columns you need. | debian-test-user | localhost | HmBEqPjC5Y | The list of all MySQL users should be similar to the one below: +-+-+-+ MYSQL GET LIST OF USERS PASSWORDWe’ll just to query the User table to show all MySQL Users with the following command: SELECT User, Host, Password FROM er ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |