Skip to content

Instantly share code, notes, and snippets.

@pjendrusik

pjendrusik/recover all privileges

Created August 26, 2014 14:40
Show Gist options
  • Save pjendrusik/29867bdb9697c6eefbea to your computer and use it in GitHub Desktop.
Save pjendrusik/29867bdb9697c6eefbea to your computer and use it in GitHub Desktop.
Download ZIP
recover all privileges
Raw
recover all privileges
UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';
FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment