MySQL Account
All students 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) 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.
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.