Navigation Map

Help Desk Home

Homebuilder

Network Operations Center

Uploading
References
Trouble Shooting
Special Characters

Counters
Forms
Password Control
RealAudio
Imagemaps
Mime Types
Web Stats

CGI Basics
Custom CGI
File Permissions
SSI's
Java!
MySQL
PHP(3)
Custom Errors
Virtual Domain FAQ
Secure Server Info

IO Web Helpdesk - MySQL


What is MySQL?

MySQL is a basically free SQL database server. SQL stands for Standard Query Language. SQL is used to build relational databases and retreive useful information from them.

Where is MySQL?

MySQL is installed on all webservers and the web development server (Atlantis.io.com) as


/usr/bin/mysql

Access to Atlantis.io.com is restricted. If you do not already have access to atlantis, you may request it by sending e-mail to admin@io.com. Note that you do NOT need to have access to Atlantis in order to use a MySQL database...Atlantis is available for those who are doing web development or need a MySQL command-line client.

Access to atlantis via ssh or telnet is only allowed from one of the existing io.com userhosts. To connect to atlantis.io.com, first, connect to 'io.com' then you can make a connection from that machine to atlantis.io.com.

We have a central MySQL server setup as mysql.io.com. To setup a database on our MySQL server, please fill out the form at http://join.io.com/mysql/.

What version of MySQL is available?


mysql Ver 9.31 Distrib 3.22.20a, for pc-linux-gnu (i686)

So how is MySQL useful to me?

MySQL can be used to create all kinds of interactive websites. You can store names and addresses, or keep a database of your favorite movies and comments about them. IO uses MySQL databases to store information about our accounts. Some other uses that have been noted on our system:

  • Storing and retrieving information for software registration.
  • WWW bulletin boards.
  • Keeping an online catalogue (shopping cart) up to date with the current number of cewrtain products available.

How should I use MySQL?

Well, we can't teach you everything, but we'll at least try to help you get started. The most common way to access, store, and retrieve information from a MySQL database is by using Perl CGI scripts. If you know of a good "howto" that could be linked here, send the URL to webmaster@io.com. There is a handy reference to MySQL and Perl in the MySQL Handbook. We have a local copy available at http://www.io.com/docs/MySQL/.

Another method of web pages interfacing with MySQL databases is through the use of PHP. PHP is a scripting language that interacts very well with databases, but we currently only have PHP version 2 available on our system and it isn't compiled to handle MySQL requests. Soon, we will have PHP version 3 available and it will have the ability to interact with MySQL databases.

You can also use certain Microsoft products to interface with the MySQL server. Aaron J. Millis was kind enough to create a simple set of instructions on how MySQL works with MS Access through ODBC. Screenshots of the setup are provided, and this information is accurate as of 30 August, 1999.

Where can I learn more about MySQL?

  • We have a mirrored copy of the MySQL Manual online at http://www.io.com/docs/MySQL/.
  • The MySQL homepage is at http://www.tcx.se/
  • Mike Miller has a website of MySQL documentation at http://www.turbolift.com/mysql/
  • You will also find that MySQL uses many of the same commands and concepts that most SQL's, so just about any book on SQL will be appropriate. (Illuminati Online's admins started out with "SQL for Dummies" published by IDG Books).
  • There is a nice online tutorial about MySQL with a Question & Answerr comment section at http://www.devshed.com/Server_Side/MySQL/Intro/.
  • There is a new MySQL book from O'Reilly and Associates published/printed August 1999. I (webmaster@io.com) just got my hands on it and just getting through about half of the book, I have to say that it is excellent.


Last revised November 19, 1999