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

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

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

How to Connect to MySQL in SSIS. Every business intelligence solution needs data, which might come from a variety of sources and in different formats. Microsoft SQL Server Integration Services, or ...

Might want to check your /etc/php.ini and make sure you have the "extension=mysql.so" uncommented (restart Apache if you make a change). Also might want to check over the [MySQL] section.

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.