MySQL Account

All students, student organizations, and instructors can request a MySQL database account. MySQL allows you to store, organize, and access information in a relational database. This database can be accessed using web tools.

Creating your MySQL Account

Your MySQL account will be created on mydb.ics.purdue.edu. Your login will be the same as your Purdue career account login, although your passwords must be different for security reasons.

  • Career Account databases are limited to 50mb of disk space.
  • You are responsible for making your application and database secure (protected from SQL injection, spam, etc.)
  • Your activities on this database will be monitored.  Purdue reserves the right to disable any database containing inappropriate material.
  • Do NOT store restricted data on your database.
    See https://www.purdue.edu/securePurdue/policies/dataConfident/dataclassif.html for the definitions of Purdue's data classifications.
  • To create a MySQL account or to reset your MySQL account password go to https://www.purdue.edu/apps/ics/a/MySQLAccount.

Accessing your MySQL Account

Students & Instructors

  • Log in to maven.itap.purdue.edu (students/staff) or guru.itap.purdue.edu (instructors). At the prompt, type: 
    mysql -h mydb.itap.purdue.edu -p
  • At the Enter password: prompt, type the password for your MySQL account.

Staff

  • Download a MySQL client for Windows, Mac OS, or Linux at http://www.mysql.com/downloads.
  • After you install the MySQL client, you can connect to your MySQL account by running the following from a command prompt or terminal window: 
    mysql -h mydb.itap.purdue.edu -u yourcareeraccountlogin -p
  • At the Enter password: prompt, type the password for your MySQL account.

Web

You can also access your MySQL Account on the web by signing in with your MySQL account and password on the following page: http://web.ics.purdue.edu/software/phpMyAdmin/

Getting Help

For more information about using MySQL, see MySQL's web site at http://www.mysql.com or the MySQL reference manual at http://dev.mysql.com/doc/mysql/en/index.html.

For more information you can search Gold Answers or contact the ITaP Customer Service Center at http://www.itap.purdue.edu/help.

Purdue University, 610 Purdue Mall, West Lafayette, IN 47907, (765) 494-4600

© 2015 Purdue University | An equal access/equal opportunity university | Copyright Complaints | Maintained by ITaP

Trouble with this page? Disability-related accessibility issue? Please contact ITaP at itap@purdue.edu.