MySQL Database Services: VCU Computing Center (VCUCC) has servers dedicated to general-purpose departmental MySQL databases as well as REDCap applications.
The VCUCC has two MySQL servers. One server is designated for sensitive data, and the other is for "normal" non-sensitive data. These database resources are for departmental use only for either type of data. 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 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 Cherwell 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:
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: 04/27/2020