ITS Web Resources
The free MySQL accounts covered in this page are a legacy service of ITS. Due to unavoidable obsolescence and a lack of upgradeability, we no longer recommend use of MySQL accounts on dbm2.itc.virginia.edu for most applications.
ITS offers hosting for MySQL databases on the dbm2.itc.virginia.edu server.
MySQL databases may be used in conjunction with programming languages such as php, Perl, or Java to generate Web pages dynamically. Such programs should be stored on the Web server of your choice, provided that it supports that technology. For example, you might want to create a Web database application to track a computer inventory. To store the data, you could create the MySQL database on one of the MySQL servers; and then to display the data on the Web, you could create php scripts on the server that hosts your departmental website.
In order to create a Web database application like the one described above, you will need to:
- Get an account.
- Create a MySQL database.
- Create scripts or programs in the language of your choice to display the data to a Web browser. Create the script on a Web server such as people.itc.virginia.edu or faculty.virginia.edu.
- Secure your database.
Creating Your MySQL Database
Create your database using the Create Database page on dbm2.itc.virginia.edu.
For your database name, you may select any name not already allocated to a database. If you have several databases, consider starting each name with a prefix such as your account ID, to make it easy to distinguish your databases from others. There is no requirement that you do so, however.