MySQL
MySQL
MySQL
MySQL is a relational database management system that runs as a server providing multi-user access to a number of databases. Various types of databases are offered at NJIT for personal, departmental, research, and other purposes. These databases support a number of APIs, servlet applications, and security protocols.
If you have forgotten or otherwise need to reset your database password(s), click here.
Who may have access to MySQL?
MySQL Password
Supported APIs
JSP and Servlets
Security
Tutorials
Samples
MySQL Utilities
Debugging PHP
Individuals (students, faculty, and staff) can create a MySQL account from https://ist.njit.edu/oracle-mysql-access/. Contact the IST Service Desk (servicedesk.njit.edu) if you encounter any difficulties.Database accounts remain available while the owner attends/works at NJIT. For security purposes, personal (ucid) database passwords will be reset to a random string every August. The owner may obtain a new password at http://mypassword.njit.edu/db.
Other types of databases that may be requested via the IST Service Desk as follows:
- Departmental (dept)
Reserved for departmental uses and may be requested by NJIT faculty or staff only.- Research (rsrch)
Research databases may be requested by an NJIT faculty or staff sponsor on behalf of a student or student group. A research database should be requested when research is expected to containue after the original team graduates from NJIT.- Club (club)
Linked to the club home directory. Requests for club databases must come from the faculty advisor to the club.- Project (proj)
Project databases will no longer be provided. Previously allocated project database will be kept while the owner is at NJIT.
Your initial password will be assigned to you. Click here to check your password.
The following APIs are currently available:
University Computing Systems now runs a public Tomcat server. For more information, please visit the Tomcat information page.
Information on securing your MySQL database can be found on the AFS permissions page.
The following tutorals are available for MySQL training:
Graphical and command line tools for managing your database:
- Point your web browser at:
- Our most currently supported release, phpMyAdmin
- NOTE: Since there are now multiple servers, you will need to select your assigned MySQL server from the "Server Choice" menu of the phpMyAdmin login page.
- NOTE: You will need to select your database from the "Databases" in the left frame after you log in.
- Information and documentation on phpMyAdmin
- If you prefer a command line interface, /usr/local/bin/mysql is available on afsconnect[12].njit.edu
After connecting to afsconnect[12].njit.edu via ssh or telnet type the following command to connect:
mysql -u <mysql username> -p -h <hostname (sql.njit.edu or sql2.njit.edu)> <database name>
You will be prompted for your password. Use the password that was given to you in email confirmation you received after the database was created.
Visit https://ist.njit.edu/password-resets/ to change your MySQL password
- Using a .my.cnf file
MySQL allows you to store connection parameters in an option file. The .my.cnf file, when properly configured, eliminates the need of having specify parameters on the command line.
Here is a sample of a very simple .my.cnf file:
[client]user = your_ucidpassword = your_passwordhost = sql.njit.eduport = 3306
WARNING: Since your home directory is located in AFS at NJIT, it is very important that you understand AFS permissions. For your convenience, a sample ~/.my.cnf file has been created for you and correct AFS permissions have been applied. However, before making any changes to your .my.cnf file, it is important and cannot be stressed enough that you understand AFS permissions.
If you're starting to use MySQL and PHP for the first time it sometimes seems like something is wrong with the servers. In our experience 99% of the time the problem is hiding in your code. Please attempt the following before you complain about the server; you'll be rewarded by solving the problem faster.ARCS cannot help students debug homework assignments, we may only verify that the systems hosting your homework are functioning.
- Make sure your login info is correct. Use this PHP webpage to check your MySQL login.
- Turn on the PHP error reporting function.
- Run your program with command line php to solve browser-related problems.
- You might also take advantage of your instructor's office hours for assistance with debugging your program.
Please report any questions about the above contact the IST Service Desk (servicedesk.njit.edu).