NERSCPowering Scientific Discovery Since 1974

MySQL

Description and Overview

MySQL is a very popular open-source relational database. It is widely used and NERSC provides a set of database nodes for users that wish to set up a MySQL database.

Requesting a MySQL Database

Users can request a MySQL database for their project using this form.

How to Use MySQL 

The mysql command line client is available at NERSC on Edison and Cori, and can be used to directly connect to a MySQL database via the command line. 

On a NERSC system, type the following commands to use the mysql command line client:

% mysql yourdb -u dbuser -h nerscdb04.nersc.gov -p

Replace yourdb and dbuser with the name of the database and user provided to you by NERSC request via the form above.

Documentation

Extensive on-line documentation is available. For questions about MySQL at NERSC please contact consult@nersc.gov.

Availability

mysql is available on login to Edison and Cori, you do not need to load a module.

There is also a python mysql module.