Skip to content

Instantly share code, notes, and snippets.

@harish2704

harish2704/create-user.sql

Created March 30, 2018 08:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save harish2704/961327ae0be9cc97867709b90acdbda5 to your computer and use it in GitHub Desktop.
Save harish2704/961327ae0be9cc97867709b90acdbda5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
create-user.sql
CREATE USER 'hari'@'%' IDENTIFIED VIA mysql_native_password USING '***';
--- GRANT USAGE ON *.* TO 'hari'@'%' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
GRANT USAGE ON *.* TO 'hari'@'%' ;
CREATE DATABASE IF NOT EXISTS `hari`;
GRANT ALL PRIVILEGES ON `hari`.* TO 'hari'@'%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment