MariaDB make new user?

@quicksalad asked the same question at Where to create DB for Xenforo | Centmin Mod Community

For creating MySQL databases and MySQL username and password you have a few options all outlined via the following linked information (including mysqladmin_shell.sh addon below).

• Getting Started Guide Step 11
• Official phpmyadmin docs Welcome to phpMyAdmin’s documentation! — phpMyAdmin 4.5.0-dev documentation and user management User management — phpMyAdmin 4.5.0-dev documentation

Note: default /etc/my.cnf sets default storage engine to MyISAM (default-storage-engine = MyISAM). If you want to use InnoDB storage engine tables, set in /etc/my.cnf, default-storage-engine = InnoDB and restart MySQL server.

Currently, Centmin Mod doesn't bundle any tools to manage MariaDB MySQL by default. You have to do it:

1. Via SSH telnet command line see MySQL documentation at MySQL :: MySQL 5.5 Reference Manual :: 3 Tutorial, MySQL Access Privilege System andMySQL User Account Management (example shown in Wordpress + WP-FFPC plugin + ngx_pagespeed guide and in IP.Board setup guide) OR
2. Install phpmyadmin yourself (see more info further below) OR
3. Install tools such as HeidiSQL on your own pc to connect to your server ?

Centmin Mod Addons - phpmyadmin.sh & mysqladmin_shell.sh

• If you need to create MySQL databases, there's a custom Centmin Mod Addon for installing phpmyadmin
• There's also another Addon I wrote called mysqladmin_shell.sh which can be run from SSH command line instead.

Both Addons are in a beta build state, so there's no 100% guarantee it will always work. Your feedback on the forums and testing will help me improve the Addons