Guest User

Untitled

a guest
Dec 6th, 2017
366
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.58 KB | None | 0 0
  1. mysqldump --databases mydata --tables small_table > /home/mysqllog.log
  2.  
  3. [mysqldump]
  4. user=root
  5. password=mypassword#(of course not that)
  6. port=3306
  7. flush-logs
  8. quick
  9. single-transaction
  10.  
  11. mysql> select host,user,authentication_string from user;
  12. +-----------+-----------+-------------------------------------------+
  13. | host | user | authentication_string |
  14. +-----------+-----------+-------------------------------------------+
  15. | localhost | root | *(ofcourse u cant see this MD5 string) |
  16. | localhost | mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
  17. | % | root | *(ofcourse u cant see this MD5 string) |
  18. +-----------+-----------+-------------------------------------------+
  19. 4 rows in set (0.00 sec)
  20.  
  21. mysql> show grants;
  22. +---------------------------------------------------------------------+
  23. | Grants for root@localhost |
  24. +---------------------------------------------------------------------+
  25. | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |
  26. | GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION |
  27. +---------------------------------------------------------------------+
  28. 2 rows in set (0.00 sec)
  29.  
  30. mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
  31.  
  32. mysqldump -uroot -p --databases mydata --tables small_table > /home/mysqllog.log
  33.  
  34. Enter password:
  35. Welcome to the MySQL monitor. Commands end with ; or g.
  36. Your MySQL connection id is 986
  37. Server version: 5.7.18-log MySQL Community Server (GPL)
  38.  
  39. ......
Add Comment
Please, Sign In to add comment