MySQL

The recommended connector library for MySQL is mysqlclient.

Here’s the connection string:

  1. mysql://{username}:{password}@{host}/{database}

Host:

  • For Localhost: localhost or 127.0.0.1
  • Docker running on Linux: 172.18.0.1
  • For On Prem: IP address or Host name
  • For Docker running in OSX: docker.for.mac.host.internal Port: 3306 by default

One problem with mysqlclient is that it will fail to connect to newer MySQL databases using caching_sha2_password for authentication, since the plugin is not included in the client. In this case, you should use mysql-connector-python instead:

  1. mysql+mysqlconnector://{username}:{password}@{host}/{database}