I want to show you how to install and use DBeaver to connect to your remote MySQL server. DBeaver is available for Windows, macOS, and Linux.

Inside the script is a command to connect to the database and execute a query (perform the search for books). PHP opens a connection to the MySQL server and sends on the appropriate query. 4.

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.