MySQL FAQ

What kind of web database is available?
MySQL 3.23.53a.

What is the name of the MySQL server?
mysql2.stern.nyu.edu

How do I get an account or renew my account on the MySQL server?
You may download the MySQL online form here. Please note that all spaces are mandatory. After you have filled out the form and signed below Account Policy, return the form to Brenda Mitchell in KMC UC-122.

From where can I connect to MySQL?
Regular accounts can connect to MySQL from anywhere within the Stern local area network.

How do I connect to MySQL?
After you've logged in to your Sales shell account using a secure connection, type in the following command: mysql -u <username> -h mysql2 -p <dbname>

How do I change my password in MySQL?
After you've logged in to MySQL, type in the following command:
set password=password('new_password');
The single quotes in the parentheses are required.

NOTE: You should have a MySQL password that is different from your email password. Your MySQL password will not automatically sync with your regular Stern password.

Ack! I forgot my password! What do I do?
Please contact the Stern Helpdesk at helpdesk@stern.nyu.edu. They will reset your password after confirming your privilege to the mysql account.

What programming languages can be used to write database driven applications and connect to MySQL?
You can use C, C++, and Perl and PHP. phpMyadmin is not available.

Where can I find out more about MySQL?
MySQL has a full manual online at: http://www.mysql.com/documentation. There are also several books on MySQL, such as MySQL by Paul DuBois and published by New Riders.