FormaServe MariaDB on IBM i Help

This document shows useful commands for helping with installing and using MariaDB on IBM i

Our eLearning IBM i Training Examples

While you are here, why not visit our training videos, which can be found here

Command	Description
`mysqld_safe --datadir=/QOpenSys/var/lib/mariadb/data`	Start MariaDB Server
`mysqladmin -u root -p shutdown`	Stop MariaDB Server
`yum install mariadb mariadb-server`	Install MariaDB from Yum
`mysqladmin -u root password abc123`	Set root password
`mysql_install_db --user=mysql`	Install MariaDB
`GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'your password';`	Grant Root Authority to everything!
`SBMJOB CMD(QSH CMD('/QOpenSys/pkgs/bin/mysqld_safe --datadir=/QOpenSys/var/lib/mariadb/data')) JOB(STR_MARIA)`	Start Server as a submitted job

Command	Description
`/QOpenSys/etc/mariadb/my.cnf`	MariaDB Configuration
`/QOpenSys/var/lib/mariadb/data/server_name.err`	MariaDB Log
`/QOpenSys/pkgs/bin/`	MariaDB Binaries

FormaServe Systems Ltd - All work - FormaServe

Andy Youens - FormaServe

Nick Youens - FormaServe

Andy Youens - FormaServe Systems Ltd - Twitter @AndyYouens