The first thing to do is create a database (aka Schema). Open MySQL Workbench and connect to your database server. ... (Figure F), before entering new data. Figure F. Your database is ready ...

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.

How to Create Excel Spreadsheets With MySQL. When you use MySQL to query a database, you have the ability to view results from that query on your screen or send them to a text file.