hy again
To retrieve information from a database, you first need to have a database. That's where MySQL comes in. MySQL is an open-source high-performance, multi-threaded, multi-user relational database management system (RDBMS) built around a client-server architecture. It was designed specifically for speed and stability and has become one of the most popular RDBMS for database-driven Web applications, both on and off the Web. Today, more than 4 million web sites create, use, and deploy MySQL-based applications; that number rises daily. Check the MySQL Web site (http://www.mysql.com/) for details.

How can I apply for a MySQL account?

If you are interested in applying for a database account for MySQL, please fill out the Request a MySQL Database Account form. Your request will be processed within 48 hours and you will be notified via e-mail your account information.

How do I access MySQL once I have an account?

Once access is granted, you can issue queries to databases either via phpMyAdmin or directly from a PHP script.

To access your database via phpMyAdmin, log on to the page at http://www.uri.edu/phpmyadmin/ with your username and password that were sent to you in the confirmation e-mail. You are then connected to your personal mySQL database via a Web interface!

To access a mySQL database through a php script, use the following code:
<?php

mysql_connect("$DBHost","$DBUser","$DBPass") or die("Unable to connect to server");

mysql_select_db("$DBName") or die("Unable to select database");

?>

where

$DBHost is the database host name -WebDB.mis.uri.edu
$DBUser and $DBPass are the user id and password, respectively, sent to you in the confirmation e-mail and $DBName is the name of your database you requested.

You can now begin issuing queries through the php script.