Skip to content

Instantly share code, notes, and snippets.

@StuffbyYuki

StuffbyYuki/SQL:MySQL - Create a new user and grand all the privileges

Created June 4, 2020 02:16
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save StuffbyYuki/4837e4fe89333406130b17850640494f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save StuffbyYuki/4837e4fe89333406130b17850640494f to your computer and use it in GitHub Desktop.
Download ZIP
SQL:MySQL - Create a new user and grand all the privileges
Raw
SQL:MySQL - Create a new user and grand all the privileges
--Create a new user
CREATE USER 'usrname'@'localhost' IDENTIFIED BY 'password';
--Make sure your user is on here
select user from MySQl.user;
--Grand privillages
GRANT ALL PRIVILEGES ON * . * TO 'usrname'@'localhost';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment