Advertisement
Guest User

Untitled

a guest
Apr 5th, 2016
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. #### Show all databases: ####
  2. show databases;
  3.  
  4. #### List databases size: ####
  5. SELECT table_schema AS "Database name", SUM(data_length + index_length) / 1024 / 1024 AS "Size (MB)" FROM information_schema.TABLES GROUP BY table_schema;
  6.  
  7. #### Reset root password: ####
  8. service mysql stop
  9. mysqld_safe --skip-grant-tables &
  10. mysql -u root
  11. mysql> USE mysql;
  12. mysql> UPDATE USER SET password=PASSWORD("NEW-ROOT-PASSWORD") WHERE User='root';
  13. mysql> FLUSH PRIVILEGES;
  14. mysql> quit
  15. mysqladmin shutdown
  16. service mysql start
  17. mysql -u root -p
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement