MySQL Client

Use the shell program mysql to connect remotely to the MariaDB server. Our 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.

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 place in an accessible location. For our example purposes, we'll place the cert 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