MySQL Database Services: VCU Computing Center (VCUCC) has servers dedicated to general purpose departmental MySQL databases as well as REDCap applications.
VCUCC has two MySQL servers: one for sensitive data and one for "normal" non-sensitive data. This database resource is for departmental use only with 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 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 the VCU Online Support at https://servicedesk.vcu.edu/ to create a Remedy ticket requesting a MySQL database
- Enter your VCU eID and password, the choose the Remedy Requester under the Quick Links on the left of the page
- Then choose the Create Request.
- Next to the “I need Assistance From/With” text box, click on the box to display a list of choices. Choose 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 VCU Computing Center provide?
- The VCUCC is responsible for 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: 09/8/2015