Creating MySQL Databases

on dbm1.itc.virginia.edu

You may create your MySQL database in several different ways:

  • By using phpMyAdmin (recommended). phpMyAdmin is a client program with a Web-based interface for creating MySQL databases, and it is the interface you see when you connect to dbm1.
  • By using Perl, PHP, or another language that is capable of interfacing with MySQL.
  • From the UNIX command line, using Structured Query Language commands.

All database names must begin with your UVa computing ID followed by the underscore (_) character. For example, if your user name is mst3k, and you want to create an inventory of electronic equipment in your department, you might name it mst3k_inventory.

Once you have created the database, you may also use MS Access to connect to the database (for data entry purposes only).

© 2008 by the Rector and Visitors of the University of Virginia.

The information contained on the University of Virginia’s Department of Information Technology and Communication (ITC) website is provided as a public service with the understanding that ITC makes no representations or warranties, either expressed or implied, concerning the accuracy, completeness, reliability or suitability of the information, including warrantees of title, non-infringement of copyright or patent rights of others. These pages are expected to represent the University of Virginia community and the State of Virginia in a professional manner in accordance with the University of Virginia’s Computing Policies.