---
title: "Drush throws an \"Access denied; you need (at least one of) the PROCESS privilege(s)\" error message"
date: "2025-02-06T01:23:31+00:00"
summary:
image:
type: "article"
url: "/acquia-cloud-platform/help/93231-drush-throws-access-denied-you-need-least-one-process-privileges-error-message"
id: "354786a3-2300-4b08-ba27-786db66dc67c"
---

Table of contents will be added

**Issue**
---------

Running a `` `drush sql-dump` `` can sometimes result in an error similar to:

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

A similar error may be:

_mysqldump: Couldn't execute 'SELECT COLUMN\_NAME ...._ _{snip}  
Unknown table 'COLUMN\_STATISTICS' in information\_schema (1109)_

**Resolution**
--------------

This issue can be bypassed by re-running the command adding some arguments to the internal call to **mysqldump** using the \--extra or \--extra-dump flag:  
  
  
For drush 8:

> `$ drush sql-dump --extra="--set-gtid-purged=off --column-statistics=0 --no-tablespaces"`

  
For drush 12:

> `$ drush sql-dump --extra-dump="--set-gtid-purged=off --column-statistics=0 --no-tablespaces"`

  
If the above does not resolve the issue, file a ticket with Acquia Support for further investigation.

**Cause** 
----------

With the recent upgrade to MySQL version 5.7 there was a change in the permissions required to utilize the `` `mysqldump` `` function used by Drush. Quote from [https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-31.html#mysqld-5-7-31-security](https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-31.html#mysqld-5-7-31-security):

> _Incompatible Change: Access to the INFORMATION\_SCHEMA.FILES table now requires the PROCESS privilege. This change affects users of the mysqldump command, which accesses tablespace information in the FILES table, and thus now requires the PROCESS privilege as well._

> _Users who do not need to dump tablespace information can work around this requirement by invoking mysqldump with the --no-tablespaces option._