'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces I am trying to backup mysql using the command
mysqldump -u root -p  database_name &gt; backup.sql

, but it is throwing an error:

'Access denied; you need (at least one of) the PROCESS privilege(s)
for this operation' when trying to dump tablespaces

Also, I wanted to make a backup my database with all tables seperately stored as a file. How can I do it?
mysql version = 5.7.31
use --no-tablespaces
see mysqldump-Documentation

mysqldump requires at least the SELECT privilege for dumped tables,
SHOW VIEW for dumped views, TRIGGER for dumped triggers, LOCK TABLES
if the --single-transaction option is not used, and (as of MySQL
8.0.21) PROCESS if the --no-tablespaces option is not used.
Certain options might require other privileges as noted in the option
descriptions.

and see documentation of param no-tablespaces

--no-tablespaces, -y
This option suppresses all CREATE LOGFILE GROUP and CREATE TABLESPACE
statements in the output of mysqldump.