Skip to content

Instantly share code, notes, and snippets.

@carlessanagustin

carlessanagustin/my_cheatsheet.sql

Last active June 21, 2018 10:38
Show Gist options
  • Save carlessanagustin/32e41b3d8f22f2545cb87f84e316c7e2 to your computer and use it in GitHub Desktop.
Save carlessanagustin/32e41b3d8f22f2545cb87f84e316c7e2 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL Cheat Sheet
Raw
my_cheatsheet.sql
# Show users
SELECT User, Host, Password FROM mysql.user;
# Create backup user
GRANT ALL PRIVILEGES ON *.* TO `backup`@`localhost` IDENTIFIED BY 'backup_password';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment