Redwood Internet User's Manual

Contents:

• 1) General description of Mysql
• 2) How to use it with your account
• 3) Other resources about Mysql / home page
• 4) Mysqlperl, PHP3, Metahtml access to mysql

1) General description of Mysql

Mysql is an SQL based system allowing easy administration of large SQL based databases. The Mysql server allows fast indexing, searching, and manipulation of millions of records.

2) How to use Mysql with your account

If you would like to use Mysql, simply email us and let us know the name of the database you would like, and any other permissions you desire (such as password protection).

To access the mysql server, you can use third party software such as PHP3 or Metahtml, or from the prompt using Telnet, type:
/usr/local/mysql/bin/mysql [database_name]
If using password protection, use:
/usr/local/mysql/bin/mysql [database_name] -p

The directory /usr/local/mysql/bin is where all of the programs you will need to access and work with your database are located.

3) Other resources about Mysql

The Mysql Home Page is an excellent resource for more information about Mysql.
The Mailing List Archives is another great place to search for answers to your questions.

4) Ways to access your Mysql database

Third party software can be used to work with your Mysql database. PHP3 and Metahtml are 2 products that can be used to integrate your web pages and database.

Mysql perl is also installed to integrate perl scripts and a Mysql database. More info on mysqlperl can be found by typing "man mysqlperl" at the Telnet prompt.