Advertisement
Guest User

Untitled

a guest
Aug 22nd, 2017
476
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. mysql -h 127.0.0.1 -u my_user --password='password' db -e "SHOW TABLES;"
  2.  
  3. print config.get('repository', 'host') // 127.0.0.1
  4. print config.get('repository', 'user') // my_user
  5. print config.get('repository', 'passwd') // password
  6.  
  7. engine = getUnaffiliatedEngine()
  8. print engine //Engine(mysql://my_user:***@127.0.0.1:3306)
  9. with engine.connect() as connection:
  10. for s in statements:
  11. if s.strip():
  12. connection.execute(s)
  13.  
  14. ps -ef | grep mysql
  15.  
  16. mysql> select User, Host from mysql.user;
  17.  
  18. +------+--------------------------+
  19. | User | Host |
  20. +------+--------------------------+
  21. |my_user 127.0.0.1 |
  22. | root | 127.0.0.1 |
  23. | root | ::1 |
  24. | | localhost |
  25. | root | localhost |
  26. +------+--------------------------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement