「MariaDB 5.5をインストールする」の版間の差分

提供: FreeBSD入門
移動: 案内検索
(ページの作成:「MariaDB 5.5は、MySQL 5.5をベースに独自機能を追加したバージョンです。 '''読み方''' ;MariaDB 5.5:まりあ でぃーびー ごー...」)
 
 
行40: 行40:
 
== コントロール ==
 
== コントロール ==
 
{{rc.d|mysql-server}}
 
{{rc.d|mysql-server}}
 +
== ファイル ==
 +
=== mariadb55-server ===
 +
<syntaxhighlight lang="bash">
 +
        /usr/local/bin/aria_chk
 +
        /usr/local/bin/aria_dump_log
 +
        /usr/local/bin/aria_ftdump
 +
        /usr/local/bin/aria_pack
 +
        /usr/local/bin/aria_read_log
 +
        /usr/local/bin/innochecksum
 +
        /usr/local/bin/my_print_defaults
 +
        /usr/local/bin/myisam_ftdump
 +
        /usr/local/bin/myisamchk
 +
        /usr/local/bin/myisamlog
 +
        /usr/local/bin/myisampack
 +
        /usr/local/bin/mysql_convert_table_format
 +
        /usr/local/bin/mysql_fix_extensions
 +
        /usr/local/bin/mysql_install_db
 +
        /usr/local/bin/mysql_plugin
 +
        /usr/local/bin/mysql_secure_installation
 +
        /usr/local/bin/mysql_setpermission
 +
        /usr/local/bin/mysql_tzinfo_to_sql
 +
        /usr/local/bin/mysql_upgrade
 +
        /usr/local/bin/mysql_zap
 +
        /usr/local/bin/mysqlbug
 +
        /usr/local/bin/mysqld_multi
 +
        /usr/local/bin/mysqld_safe
 +
        /usr/local/bin/mysqldumpslow
 +
        /usr/local/bin/mysqlhotcopy
 +
        /usr/local/bin/mysqltest
 +
        /usr/local/bin/perror
 +
        /usr/local/bin/replace
 +
        /usr/local/bin/resolve_stack_dump
 +
        /usr/local/bin/resolveip
 +
        /usr/local/etc/rc.d/mysql-server
 +
</syntaxhighlight>
 +
=== mariadb55-client ===
 +
<syntaxhighlight lang="bash">
 +
mariadb55-client-5.5.35:
 +
        /usr/local/bin/msql2mysql
 +
        /usr/local/bin/mysql
 +
        /usr/local/bin/mysql_config
 +
        /usr/local/bin/mysql_find_rows
 +
        /usr/local/bin/mysql_waitpid
 +
        /usr/local/bin/mysqlaccess
 +
        /usr/local/bin/mysqladmin
 +
        /usr/local/bin/mysqlbinlog
 +
        /usr/local/bin/mysqlcheck
 +
        /usr/local/bin/mysqldump
 +
        /usr/local/bin/mysqlimport
 +
        /usr/local/bin/mysqlshow
 +
        /usr/local/bin/mysqlslap
 +
</syntaxhighlight>
 
== 設定 ==
 
== 設定 ==
 
<syntaxhighlight lang="bash">
 
<syntaxhighlight lang="bash">
 +
 
</syntaxhighlight>
 
</syntaxhighlight>
  

2014年3月8日 (土) 15:49時点における最新版

MariaDB 5.5は、MySQL 5.5をベースに独自機能を追加したバージョンです。

読み方

MariaDB 5.5
まりあ でぃーびー ごーてんご

概要

インストール

pkgコマンドでインストールする場合

sudo pkg install mariadb55-server
$ sudo pkg install mariadb55-server
Updating repository catalogue
The following 2 packages will be installed:
 
        Installing mariadb55-client: 5.5.35
        Installing mariadb55-server: 5.5.35
 
The installation will require 146 MB more space
 
0 B to be downloaded
 
