Skip to content

Instantly share code, notes, and snippets.

@dinwwwh

dinwwwh/mysql-statements.md

Last active March 28, 2022 07:10
Show Gist options
  • Save dinwwwh/5d778544e1c6e8219585f99918eafd53 to your computer and use it in GitHub Desktop.
Save dinwwwh/5d778544e1c6e8219585f99918eafd53 to your computer and use it in GitHub Desktop.
Download ZIP
Mysql statements
Raw
mysql-statements.md

Common mysql statements

Create and gain permissions

    CREATE DATABASE `nicker`;
    CREATE USER 'nicker'@'%' IDENTIFIED BY 'P@ssw0rd';
    GRANT ALL PRIVILEGES ON `nicker`.* TO 'nicker'@'%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment