Difference between revisions of "MySQL Cheat Sheet"
Jump to navigation
Jump to search
Michael.mast (talk | contribs) (Created page with "<ref>http://alvinalexander.com/blog/post/mysql/show-users-i-ve-created-in-mysql-database</ref>*View users select host, user, password from mysql.user; <ref>http://stackoverfl...") |
Michael.mast (talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | <ref>http://alvinalexander.com/blog/post/mysql/show-users-i-ve-created-in-mysql-database</ref>*View users | + | <ref>http://alvinalexander.com/blog/post/mysql/show-users-i-ve-created-in-mysql-database</ref> |
| + | *View users | ||
select host, user, password from mysql.user; | select host, user, password from mysql.user; | ||
| − | <ref>http://stackoverflow.com/questions/4561292/how-to-clear-query-cache-in-mysql</ref>*Remove history (this is kept in your home directory) | + | <ref>http://stackoverflow.com/questions/4561292/how-to-clear-query-cache-in-mysql</ref> |
| + | *Remove history (this is kept in your home directory) | ||
rm -rf ~/.mysql_history | rm -rf ~/.mysql_history | ||
*Remove user | *Remove user | ||
| Line 12: | Line 14: | ||
grant all on test.* to 'michael'@'172.17.0.34' identified by 'mypassword'; | grant all on test.* to 'michael'@'172.17.0.34' identified by 'mypassword'; | ||
</pre> | </pre> | ||
| + | <ref>http://dev.mysql.com/doc/refman/5.7/en/show-grants.html</ref> | ||
| + | *Show granted privileges | ||
| + | <pre>SHOW GRANTS FOR 'root'@'localhost';</pre> | ||
Revision as of 15:11, 23 December 2016
- View users
select host, user, password from mysql.user;
- Remove history (this is kept in your home directory)
rm -rf ~/.mysql_history
- Remove user
drop user <username>@<host>;
- Remove database
drop database <databasename>;
- Grant privileges
grant all on <database>.<table> to <user>@<host> identified by '<password>'; grant all on test.* to 'michael'@'172.17.0.34' identified by 'mypassword';
- Show granted privileges
SHOW GRANTS FOR 'root'@'localhost';
