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.

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

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.