Get the App
SLTechnology News&Howtos  ›  Database  › 

How to obtain mysql user Rights in batches

Shulou Source: shulou.com Published: 2022-06-01 19:51:27 11月16日 Update

The following mainly brings you how to obtain mysql user rights in batches. I hope these words can bring you practical use, which is also the main purpose of how I edit mysql user rights to obtain this article in batches. All right, don't talk too much nonsense, let's just read the following.

-- permissions at the CVM level

Select a.GRANTEEEE GROUPPRONCONcat (a.PRIVILEGE_TYPE), concat ("grant", GROUP_CONCAT (a.PRIVILEGE_TYPE), "ON *. * to", a.GRANTEE) from USER_PRIVILEGES a GROUP BY GRANTEE

-- permissions at db level

Select GRANTEE,TABLE_SCHEMA,GROUP_CONCAT (PRIVILEGE_TYPE), concat ("grant", GROUP_CONCAT (PRIVILEGE_TYPE), "ON", TABLE_SCHEMA, ". * to", GRANTEE) from information_schema.SCHEMA_PRIVILEGESGROUP BY GRANTEE,TABLE_SCHEMA

-- Table-level permissions

Select GRANTEE,TABLE_SCHEMA,table_name,GROUP_CONCAT (PRIVILEGE_TYPE), concat ("grant", GROUP_CONCAT (PRIVILEGE_TYPE), "ON", TABLE_SCHEMA, ".", table_name, "to", GRANTEE) from information_schema.TABLE_PRIVILEGESGROUP BY GRANTEE,TABLE_SCHEMA,table_name

-column level permissions

Select GRANTEE,TABLE_SCHEMA,table_name,COLUMN_NAME,GROUP_CONCAT (PRIVILEGE_TYPE) from information_schema.COLUMN_PRIVILEGESGROUP BY GRANTEE,TABLE_SCHEMA,table_name,COLUMN_NAME

-- obtain user permissions and passwords (ciphertext)

Select a.GRANTEEEE GROUPPERCONcat (a.PRIVILEGE_TYPE), concat ("grant", GROUP_CONCAT (a.PRIVILEGE_TYPE), "ON *. * to", a.GRANTEE, "identified by password'", c.authentication_string, "';") privifrom USER_PRIVILEGES a left join mysql.user con a.GRANTEE = concat ("'", c.user, "'", "@", "", c.host, "'") GROUP BY GRANTEE

For the above about how to obtain mysql user rights in batches, do you think it is very helpful? If you need to know more, please continue to follow our industry information. I'm sure you'll like it.

Tags: Permissions user level following content actual ciphertext password nonsense text more server usefulness purpose article industry information help service Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Docker NVidia Xiaomi macOS Linux