karansinghgit/Useful MySQL Commands.md

Last active June 26, 2020 18:24

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/karansinghgit/e177a31a64c01dd1ea27f6004007e652.js"></script>
Save karansinghgit/e177a31a64c01dd1ea27f6004007e652 to your computer and use it in GitHub Desktop.

Commonly Used MySQL commands for basic use-cases

Raw

USER RELATED

CREATE USER create user karan@localhost identified by 'password';
VIEW ALL USERS select user, host from mysql.user;
VIEW CURRENT USER select user();
DROP USER drop user karan@localhost
GRANT PRIVELEGES grant all privileges on *.* to karan@localhost with grant option;
SHOW PRIVILEGES OF A USER show grants;