Skip to main content
Home
Nicholas Mangold

Main navigation

  • About
  • Projects
  • Blog
  • Contact
User account menu
  • Log in

Breadcrumb

  1. Home

Drupal

Drush throws an "Access denied; you need (at least one of) the PROCESS privilege(s)" error message

Use the --extra-dump option to pass options to the sql-dump command. Then, use the --no-tablespaces option to bypass the issue.

drush sql-dump --extra-dump=--no-tablespaces
  • Read more about Drush throws an "Access denied; you need (at least one of) the PROCESS privilege(s)" error message
  • Add new comment

Troubleshooting "ERROR 1227 (42000) at line 18: Access denied; you need (at least one of) the SUPER privilege(s) for this operation"

I experienced this issue recently while syncing a database from an Acquia hosted dev environment to my local environment. This error led me to investigate the dump file which I found included global transaction identifier (GTID) sets. I was able to work around this issue by suppressing the GTID sets using the --set-gtid-purged=OFF option for the mysqldump command. Combining that option with the drush sql-sync command allows a successful sync.

drush sql-sync @dev @self --extra-dump=--set-gtid-purged=OFF
  • Read more about Troubleshooting "ERROR 1227 (42000) at line 18: Access denied; you need (at least one of) the SUPER privilege(s) for this operation"
  • Add new comment

How to set up a local Drupal environment

A local Drupal environment can be created in many different ways. I recommend this approach for many reasons. Most of all, this method is used by many of the top professionals to develop enterprise Drupal sites. Additionally, it's automated, and easy enough for a beginner to get started, without worrying about all the technical details. At least, not to start (smirking).

  • Read more about How to set up a local Drupal environment
  • Add new comment

reCaptcha always failing

I ran into an issue implementing reCaptcha on my website, after making several updates and changes to my architecture. The problem was the reCaptcha was always failing, even after every successful submission. In order to figure out the problem, I put the following code in the submit method of the Drupal7Post class.

  • Read more about reCaptcha always failing
  • Add new comment

Your MySQL Server is too old. Drupal requires at least MySQL 4.1.1.

I received this error when I tried to reinstall Drupal. I was creating a feature to include on other sites, and wanted to make sure everything worked on a clean install. The problem was caused by the following line in my settings.php file, which I added for the Domain Access module: 

include './sites/all/modules/contrib/domain/settings.inc';

Commenting out that line allowed Drupal to install successfully.

  • Read more about Your MySQL Server is too old. Drupal requires at least MySQL 4.1.1.
  • Add new comment

How to create an email action with multiple recipients in Drupal 6

The only way I could find to have more than one recipient for an email action is to add both the Token and Token Actions modules, and then create a 'Send tokenized email...' action with the recipient email addresses separated by commas. It took me a while to figure this out. So, I hope it helps someone.
  • Read more about How to create an email action with multiple recipients in Drupal 6
  • 1 comment
  • Add new comment
Drupal

Certifications

Badge for the Acquia Certified Developer - Drupal 7 certification
Badge for the Acquia Certified Front End Specialist - Drupal 7 certification
Badge for the Acquia Certified Back End Specialist - Drupal 7 certification
Badge for the Acquia Certified Grand Master - Drupal 7 certification

Recent Projects

Argonne National Laboratory

Screenshot of the Argonne National Laboratory homepage

Texas OAG

Screenshot of the Texas OAG homepage

Siemens PartQuest

Screenshot of the  Seimens PartQuest homepage

DODEA

Screenshot of the DODEA homepage
View more projects

Recent blog entries

  • How to use sudo with Touch ID on macOS Sonoma 14.x and above
  • Drush throws an "Access denied; you need (at least one of) the PROCESS privilege(s)" error message
  • Troubleshooting "ERROR 1227 (42000) at line 18: Access denied; you need (at least one of) the SUPER privilege(s) for this operation"
  • How to set up a local Drupal environment
  • How to use sudo with Touch ID on a Mac
View more blog entries
RSS feed
Powered by Drupal