MySQL info

 
All accounts come with a mysql database and is initialised. The database name is the same as your username. The password is unique, however. It is different than your ssh password to enhance account/database security.

As a prerequisite, to this tutorial, you will need to know basic SSH. If you aren't familiar with ssh yet, you can follow Begining Unix and SSH Tutorial.


Hurricane electric is one of the Official Mirrors of MySQL at http://mysql.he.net

There are 4 main ways of using your database:

  1. directly fromt the command prompt, issuing SQL commands.
    Follow the tutorial above or one of the links bellow

  2. using Perl DBI, DBD or Mysql module from a CGI script or a command line perl script
    We have a tutorial how to use CGI
    There's also a cannonical example of how to use CGI

  3. Using PHP. a simple way to interface the database to display on a web site.
    PHP Related site and references

  4. In a C or C++ program, either a standard program or with CGI.

Other ways are also possible, but not commonly used. check also the MySQL FAQ


Further Documentation on Mysql, SQL, Web database programming and tutorials

Mysql Main page   Official Mirror at Hurricane Electric
Searchable   Online MySQL Manual
Commands   Basic and important commands list
Ask the SQL pros   Inquiry.com SQL/Database forums

 
Convert MS Access to Mysql   Access 95-2000
Convert ASP into PHP   Resistance is *not* futile

 
DBI Reference   Perl Database Interface
PHP MySQL Reference   Local Mirror
Webmonkey   PHP/MySQL tutorial
Webmonkey tutorial   Bultin Board creation with PHP/MySQL
PHP & Mysql Tutorial   Vermont WebWizard
Devshed's Mysql tutorials and articles   Lots of interesting stuff for serious developers.

Hurricane Electric
760 Mission Court
Fremont, CA 94539
FAQ Index   --   Tutorial Index
Copyright © 1994 - 2004 Hurricane Electric.
All Rights Reserved.
Voice 510.580.4100
Fax 510.580.4151
Comments? info@he.net