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.
what is MySqL
Linear Mode
