Type the MySQL server name or IP address and the username and password with rights to the MySQL database you need. Click "Test Connection" and select the database from the list box.

Figure 2. Connecting to the MySQL Server via PowerShell. Once the connection is made, it's always a good idea to run a simple SELECT query to ensure we can pull information from the database. I'll be ...

Open MySQL Workbench and connect to your database server. From the database home screen (Figure A), right-click a blank spot under the SCHEMAS pane and select Create Schema.

Now, having worked with MySQL to create a database, we can begin connecting this database to a web-based front end.

This connector enables users to directly connect to databases and import data into their Databricks workspace for further analysis. If your organization plans to move from MySQL to Databricks, the ...