Skip to content

Instantly share code, notes, and snippets.

@oliworx

oliworx/new-mysql-db-and-user.sql

Last active June 20, 2023 03:23
Show Gist options
  • Save oliworx/1ce8d0366906a80a0e815784df62ad50 to your computer and use it in GitHub Desktop.
Save oliworx/1ce8d0366906a80a0e815784df62ad50 to your computer and use it in GitHub Desktop.
Download ZIP
Create a New DB and User in MySQL
Raw
new-mysql-db-and-user.sql
CREATE DATABAESE MYNEWDB;
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON MYNEWDB.* TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment