If you've ever wanted to retrieve or store information on the web, you've probably thought you might need a database. MySQL is the world's most popular open-source database, and is easily set up here at Clemson.
One option for setting up a MySQL database is to use a workgroup within Blackboard. This option provides you with a MySQL database (version 5.0.26). To create the database, log in to Blackboard at https://bb.clemson.edu, click on the Workgroups tab, and select a workgroup in which you are a member. Then click Tools and choose the MySQL Database Tool option on the right. This will allow you to create the database and retrieve the credentials for connecting to the database. You also have access to phpMyAdmin, a tool that allows you to view and access the database through the Web.
Further step-by-step instructions can be found at http://www.clemson.edu/ccit/crlt/articles/mysql_mycle.html
Although the workgroup exists within Blackboard, the databases that can be created with Blackboard are available on an external server.
Another option is to create a MySQL database through the Webmaster Request Forms on the CCIT Web site. These MySQL databases use a slightly higher version (version 5.0.45) than the version available through Blackboard.
Please check the requirements of any software you may want to install or configure to help ensure that you are using the correct version.
If you are interested in manipulating your Blackboard MySQL data in a more familiar program, like Microsoft Access, you can also download the MySQL Connector/ODBC 3.51 for MySQL databases. Once you install it, it will show up in Access 2007. You will then need to configure the connector to use your MySQL database by following these steps:
You will still need to have some programming (for example, with PHP) to connect your web site to the MySQL database, but the MySQL ODBC Connector can be used to retrieve the results of information gathered from your application. You may request that CCIT Web Services do that for you if needed by filling out our request form.
Microsoft Access is a very powerful desktop tool which can be used to analyze data and track information. The design of MS Access files is primarily for single user access (one at time) and while there are some provisions for using MS Access databases in a shared environment, our Clemson web environment does not support MS Access database web applications. If your application requires multiple user access in a shared environment on the web, we recommend you use MySQL for your personal development or discuss other development resources with us.
Microsoft Access also allows a user to import or link to other types of databases (MySQL, Oracle, etc) using something caled ODBC - Open Database Connectivity. Using the familiar MS Access application environment, you can download or view your data for analysis. Information about the Microsoft Access ODBC connectors is available at http://msdn.microsoft.com/en-us/library/ms710252(VS.85).aspx.