How to make mysql connection that requires CA-CERT with sqlalchemy or SQLObject

by

To use SSL certs with SQLAlchemy and MySQLdb, use the following python code:

db_connect_string='mysql://<user>:<pswd>@<db server>:3306/<database>'
ssl_args = {'ssl': {'cert':'/path/to/client-cert', 
                     'key':'/path/to/client-key', 
                      'ca':'/path/to/ca-cert'}}

create_engine(db_connect_string, connect_args=ssl_args)

More Related Contents:

  1. How do I get a raw, compiled SQL query from a SQLAlchemy expression?
  2. How to disable SQLAlchemy caching?
  3. memory-efficient built-in SqlAlchemy iterator/generator?
  4. Writing to MySQL database with pandas using SQLAlchemy, to_sql
  5. How to build a flask application around an already existing database?
  6. SQLAlchemy ON DUPLICATE KEY UPDATE
  7. Bulk insert with SQLAlchemy ORM
  8. ImportError: No module named MySQLdb
  9. flake8 complains on boolean comparison “==” in filter clause
  10. Remove duplicates in list of object with Python
  11. Reverse engineer SQLAlchemy declarative class definition from existing MySQL database?
  12. Retrieve query results as dict in SQLAlchemy
  13. How do I connect to a MySQL Database in Python?
  14. Why do integers in database row tuple have an ‘L’ suffix?
  15. Does SQLAlchemy have an equivalent of Django’s get_or_create?
  16. Python: best practice and securest way to connect to MySQL and execute queries
  17. Install mysql-python (Windows)
  18. Flask-SQLalchemy update a row’s information
  19. Efficiently updating database using SQLAlchemy ORM
  20. Installing MySQL Python on Mac OS X
  21. Python 3.4.0 with MySQL database
  22. stored procedures with sqlAlchemy
  23. Using MySQL in Flask
  24. Repeated MySQL queries from Python return the same data [duplicate]
  25. Python import MySQLdb error – Mac 10.6
  26. sqlalchemy.exc.NoSuchModuleError: Can’t load plugin: sqlalchemy.dialects:postgres
  27. How to make an Inner Join in django?
  28. Dynamic SQL Queries with Python and mySQL
  29. Getting first row from sqlalchemy
  30. SQLAlchemy Obtain Primary Key With Autoincrement Before Commit

Leave a Comment