Αποτελέσματα Αναζήτησης
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();
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.
28 Αυγ 2012 · This Linux shell fragment loops over all MySQL users and does a SHOW GRANTS for each: mysql --silent --skip-column-names --execute "select concat('\'',User,'\'@\'',Host,'\'') as User from mysql.user" | sort | \. while read u.
23 Μαρ 2017 · Show MySQL users and hosts they are allowed to connect from: mysql> SELECT user,host FROM mysql.user; Show MySQL users, their passwords and hosts: mysql> SELECT user,host,password FROM mysql.user; in MySQL 5.7 and higher: mysql> SELECT host,user,authentication_string FROM mysql.user;
21 Σεπ 2018 · 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'; SELECT user,host FROM tables_priv WHERE db='name'; SELECT user,host FROM columns_priv WHERE db='name';
show grants works fine but if you need to know if user has special access from a specific IP/domain, a better command is: select * from information_schema.user_privileges where grantee like '%username%'; Sometimes, you can mess around creating users like username@localhost and the command above can help on discovering these pitfalls.
20 Απρ 2019 · MySQL server allows us to create numerous users and databases and grant appropriate privileges so that the users can access and manage databases. This tutorial explains how to use the command line to create and manage MySQL or MariaDB databases and users.
