Bug #103393 need efficient way to bulk import grants & privileges for many users/schemas
Submitted: 21 Apr 2021 8:02
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Security: Privileges Severity:S5 (Performance)
Version:8.0.24 OS:Any
Assigned to: CPU Architecture:Any

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[21 Apr 2021 16:19] Shane Bester
testcase that shows grants get slower and slower as more users are created

Attachment: mytest_setup_grants_sp.sql (application/sql, text), 2.00 KiB.