Skip to content

Instantly share code, notes, and snippets.

@aamsur-mkt

aamsur-mkt/create-master-user.sql

Last active March 4, 2020 09:03
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save aamsur-mkt/7b243904e2cc3c2ee56e2a3282c09745 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save aamsur-mkt/7b243904e2cc3c2ee56e2a3282c09745 to your computer and use it in GitHub Desktop.
Download ZIP
Create master user that can create other user
Raw
create-master-user.sql
create user master_user@'%' identified by 'yourfpassword';
grant CREATE USER on *.* to master_user@'%';
grant GRANT OPTION USER on *.* to master_user@'%';
grant ALL on *.* to master_user@'%';
FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment