MariaDB

[Update: May 23, 2019]

The following is information dependent RDBMS when “MariaDB” has been selected.

Overview

The following available functions are dependent on RDBMS.

Administration interface CLI and WEB UI (phpMyAdmin)
Connection port number (CLI) Port number 3306 (default value). It is possible to change it to an arbitrary port number.
Connection port number (WEB UI) Port number 443

In addition to the MariaDB standard installation extension, we have introduced the fol-lowing extensions to enable the "TokuDB" database engine appropriate for large amounts of data such as big data analysis. You can select and use the TokuDB engine as needed.

  • TokuDB
  • TokuDB_trx
  • TokuDB_lock_waits
  • TokuDB_locks
  • TokuDB_file_map
  • TokuDB_fractal_tree_info
  • TokuDB_fractal_tree_block_map
  • TokuDB_background_job_status

Connection to a database appliance using the mysql command

MySQL Command is used when connecting from the system you are using to the data-base appliance where MariaDB is active.

  • To use the MySQL command line tool, it is necessary to conduct installation according to the pre-connection environment.
mysql -h [IPアドレス] -P [設定したポート番号*] -u [ユーザ名] -D [接続するデータベース名*] -p

*Can be omitted

Connection example

The following is an example of connection to a database appliance (MariaDB) with 192.168.1.100 via the mysql command. Here, the database port number (3306) is the default, and sakura is registered as the user

Connection as a user

$ mysql -h 192.168.1.100 -P 3306 -u sakura -D sakura -p
Enter password:[パスワードを入力してください]
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 60
Server version: 10.1.17-MariaDB MariaDB Server

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type ’help;’ or ’\hfor help. Type ’\c’ to clear the current input statement.

MariaDB [sakura]

Reference

  • For information on MariaDB, see https://mariadb.com/ja.
  • For information on phpMyAdmin, see https://www.phpmyadmin.net/.
  • Please note that we will not take responsibility for information on external websites.
  • The amount of log information output to the Log screen is determined by MariaDB de-fault settings (log_warnings=2) which cannot be changed. Unless a serious error has occurred most likely nothing will appear on the screen.
  • Equipped with Oracle Database compatibility (MariaDB 10.3 and later).
  • Supports the same data type and stored procedure for PL/SQL (MariaDB 10.3 and lat-er).