Advertisement
Guest User

Untitled

a guest
Jun 1st, 2016
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. # Run daemon
  2. $ mysqld
  3.  
  4. # Enter console
  5. $ mysql -u root -p
  6. Enter password: *
  7.  
  8. mysql> SHOW DATABASES;
  9.  
  10. mysql> USE mysql;
  11.  
  12. mysql> SHOW TABLES;
  13.  
  14. mysql> DESCRIBE user;
  15. mysql> SHOW COLUMNS FROM user;
  16. mysql> SHOW INDEX FROM user;
  17.  
  18. mysql> SELECT * FROM user;
  19. mysql> SELECT user, host FROM user;
  20. mysql> SELECT user, host FROM user WHERE user = 'root';
  21. mysql> SELECT user, host
  22. -> FROM user
  23. -> WHERE user = 'root';
  24.  
  25. mysql> exit
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement