MySQL Bugs: #100229: mysqldump/mysqlpump, 8.0.21: The need for PROCESS privilege is not documented

Bug #100229	mysqldump/mysqlpump, 8.0.21: The need for PROCESS privilege is not documented
Submitted:	16 Jul 2020 3:24	Modified:	17 Jul 2020 17:45
Reporter:	Yoshiaki Yamasaki	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	8.0.21	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
mysqldump of 8.0.21 is required PROCESS privilege as follows.

  Bug#100219 mysqldump Access denied Error after upgrading to 8.0.21
  https://bugs.mysql.com/bug.php?id=100219

However, it is not documented.

In addition, mysqlpump of 8.0.21 is required PROCESS privilege also.

How to repeat:
N/A

Suggested fix:
Adding this thing in the following document.

  - Release note(with "Incompatible Change:" tag)
    https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-21.html

  - mysqldump section of MySQL 8.0 Reference Manual
    https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html

  - mysqlpump section of MySQL 8.0 Reference Manual
    https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html

Hello Yoshiaki-San,

Thank you for the report and feedback.

Thanks,
Umesh

Posted by developer:
 
The new requirement for PROCESS is due to a change in privileges for the INFORMATION_SCHEMA.FILES table.
mysqldump uses that table to get tablespace information, so it is affected by this change.

re: "In addition, mysqlpump of 8.0.21 is required PROCESS privilege also."

mysqldump does not use tablespace information, so it is not affected by this change.

Documentation revisions:

https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-21.html

The I_S.FILES change is noted as an incompatible change, along with the implication
for mysqldump and a workaround (use --no-tablespaces).

https://dev.mysql.com/doc/refman/8.0/en/information-schema-files-table.html

Mentions the need for the PROCESS privilege.

https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html

Mentions the need for the PROCESS privilege unless --no-tablespaces is used.

Similar changes apply in MySQL 5.6 and 5.7.

Bug #100219 marked as duplicate of this one