How do I connect to MySQL database from my Java applications?
The JDBC (Java Database Connectivity) engine will take care of the communication between the database server and your Java applications. To access your database using JDBC, you will need the following code to initiate the database connection:

              
 try {
  Class.forName("org.gjt.mm.mysql.Driver").newInstance();
  con = DriverManager.getConnection("jdbc:mysql://db4.3tec.com/dbname",
  "username", "password");
 } catch (Exception e) { ..... }
			  

 How do I connect to MySQL database using PHP?
To access your database using PHP, you will need the following code to initiate the database connection:

			  
 $link = mysql_connect ("db2.3tec.com", "username", "password")
  or die ("Could not connect");
 print ("Connected successfully");
 mysql_close ($link);
              

How do I connect to MySQL database in UNIX Shell?
Simply issue the following command to connect to MySQL database:

mysql -u username -p

You will be prompted to enter your password.

How to I connect to MySQL database from Windows 95/98/NT/2000?
You will need the MyODBC engine to connect to MySQL database from Windows platform. MyODBC is available as free download from MySQL Download Site.

You will need to setup the ODBC DSN before you can establish connection to database. The ODBC DSN requires the following information:

			  
    Windows DSN name:  example
    Description:       This is my test database
    MySql Database:    example
    Server:            db2.3tec.com
    User:              username
    Password:          password
    Port:
	          
	          

You will be assigned the appropriate MySQL database server address when your account is setup.

The installation of MyODBC should be very straight forward. If you experience any problems, please consult the MyODBC Installation Guide.

• Open/create/modify MySQL tables from within Access
• Connects tables from MySQL to your Access database, so that you can work with them just as they were Access tables
• Exports tables from Access to MySQL. So you can create Access tables on your local system and the data will be transferred using an append query created by MyAccess
• Imports tables from MySQL into Access
• Allows you to extract "create table script" which can be used to transfer the tables definition onto another MySQL database server
• Executes queries against the server and store the query to a file
• Logs changes
• Displays database definition report

MyAccess is available for Microsoft Access 97 and 2000. Please also note that MyODBC engine should be installed in order for MyAccess to access MySQL database over the Internet.

Do you offer web-based MySQL database management interface?
The web-based MySQL database management interface can be installed upon request. Currently we provide phpMyAdmin - an Open Source Software. Key features of phpMyAdmin include:

• Create and drop databases
• Create, copy, alter and drop tables
• Delete, edit and add fields
• Execute any SQL-statement, even batch-queries
• Manage keys on fields
• Load text files into tables
• Create and read dumps of tables
• Export data to CSV values

For more information on phpMyAdmin, please refer to phpMyAdmin Web Site.

Where can I find MySQL documentation or manual?
The official MySQL web site has excellent resources. MySQL documentation can be found here: http://www.mysql.com/documentation/index.html