3.SetupDatabaseServer.md

SynchWeb Development Environment for Workstations

3. Setup Database Server

1. Load MariaDB Server module

   $ module load mariadb-server
   

2. Initialise MariaDB Data Directory

   $ $MARIADB_HOME/scripts/mysql_install_db --defaults-file=/scratch/SynchWebDevEnvWS/server/mariadb/my.cnf --basedir=$MARIADB_HOME
   

   mysql_install_db
   Initialises MariaDB data directory and creates default system tables.

   --defaults-file
   Specifies a custom option file.
   MariaDB disregards default option files e.g. /etc/my.cnf, ~/.my.cnf, etc.

   --basedir
   Specifies path to the MariaDB installation directory.

3. Start MariaDB Server

   $ mysqld --defaults-file=/scratch/SynchWebDevEnvWS/server/mariadb/my.cnf &
   

   Server starts in background, press return key to continue.

4. Secure MariaDB Server

   $ mysql_secure_installation --defaults-file=/scratch/SynchWebDevEnvWS/server/mariadb/my.cnf --basedir=$MARIADB_HOME
   

   mysql_secure_installation
   Improves security of default MariaDB installation.

   Follow instructions to implement security recommendations:

   Set root password? [Y/n] Y
   Remove anonymous users? [Y/n] Y
   Disallow root login remotely? [Y/n] N
   Remove test database and access to it? [Y/n] Y
   Reload privilege tables now? [Y/n] Y
   

5. Next : Setup ISPyB