https://mochiu.net/index.php?action=history&feed=atom&title=%E3%82%A4%E3%83%B3%E3%82%B9%E3%83%88%E3%83%BC%E3%83%AB_-_MariaDB%28Raspberry_Pi%29 2026-09-09T21:44:53Z このウィキのこのページに関する変更履歴 MediaWiki 1.43.9 https://mochiu.net/index.php?title=%E3%82%A4%E3%83%B3%E3%82%B9%E3%83%88%E3%83%BC%E3%83%AB_-_MariaDB(Raspberry_Pi)&diff=1282&oldid=prev 2020-04-26T00:18:46Z

<p>Wiki がページ「<a href="/index.php?title=MariaDB%E3%81%AE%E3%82%A4%E3%83%B3%E3%82%B9%E3%83%88%E3%83%BC%E3%83%AB%E6%96%B9%E6%B3%95(Raspberry_Pi)&amp;action=edit&amp;redlink=1" class="new" title="MariaDBのインストール方法(Raspberry Pi) (存在しないページ)">MariaDBのインストール方法(Raspberry Pi)</a>」を「<a href="/index.php/%E3%82%A4%E3%83%B3%E3%82%B9%E3%83%88%E3%83%BC%E3%83%AB_-_MariaDB(Raspberry_Pi)" title="インストール - MariaDB(Raspberry Pi)">インストール - MariaDB(Raspberry Pi)</a>」に、リダイレクトを残さずに移動しました</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="ja"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← 古い版</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">2020年4月26日 (日) 09:18時点における版</td> </tr><tr><td colspan="4" class="diff-notice" lang="ja"><div class="mw-diff-empty">(相違点なし)</div> </td></tr> <!-- diff cache key mochiu_wiki:diff:1.41:old-535:rev-1282 --> </table>

Wiki https://mochiu.net/index.php?title=%E3%82%A4%E3%83%B3%E3%82%B9%E3%83%88%E3%83%BC%E3%83%AB_-_MariaDB(Raspberry_Pi)&diff=535&oldid=prev 2019-12-10T11:35:34Z

<p><span class="autocomment">設定</span></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="ja"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← 古い版</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">2019年12月10日 (火) 20:35時点における版</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l17">17行目:</td> <td colspan="2" class="diff-lineno">17行目:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  以下、説明を読みながら設定する</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  以下、説明を読みながら設定する</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  Enter current password for root (enter for none):  ←　Enterキーを押下</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  Enter current password for root (enter for none):  ←　Enterキーを押下</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>  Change the root password? [Y/n] y                  <del style="font-weight: bold; text-decoration: none;">←yキーを押下</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>  Change the root password? [Y/n] y                  <ins style="font-weight: bold; text-decoration: none;">←  yキーを押下</ins></div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>  Remove anonymous users? [Y/n] y                    <del style="font-weight: bold; text-decoration: none;">←yキーを押下</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>  Remove anonymous users? [Y/n] y                    <ins style="font-weight: bold; text-decoration: none;">←  yキーを押下</ins></div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>  Disallow root login remotely? [Y/n] y              <del style="font-weight: bold; text-decoration: none;">←yキーを押下</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>  Disallow root login remotely? [Y/n] y              <ins style="font-weight: bold; text-decoration: none;">←  yキーを押下</ins></div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>  Remove test database and access to it? [Y/n] y      <del style="font-weight: bold; text-decoration: none;">←yキーを押下</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>  Remove test database and access to it? [Y/n] y      <ins style="font-weight: bold; text-decoration: none;">←  yキーを押下</ins></div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>  Reload privilege tables now? [Y/n] y                <del style="font-weight: bold; text-decoration: none;">←yキーを押下</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>  Reload privilege tables now? [Y/n] y                <ins style="font-weight: bold; text-decoration: none;">←  yキーを押下</ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  Thanks for using MySQL  </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  Thanks for using MySQL  </div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;br&gt;&lt;br&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;br&gt;&lt;br&gt;</div></td></tr> <!-- diff cache key mochiu_wiki:diff:1.41:old-534:rev-535:php=table --> </table>

Wiki https://mochiu.net/index.php?title=%E3%82%A4%E3%83%B3%E3%82%B9%E3%83%88%E3%83%BC%E3%83%AB_-_MariaDB(Raspberry_Pi)&diff=534&oldid=prev 2019-12-10T11:35:11Z

<p>ページの作成:「== 概要 == &lt;br&gt;&lt;br&gt; == MariaDBのインストール == 以下のコマンドを入力して実行する。&lt;br&gt; sudo apt-get install mariadb-client mariadb-server &lt;br&gt;…」</p> <p><b>新規ページ</b></p><div>== 概要 ==<br /> &lt;br&gt;&lt;br&gt;<br /> <br /> == MariaDBのインストール ==<br /> 以下のコマンドを入力して実行する。&lt;br&gt;<br /> sudo apt-get install mariadb-client mariadb-server<br /> &lt;br&gt;<br /> インストールしたMariaDB Serverのバージョンを確認する。<br /> dpkg -l | grep -i mariadb <br /> &lt;br&gt;&lt;br&gt;<br /> <br /> == 設定 ==<br /> MariaDBの設定を行うため、mysql_secure_installationを実行して設定を行う。&lt;br&gt;<br /> mysql_secure_installationを実行する。&lt;br&gt;<br /> sudo mysql_secure_installation<br /> <br /> 以下、説明を読みながら設定する<br /> Enter current password for root (enter for none): ←　Enterキーを押下<br /> Change the root password? [Y/n] y ←yキーを押下<br /> Remove anonymous users? [Y/n] y ←yキーを押下<br /> Disallow root login remotely? [Y/n] y ←yキーを押下<br /> Remove test database and access to it? [Y/n] y ←yキーを押下<br /> Reload privilege tables now? [Y/n] y ←yキーを押下<br /> Thanks for using MySQL <br /> &lt;br&gt;&lt;br&gt;<br /> <br /> __FORCETOC__<br /> [[カテゴリ:Raspberry_Pi]]</div>

Wiki