mySQL Essentials

When you are using mySQL as your database, you will need to connect both from your PC and with your published pages. The table shows the various combinations when using mySQL and the supported connection type.

Operating System	Function	Script Language	Connection Type
Windows	Designing with dbQwikSite	N/A	myODBC
Windows	Testing on PC	ASP	myODBC
Windows	Testing on PC	PHP	Native or myODBC
Windows	Hosting	PHP	Native
Windows	Hosting	ASP	myODBC
Linux	Hosting	PHP	Native

mySQL Connection Compatibility Chart

Where is your Database?

Another important consideration when connecting to your mySQL databases from your PC is the database's location. Do you have mySQL installed running on your PC or is your database hosted on a server on your LAN or on the Internet?

You can normally connect to mySQL no matter where it is located, but there are more restrictions and prerequisites.

Location

Requirements

Your PC

•	You must have the mySQL database program installed on your PC.

•	You must have the mySQL service running

•	You must have MyODBC.

•	You must have a myODBC connection defined.

LAN Server

•	You must have myODBC installed on your PC

•	You must have a connection defined to your LAN mySQL Server

•	Your PC must be connected to your LAN.

Hosting Server on Internet

•	You must have myODBC installed on your PC.

•	You must have a connection defined with your PC

•	Your Hosting Service must have configured mySQL security to allow remote connections.

•	You must be connected to the internet.