how do I connect my HTML page to an SQL database?

Answer 1

You can use XAMPP/WAMP/MAMP and connect it to MySQL by going to phpmyadmin.

For that use scripting languages like php

For more details see this:
https://www.raghwendra.com/blog/how-to-connect-html-to-database-with-mysql-using-php-example/

Answer 2

You can not use HTML with a SQL database directly. If you want to get data from a database and display it in your HTML page you need a Backend program written in php or node.js.