Guest User

Untitled

a guest
Mar 24th, 2018
263
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.79 KB | None | 0 0
  1. pi@raspberrypi:~ $ mysql -u root -p
  2. Enter password:
  3. Welcome to the MySQL monitor. Commands end with ; or g.
  4. Your MySQL connection id is 38
  5. Server version: 5.5.59-0+deb8u1 (Raspbian)
  6.  
  7. Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
  8.  
  9. Oracle is a registered trademark of Oracle Corporation and/or its
  10. affiliates. Other names may be trademarks of their respective
  11. owners.
  12.  
  13. Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
  14.  
  15. mysql> SELECT user,host,password FROM mysql.user WHERE user='';
  16. ERROR 1142 (42000): SELECT command denied to user 'root'@'localhost' for table 'user'
  17. mysql>
  18.  
  19. mysql> status
  20. --------------
  21. mysql Ver 14.14 Distrib 5.5.59, for debian-linux-gnu (armv7l) using readline 6.3
  22.  
  23. Connection id: 38
  24. Current database:
  25. Current user: root@localhost
  26. SSL: Not in use
  27. Current pager: stdout
  28. Using outfile: ''
  29. Using delimiter: ;
  30. Server version: 5.5.59-0+deb8u1 (Raspbian)
  31. Protocol version: 10
  32. Connection: Localhost via UNIX socket
  33. Server characterset: latin1
  34. Db characterset: latin1
  35. Client characterset: utf8
  36. Conn. characterset: utf8
  37. UNIX socket: /var/run/mysqld/mysqld.sock
  38. Uptime: 9 min 54 sec
  39.  
  40. Threads: 1 Questions: 121 Slow queries: 0 Opens: 48 Flush tables: 1 Open tables: 41 Queries per second avg: 0.203
  41. --------------
  42.  
  43. mysql>
  44.  
  45. mysql> SHOW GRANTS;
  46. +--------------------------------------------------------------------------+
  47. | Grants for root@localhost |
  48. +--------------------------------------------------------------------------+
  49. | GRANT USAGE ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD <secret> |
  50. +--------------------------------------------------------------------------+
  51. 1 row in set (0.00 sec)
  52.  
  53. mysql>
Add Comment
Please, Sign In to add comment