Connecting to MySQL¶
Anaconda Enterprise enables you to easily connect to a MySQL relational database management system (RDBMS), to access the data stored in it.
Before you can do so, however, you’ll need to install the mysql-connector-python
conda package, which contains the Python driver for communicating with MySQL servers:
NOTE: Any packages you install from the command line are available during the current session only. If you want them to persist, add them to the project’s anaconda-project.yml
file. For more information, see Developing a project.
You can then use code such as this to connect to MySQL from within a notebook session:
See Storing secrets for information about adding credentials to the platform, to make them available in your projects. Any secrets you add will be available across all sessions and deployments associated with your user account.