For security reasons, we don't permit RCI users to create their own MySQL databases. We have to do it for you. For you to be able to use MySQL with a database on a web site, we need the following information:

username: That is, the account on which the database will reside
database name: The name to give the database to be created
protection information: This should be in format of username@machine priv priv...
"machine" can include:

• - the world
• - RCI
• - php/web machine
• - rutgers.edu

You can grant a given user more than one priv, and the privs include:

• Select_priv
• Insert_priv
• Update_priv
• Delete_priv
• Grant_priv
• Index_priv
• Alter_priv

The Mysql online docs describe (not too well) what the different privs mean. In general, I'd say use Select_priv for readonly access, and Select_priv, Insert_priv, Update_priv, and Delete_priv for readwrite access. So you might want yourusername@rci to have Select_priv, Insert_priv, Update_priv, and Delete_priv for yourself and the world to have Select_priv

What we'll then do is create a database named USERNAME_DATABASENAME. You (or your appropriately authorized users) can then create tables and all other things. Unfortunately, root is the only "person" allowed to change access/grant permissions, which means you'll need to write to help@eden whenever you need such things changed.

If you're going to work with PHP/MySQL, besides getting a good book, you may want to look at some of these websites. If you do a web search, you'll also find LOTS of PHP/MySQL tutorials.

PHP Links --------
http://www.php.net/
http://www.phpwizard.net/
http://www.phpwizard.net/Documentation.8.0.html
http://www.phpbuilder.com/

MySQL links -----------
http://www.mysql.com
http://www.turbolift.com/mysql/
http://www.devshed.com/c/b/MySQL/