Skip to Main Content
HBS Home
  • About
  • Academic Programs
  • Alumni
  • Faculty & Research
  • Baker Library
  • Giving
  • Harvard Business Review
  • Initiatives
  • News
  • Recruit
  • Map / Directions
Research Computing Services
  • Online Requests
  • FAQ
  • Blog
  • Contact Us
  • About Us
  • Faculty Projects
  • Training
  • Compute Cluster & Data Storage
  • Data Practices
  • Help
  • …→
  • Harvard Business School→
  • Research Computing Services→
  • Compute Cluster and Data Storage
    • Compute Cluster and Data Storage
    • Compute Cluster
    • Data Storage
    • Database Server
    • Other Research Computing Environments
    →
  • Database Server
    • Database Server
    • Configuration Files Recommended for Connecting
    • MySQL Client
    • NaviCat
    • NoMachine
    • ODBC
    • Python
    • R
    • SAS
    • Stata
    • Tableau
    • Terminal
    →
  • MySQL Client→

Database Server

Database Server

  • Configuration Files Recommended for Connecting
  • MySQL Client
  • NaviCat
  • NoMachine
  • ODBC
  • Python
  • R
  • SAS
  • Stata
  • Tableau
  • Terminal

MySQL Client

MySQL Client

  • Compute Cluster
  • Data Storage
  • Database Server
    • Configuration Files Recommended for Connecting
    • MySQL Client
    • NaviCat
    • NoMachine
    • ODBC
    • Python
    • R
    • SAS
    • Stata
    • Tableau
    • Terminal
  • Other Research Computing Environments
4ms

Use the shell program mysql to connect remotely to the MariaDB server. Or use the free MySQL Workbench GUI. Steps involved are:

Command-line: Install the mysql client for your system. Follow the instructions for installing the MySQL server and utilities, but do not turn on or run the MySQL server or server deamon.

  • Mac:
    • download at https://dev.mysql.com/downloads/mysql/, and select Mac OS X.
    • download at https://dev.mysql.com/doc/refman/5.7/en/osx-installation-pkg.html
  • Windows:
    • download at https://dev.mysql.com/downloads/mysql/, and select Microsoft Windows.
    • instructions at https://dev.mysql.com/doc/refman/5.7/en/mysql-installer.html

GUI: This installs only a front-end GUI for use. Download at https://dev.mysql.com/downloads/workbench/ and follow the usual installation steps to install the GUI application.

Both methods: ensure that the certificate ('cert') files given to you by the RCS staff have been downloaded and are placed in an accessible location. For the following examples, we'll place the cert file in a folder called 'mariadb_certs' in our home folder.

Terminal:

Open or start your terminal session. To connect to the MariaDB server, use a command similar to :

mysql -u username -p -h mariadbhost --ssl-ca=/path/to/file/ca-cert.pem

Each of these options does the following:

-u username: use your MariaDB account name here

-p: nothing needed. This indicates that you need to supply a password

-h mariadbhost: substitute the hostname of the MariaDB server given to you by the RCS staff

--ssl-cert: indicates you wish to supply a cert file for encrypting the communication via SSL. Include the appropriate path format for your machine.

Two examples are (but don't use these as they will not work):

Mac: mysql -u jharvard -p -h mariadb.hbs.edu --ssl-ca=/Users/jharvard/mariadb_certs/ca-cert.pem

Windows: mysql -u jharvard -p -h mariadb.hbs.edu --ssl-ca=C:\Users\jharvard\mariadb_certs\ca-cert.pem

ǁ
Campus Map
Research Computing Services (RCS) 
Harvard Business School
Baker Library, B90, 25 Harvard Way
Boston, MA 02163
Phone: 617.495.6100
Email: research@hbs.edu
→Map & Directions
→More Contact Information
→Terms Of Service
  • Make a Gift
  • Site Map
  • Jobs
  • Harvard University
  • Trademarks
  • Policies
  • Accessibility
  • Digital Accessibility
Copyright © President & Fellows of Harvard College