Login   |   ITaP Home > Teaching & Learning > Purdue Career Account

 

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

To create a MySQL account, go to https://www.purdue.edu/apps/ics/a/MySQLAccount.

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.

Accessing your MySQL Account

Students & Instructors

  • Log in to expert.ics.purdue.edu (students/staff) or mentor.ics.purdue.edu (instructors). At the prompt, type:
    mysql -h mydb.ics.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.ics.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.

The answer to your question might be in Gold Answers Knowledgebase. If you still need assistance, please contact the ITaP Customer Service Center by phone (765)494-4000, via email at itap@purdue.edu or by visiting STEW G65.