Αποτελέσματα Αναζήτησης
1 Οκτ 2021 · MySQL does not have a direct command to show all users' privileges. For a quick overview, you can query the information_schema.user_privileges table: SELECT * FROM information_schema.user_privileges; However, this table only shows global user privileges without database-specific grants.
23 Μαρ 2017 · In MySQL, you can use the SHOW GRANTS command to show privileges granted to a user. Without any additional parameters, the SHOW GRANTS command lists the privileges granted to the current user account with which you have connected to the server.
24 Σεπ 2008 · To display the privileges granted to the current user (the account you are using to connect to the server), you can use any of the following statements: SHOW GRANTS; SHOW GRANTS FOR CURRENT_USER; SHOW GRANTS FOR CURRENT_USER();
18 Σεπ 2024 · Query the information_schema.processlist table to show all currently running processes and connected users: SELECT user, host, db, command FROM information_schema.processlist; The output shows the connected users, databases, and command type.
First, open Command Prompt on Windows or Terminal on Unix-like systems and log in to the MySQL server: mysql -u root -p. Second, change the current database to the mysql database: use mysql; Code language: PHP (php) Third, retrieve all users in the current database server by querying the user column of the user table:
SHOW PRIVILEGES. SHOW PRIVILEGES shows the list of system privileges that the MySQL server supports. The privileges displayed include all static privileges, and all currently registered dynamic privileges.
21 Σεπ 2018 · 16. user79644's answer gets the users with database-level privileges but will miss users with only table-level, column-level, or procedure-level privileges. To find all of them, use the following statements: SELECT user,host FROM db WHERE db='name';
