MySQL Account

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/data-handling/index.php 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.