We are running MariaDB version 5.5.52. MariaDB is an open source fork of MySQL. You may access the server by using the mysql client. The database server’s host address is rhrcssql01.hbs.edu and is accessible on port 3306.
Using the mysql client while on the Grid
To start your MariaDB session, log onto the Grid (researchgrid.hbs.edu) with your HBS intranet username and password.You may log in either with a terminal session (e.g. using Terminal on Mac or Putty on Windows) or via NoMachine. If you have logged in with NoMachine, then you will need to start a terminal session within NoMachine. To do so right-click on the desktop and select Open in Terminal
Within your terminal session, the syntax for running the mysql client is:
mysql -h HOSTNAME -u USERNAME -p
The hostname is rhrcssql01.hbs.edu, therefore we would use:
mysql -h rhrcssql01.hbs.edu -u USERNAME –p
Once you enter the above, you will next be prompted to enter your MariaDB password, as shown below:
Once logged in, you should open your working database with the use command. As an example, the user pjonak can open their personal database via
Changing Your Password
We will be upgrading to MariaDB v10 this summer. Until the upgrade has completed, we ask users not to change their passwords. This policy has been put in place for security considerations. We thank you in advance for your cooperation.