MySQL
This procedure explains how to configure a MySQL database connection.
Open the New MySQL connection dialog. Select the tab for one of the two options:
From the editor, to attach the new database to a specific notebook
From the Home page, to add a database connection to a workspace
Notebook/EditorWorkspace/Home pageOpen the Attached data tool from the left-hand sidebar.
Switch to the Databases tab. You will see the list of all database connections available from the respective workspace.
At the bottom of the tab, click New database.
In the New database connection dialog, select MySQL.
On the Home page, select the workspace where you want to create the connection.
In the selected workspace, go to Data | Databases.
Click the Add button in the upper right corner. The New database connection dialog will open.
In the New database connection dialog, select MySQL.
On the General tab, select the connection type.
default: to connect by specifying the Host, Port, and Database.
URL only: to connect by providing the URL of a pre-built connection.
note
Use this method to pass additional parameters. For example, add
&SSL=true
to the URL string to enable SSL.
Proceed based on the selected connection type:
defaultURL onlyIn the Host field, type your server address.
In the Port field, type the port. The default port is 3306.
note
Real port numbers might be different on your system. Verify that you use a correct port number with your database administrator, server settings, or hosting provider.
Under Authentication, select an authentication method:
User & Password: to use your login and password
No auth: to connect without authentication required
In the User and Password fields, specify your credentials if required by the selected authentication method.
In the Database field, type the database name to which you want to connect.
Under Authentication, select an authentication method:
User & Password: to use your login and password
No auth: to connect without authentication required
In the User and Password fields, specify your credentials if required by the selected authentication method.
In the URL field, provide the URL of the pre-built connection you want to establish.
(Optional) For other options (SSH tunneling, scope inspection, or additional connection parameters), switch to the respective tab of the dialog and follow one of these procedures.
Click the Test connection button at the bottom of the dialog.
Once the connection is successfully tested, click the Create and close button.
If created for a specific notebook, the new connection will be automatically added to the workspace. You can later attach this database connection to any other notebook from this workspace.
If created for a workspace, this connection is added to the workspace databases and can be attached to any notebook from this workspace.
To retrieve and process data from the connected database, use Query data with SQL cells.
Thanks for your feedback!