Proceed with installing packages [y/N]: y
Checking integrity... done
[1/2] Installing mariadb55-client-5.5.35... done
[2/2] Installing mariadb55-server-5.5.35...===> Creating users and/or groups.
Creating group 'mysql' with gid '88'.
Creating user 'mysql' with uid '88'.
 done
************************************************************************
 
Remember to run mysql_upgrade (with the optional --datadir=<dbdir> flag)
the first time you start the MySQL server after an upgrade from an
earlier version.
 
************************************************************************

コントロール

起動

sudo /usr/local/etc/rc.d/mysql-server start

停止

sudo /usr/local/etc/rc.d/mysql-server stop

再起動

sudo /usr/local/etc/rc.d/mysql-server restart

ステータス

sudo /usr/local/etc/rc.d/mysql-server status

コマンドの終了を待つ

sudo /usr/local/etc/rc.d/mysql-server poll

サービスが有効か確認する

サービスが有効な場合は、0、そうでなければ、1を返します。コマンドは、何も表示しません。

sudo /usr/local/etc/rc.d/mysql-server enabled

rc.confの設定を表示します

サービスの制御に使われるrc.conf変数を表示します。

sudo /usr/local/etc/rc.d/mysql-server rcvar

ファイル

mariadb55-server

        /usr/local/bin/aria_chk
        /usr/local/bin/aria_dump_log
        /usr/local/bin/aria_ftdump
        /usr/local/bin/aria_pack
        /usr/local/bin/aria_read_log
        /usr/local/bin/innochecksum
        /usr/local/bin/my_print_defaults
        /usr/local/bin/myisam_ftdump
        /usr/local/bin/myisamchk
        /usr/local/bin/myisamlog
        /usr/local/bin/myisampack
        /usr/local/bin/mysql_convert_table_format
        /usr/local/bin/mysql_fix_extensions
        /usr/local/bin/mysql_install_db
        /usr/local/bin/mysql_plugin
        /usr/local/bin/mysql_secure_installation
        /usr/local/bin/mysql_setpermission
        /usr/local/bin/mysql_tzinfo_to_sql
        /usr/local/bin/mysql_upgrade
        /usr/local/bin/mysql_zap
        /usr/local/bin/mysqlbug
        /usr/local/bin/mysqld_multi
        /usr/local/bin/mysqld_safe
        /usr/local/bin/mysqldumpslow
        /usr/local/bin/mysqlhotcopy
        /usr/local/bin/mysqltest
        /usr/local/bin/perror
        /usr/local/bin/replace
        /usr/local/bin/resolve_stack_dump
        /usr/local/bin/resolveip
        /usr/local/etc/rc.d/mysql-server

mariadb55-client

mariadb55-client-5.5.35:
        /usr/local/bin/msql2mysql
        /usr/local/bin/mysql
        /usr/local/bin/mysql_config
        /usr/local/bin/mysql_find_rows
        /usr/local/bin/mysql_waitpid
        /usr/local/bin/mysqlaccess
        /usr/local/bin/mysqladmin
        /usr/local/bin/mysqlbinlog
        /usr/local/bin/mysqlcheck
        /usr/local/bin/mysqldump
        /usr/local/bin/mysqlimport
        /usr/local/bin/mysqlshow
        /usr/local/bin/mysqlslap

設定

 

使い方

 

注意事項

mysql55-clientが入っている環境だと以下のエラーが出ました。

Proceed with installing packages [y/N]: y
Checking integrity...pkg: WARNING: locally installed mysql55-client-5.5.36
conflicts on /usr/local/bin/msql2mysql with:
        - mariadb55-client-5.5.35
 
pkg: WARNING: locally installed mysql55-client-5.5.36 conflicts on
/usr/local/bin/mysql with:
        - mariadb55-client-5.5.35
 
pkg: WARNING: locally installed mysql55-client-5.5.36 conflicts on
/usr/local/bin/mysql_config with:
        - mariadb55-client-5.5.35

mysql55-clientを削除します。

pkg delete mysql55-client

関連項目

  • MariaDB
  • MariaDB 5.5をインストールする