A MySQL connection consists of just a few simple parameters and it is often best to incorporate them into a conncetion file and reference it as an include.
To break that down into plain English, let's say you have twenty pages in a website and they each read from or write to you database. Either you include the database connection information in every page (which equals same code multiplied by 20) or you create a conenction file and reference it as an include in all files requiring the connection.
A connection document holds the settings to connect to your database and one line of code is required in each document that needs to connect.
Most connections are along the lines of:
Your problems is comopounded by the fact that FrontPage does not support MySQL by default, so using the database connection wizard is out, although you can sort of get a connection going locally by setting up an ODBC data source on your PC. Nopthing about that would help you connect to the database on your server though.
Now, assuming you want to connect to your server database using PHP, a very simple connection script would look like this:
$username = "MySQL username goes in here";
$password = "MySQL password goes in here";
$database = "MySQL database name goes in here";
$hostname = "localhost";
$conn = mysql_connect
("$hostname", "$username", "$password")
or die("Invalid server or user.");
Copy that into a plain text editor like Notepad and save it as dbconn.php
Now, if any of your pages need to connect to your database you should include the above file into your page, like this:
Lots of other clever PHP and HTML code can go in here....
That is how you would reference a PHP to MySQL database connection file into another PHP page, by using the include(""); command.
Now, at this stage you're probably going to tell me that you want to connect using the database wizard or do without.
Or even worse, you're going to tell me you want to use ASP with MYSQL.
If you can let us know whether you are or will be using PHP, or ASP, or if you just want to try the point and click FrontPage tools to do the work for you.
Basically though, MySQL support is not built into FrontPage so you will have to start hard coding your connection at some point.