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
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 firstname.lastname@example.org. 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?
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:
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 email@example.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?