管理人の覚書 <
MariaDB
をテンプレートにして作成>
[
トップ
] [
新規
|
一覧
|
単語検索
|
最終更新
|
ヘルプ
]
開始行:
#norelated
#contents
----
**インストール [#ce90833c]
# yum -y install mariadb-server mariadb-devel
#ref(./yum-mariadb.txt)
**サービス起動 [#c9c63d82]
# systemctl start mariadb.service
**サービス自動起動 [#u719092c]
# systemctl enable mariadb.service
----
**設定ファイル [#a64236c1]
''/etc/my.cnf''
[mysqld]
&br;datadir=/var/lib/mysql
&br;socket=/var/lib/mysql/mysql.sock
&br;# Disabling symbolic-links is recommended to prevent ...
&br;symbolic-links=0
&br;# Settings user and group are ignored when systemd is...
&br;# If you need to run mysqld under a different user or...
&br;# customize your systemd unit file for mariadb accord...
&br;# instructions in http://fedoraproject.org/wiki/Systemd
&br;
&br;&color(red){character-set-server=utf8};
&br;
&br;[mysqld_safe]
&br;log-error=/var/log/mariadb/mariadb.log
&br;pid-file=/var/run/mariadb/mariadb.pid
&br;
&br;#
&br;# include all files from the config directory
&br;#
&br;!includedir /etc/my.cnf.d
&br;
&br;&color(red){[mysql]};
&br;&color(red){default-character-set=utf8};
----
**rootパスワード設定 [#wcdccb6f]
# /usr/bin/mysqladmin -u root password 'PASSWORD'
----
**DB接続 [#s9498c86]
# mysql -uroot -p
**datebase作成 [#ge853e48]
~> create database ''DATABASE'' default character set utf8;
**権限設定 [#v5c90806]
~> grant all on ''DATABASE''.* to ''USERNAME''@localhost ...
終了行:
#norelated
#contents
----
**インストール [#ce90833c]
# yum -y install mariadb-server mariadb-devel
#ref(./yum-mariadb.txt)
**サービス起動 [#c9c63d82]
# systemctl start mariadb.service
**サービス自動起動 [#u719092c]
# systemctl enable mariadb.service
----
**設定ファイル [#a64236c1]
''/etc/my.cnf''
[mysqld]
&br;datadir=/var/lib/mysql
&br;socket=/var/lib/mysql/mysql.sock
&br;# Disabling symbolic-links is recommended to prevent ...
&br;symbolic-links=0
&br;# Settings user and group are ignored when systemd is...
&br;# If you need to run mysqld under a different user or...
&br;# customize your systemd unit file for mariadb accord...
&br;# instructions in http://fedoraproject.org/wiki/Systemd
&br;
&br;&color(red){character-set-server=utf8};
&br;
&br;[mysqld_safe]
&br;log-error=/var/log/mariadb/mariadb.log
&br;pid-file=/var/run/mariadb/mariadb.pid
&br;
&br;#
&br;# include all files from the config directory
&br;#
&br;!includedir /etc/my.cnf.d
&br;
&br;&color(red){[mysql]};
&br;&color(red){default-character-set=utf8};
----
**rootパスワード設定 [#wcdccb6f]
# /usr/bin/mysqladmin -u root password 'PASSWORD'
----
**DB接続 [#s9498c86]
# mysql -uroot -p
**datebase作成 [#ge853e48]
~> create database ''DATABASE'' default character set utf8;
**権限設定 [#v5c90806]
~> grant all on ''DATABASE''.* to ''USERNAME''@localhost ...
ページ名:
