1. Technology Services
2. askIT
3. Services and Networking
4. Computer Center
5. Database Administration
6. MySQL

MySQL

MySQL Database Services: VCU Computing Center (VCUCC) has servers dedicated to general-purpose departmental MySQL databases as well as REDCap applications.

The VCU University Computing Center maintains three MySQL servers.  One is dedicated to the RedCap project.  The other 2 exist as test and production system(s) and may contain "sensitive" or category 1 data.  These database resources are for departmental use only. Current resources have limited the VCUCC responsibility to software installation and maintenance, backup and recovery, database creation, and MySQL account creation. Application support is not available.  Access to the server is limited to on-campus or through a VPN.

Contact the VCUCC DBA Staff at ts-uccba@lists.vcu.edu for more details or if you have questions about the MySQL database services.

VCU’s MySQL Frequently Asked Questions:

• How can I get a MySQL database?
  • Go to IT Support at https://go.vcu.edu/itsupport  to create a Support Ticket requesting a MySQL database
  • Enter your VCU eID and password, from the dashboard choose "Servers, Storage & Data," Database Management, Database
    Next, select Request a New Database.
  • Continue to fill out the form and submit upon completion.
  • You will be contacted if there are any questions or when the database has been created and is available for use.
• How do I get a MySQL account?
  • When you request a MySQL database, an administrative MySQL ID (the database owner) will be created. It is up to that administrator to identify any other necessary MySQL accounts for the VCUCC staff to create.
  • These accounts are limited to use on campus or through VPN.
• What kind of support does the VCU Computing Center provide?
  • The VCUCC is responsible for the installation and maintenance of the MySQL server and database.
  • Database creation, MySQL account creation, backups, and recovery.
  • No application support is available at this time.
  • Pointers to documentation and how-to's will be maintained.
• Are there any MySQL database management tools available?
  The following is a partial list of GUI tools:
  • HeidiSQL
  • The MySQL Workbench is the new management interface.
  • There is also Toad for MySQL, too.

Useful websites for MySQL:

• http://www.mysql.com This is the main site for MySQL at Oracle Corp.
• http://dev.mysql.com Developer information.
• http://dev.mysql.com/doc Documentation for quite a lot of versions and different aspects of the database system.
• http://dev.mysql.com/downloads The Download Center.

This article was updated: 10/9/2024