Skip to content

Instantly share code, notes, and snippets.

@baiano
Last active August 25, 2022 02:43
Show Gist options
  • Save baiano/2b8c4ea20f1144ab8058307650b73224 to your computer and use it in GitHub Desktop.
Save baiano/2b8c4ea20f1144ab8058307650b73224 to your computer and use it in GitHub Desktop.
Create user with permissions for a new wordpress site.
CREATE USER 'newUser'@'localhost' IDENTIFIED BY 'aBigPasswordForMyDatabaseAccess';
GRANT SELECT, INSERT, CREATE, UPDATE, DELETE, ALTER, DROP, INDEX ON databaseName.* TO 'newUser'@'localhost';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment