4. Use GUI tools to access the database server Once the system tests out fine, you can then connect to that database server with a graphical user interface tool such as Beekeeper Studio or Adminer.

Get up to speed on MySQL basics with this step-by-step tutorial on how to create a database, add a table, and input data into the table.

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.

Create the PHP file to display the report on screen. You will need to connect to the database, then retrieve, format and display the fields if you use dynamic data in your report.