MySQL Database Support

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://localhost/loginname_dbname",
  "username", "password");
 } catch (Exception e) { ..... }

For more information on MySQL and JDBC, please refer to MM.MySQL.JDBC Resources.

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 ("localhost", "username", "password")
  or die ("Could not connect");
 print ("Connected successfully");
 mysql_close ($link);

For more information on MySQL and PHP, please refer to PHP's MySQL Functions.

Do you offer web-based MySQL database management interface?

The web-based MySQL database management interface is available under Database Management in the Panelbox. 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.

Can I use CGI to access MySQL database?

Absolutely. In fact, CGI is the most common method to access MySQL. Our Web Servers have mod_perl module as well as many other Perl-utilized CGI support installed.

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/