Skip to content

Instantly share code, notes, and snippets.

@yanli0303

yanli0303/mysql-new-user-new-db.sql

Created July 16, 2021 19:38
Show Gist options
  • Save yanli0303/a6f708778c42860a37b1713991309678 to your computer and use it in GitHub Desktop.
Save yanli0303/a6f708778c42860a37b1713991309678 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql-new-user-new-db.sql
CREATE USER 'admin'@'localhost' IDENTIFIED BY 'admin';
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION;
CREATE USER 'admin'@'%' IDENTIFIED BY 'admin';
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' WITH GRANT OPTION;
SHOW GRANTS FOR mstr;
FLUSH PRIVILEGES;
CREATE DATABASE my_store CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment