Skip to content

Instantly share code, notes, and snippets.

@SantoshCode

SantoshCode/mysql-create-user-and-grant.md

Created March 6, 2022 18:13
Show Gist options
  • Save SantoshCode/e4ab6a7b1f33ef4331cf329a2642a83e to your computer and use it in GitHub Desktop.
Save SantoshCode/e4ab6a7b1f33ef4331cf329a2642a83e to your computer and use it in GitHub Desktop.
Download ZIP
Create a user in mysql and grant all access to that user
Raw
mysql-create-user-and-grant.md 
mysql -u root
CREATE USER 'santosh123'@'localhost' IDENTIFIED BY 'secretpassword123';
GRANT PRIVILEGES ON *.* TO 'santosh123'@'localhost';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment