MariaDB Server Usage Instructions

USAGE INSTRUCTIONS: MariaDB Server

Logging on

The unix server named rhrcssql01.hbs.edu is a dedicated server for MariaDB. Version 5.5.52 has been installed. MariaDB 5.5 is a fork of MySQL.

To start your MariaDB session, log onto researchgrid.hbs.edu using your intranet username and password. At the system  prompt, log onto the MariaDB server with the following command:

$ mysql -h rhrcssql01.hbs.edu -u username  -p

<you will be prompted for your MariaDB password>

Note:  the switches –h, u and -p are for the database host, user and password, respectively. Macs must log on to the VPN before logging on to the MariaDB server (either on or off campus).

Changing your password

If you choose to change your MariaDB password, please use a secure password selection strategy.

set password = password("yournewpassword");

Import and export of data to or from a database

To select data from a database for export to a text file, you should designate the export directory for the MySQL server to write the files:

/export/mdb_external/export/

If you have your own database, you may import data into your database from the following directory:

/export/mdb_external/import/