Advertisement
Guest User

Untitled

a guest
Aug 2nd, 2016
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.54 KB | None | 0 0
  1. www@toolbox:~/shift/ui/config/environments$ cat development.rb
  2. Rails.application.configure do
  3.  
  4. ... snipped ...
  5.  
  6. ## mysql_helper
  7. # read-only credentials for shift to connect to and inspect all hosts
  8. config.x.mysql_helper.db_config = {
  9. :username => "shift",
  10. :password => "xxx",
  11. :host => "192.168.x.y"
  12. }
  13.  
  14. ... snipped ...
  15.  
  16. end
  17. www@toolbox:~/shift/ui/config/environments$ mysql -u shift -p -h 192.168.x.y
  18. Enter password:
  19. Welcome to the MySQL monitor. Commands end with ; or \g.
  20. Your MySQL connection id is 2441077
  21. Server version: 5.6.30-76.3 Percona Server (GPL), Release 76.3, Revision 3850db5
  22.  
  23. Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
  24.  
  25. Oracle is a registered trademark of Oracle Corporation and/or its
  26. affiliates. Other names may be trademarks of their respective
  27. owners.
  28.  
  29. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  30.  
  31. mysql> show databases;
  32. +--------------------+
  33. | Database |
  34. +--------------------+
  35. | information_schema |
  36. | redacted |
  37. | mysql |
  38. | performance_schema |
  39. | shift_demo |
  40. | shift_development |
  41. | shift_test |
  42. | sys |
  43. +--------------------+
  44. 8 rows in set (0.00 sec)
  45.  
  46. mysql> select * from clusters\G
  47. *************************** 1. row ***************************
  48. id: 1
  49. name: default-cluster-001
  50. app: local-app
  51. rw_host: 192.168.x.y
  52. port: 3306
  53. admin_review_required: 0
  54. is_staging: 1
  55. 1 row in set (0.00 sec)
  56.  
  57. mysql> exit
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement