Raspbian StretchにMariaDBのソースを表示

=== インストール ===
<syntaxhighlight lang="bash">
$ sudo apt install -y mariadb-server
</syntaxhighlight>

=== 初期設定 ===
<syntaxhighlight lang="bash">
$ sudo vim /etc/mysql/mariadb.conf.d/50-server.cnf
</syntaxhighlight>
以下のように修正
<pre>
111行目
character-set-server = utf8

112行目
collation-server=utf8_general_ci
</pre>

=== 再起動 ===
<syntaxhighlight lang="bash">
$ sudo systemctl restart mariadb
</syntaxhighlight>

=== セキュリティ設定 ===
<syntaxhighlight lang="bash">
$ sudo mysql_secure_installation
</syntaxhighlight>
<pre>
...
Enter current password for root (enter for none): → <PASSWORD> or Enter
...
Change the root password? [Y/n] → Y
...
Remove anonymous users? [Y/n] → Y
...
Disallow root login remotely? [Y/n] → Y
...
Remove test database and access to it? [Y/n] → Y
...
Reload privilege tables now? [Y/n] → Y
...
</pre>

=== 動作確認 ===
<syntaxhighlight lang="bash">
$ sudo mysql -u root -p<PASSWORD>
</syntaxhighlight>

=== アンインストール ===
<syntaxhighlight lang="bash">
$ sudo apt purge -y mariadb*
</syntaxhighlight>


[[Category:MariaDB]]
[[Category:RaspBerryPi]]
[[Category:Raspbian]]
[[Category:Stretch]]