With Beekeeper studio, create a new connection, select MySQL as the connection type and fill out the following details (Figure C): Host: The IP address or domain of your MySQL server. Port: 3306.

In this article, author Deepak Vohra discusses the details of migrating an on-prem database to a MySQL database on the cloud, using AWS Database Migration Service.

Because MySQL is such a popular database, I thought it would be a great data source to use as an illustration. This will also refresh your memory on how to set MySQL up for remote connections.

Essential tips for data formatting Before you create a database in your Excel workbook, keep several tips in mind which will help you get the desired results.