Jack Wallen walks you through the process of connecting the DBeaver GUI tool to a remote MySQL server.

You must connect to the database and use the "mysql_query" function to call a MySQL stored procedure from a PHP page.

The transactions needed to store information in the database require Structured Query Language (SQL) commands placed inside a PHP script.

Use the PHP extension for MySQL to access data from the MySQL database.

I will assume you already have MySQL Workbench installed. Creating a database The first thing to do is create a database (aka Schema). Open MySQL Workbench and connect to your database server.