{"id":1035,"date":"2024-09-10T08:53:35","date_gmt":"2024-09-09T23:53:35","guid":{"rendered":"https:\/\/www.aqua-informatics.jp\/?p=1035"},"modified":"2024-09-10T08:53:36","modified_gmt":"2024-09-09T23:53:36","slug":"phpmyadmin%e3%82%92%e3%82%a4%e3%83%b3%e3%82%b9%e3%83%88%e3%83%bc%e3%83%ab","status":"publish","type":"post","link":"https:\/\/www.aqua-informatics.jp\/?p=1035","title":{"rendered":"phpmyadmin\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb"},"content":{"rendered":"\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.aqua-informatics.jp\/?p=1035\/#%E3%81%AF%E3%81%98%E3%82%81%E3%81%AB\" >\u306f\u3058\u3081\u306b<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.aqua-informatics.jp\/?p=1035\/#%E7%8A%B6%E6%B3%81%E7%A2%BA%E8%AA%8D\" >\u72b6\u6cc1\u78ba\u8a8d<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.aqua-informatics.jp\/?p=1035\/#%E3%82%A4%E3%83%B3%E3%82%B9%E3%83%88%E3%83%BC%E3%83%AB\" >\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.aqua-informatics.jp\/?p=1035\/#mariadb%E3%81%AE%E8%A8%AD%E5%AE%9A\" >mariadb\u306e\u8a2d\u5b9a<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E3%81%AF%E3%81%98%E3%82%81%E3%81%AB\"><\/span>\u306f\u3058\u3081\u306b<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u6280\u9069\u306e\u3042\u308bRaspberry Pi 5\u3068Nvme base\u3092\u5165\u624b\u3057\u3066\u3044\u305f\u304c\u3001M.2\u898f\u683c\u306eSSD\u306e\u5165\u624b\u3092\u624b\u914d\u3057\u3066\u3044\u306a\u304b\u3063\u305f\u306e\u3067\u3001\u653e\u7f6e\u3057\u3066\u3044\u305f\u3002Amazon\u3067\u4e00\u756a\u5b89\u304b\u3063\u305f\u30b7\u30ea\u30b3\u30f3\u30d1\u30ef\u30fc\u306e128GB\u306eM.2\u3092\u5165\u624b\u3057\u305f\u306e\u3067\u3001\u7a3c\u50cd\u3055\u305b\u305f\u3002\u30bf\u30a4\u30c8\u30eb\u306b\u3042\u308b\u3088\u3046\u306bphpmyadmin\u3092\u7a3c\u50cd\u3055\u305b\u308b\u624b\u9806\u304c\u30e1\u30e2\u306b\u306a\u304b\u3063\u305f\u306e\u3067\u3053\u3053\u306b\u6b8b\u3059\u3053\u3068\u306b\u3057\u305f\u3002<\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:50%\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"289\" src=\"https:\/\/www.aqua-informatics.jp\/wp-content\/uploads\/2024\/03\/image-1024x289.png\" alt=\"\" class=\"wp-image-1038\" srcset=\"https:\/\/www.aqua-informatics.jp\/wp-content\/uploads\/2024\/03\/image-1024x289.png 1024w, https:\/\/www.aqua-informatics.jp\/wp-content\/uploads\/2024\/03\/image-300x85.png 300w, https:\/\/www.aqua-informatics.jp\/wp-content\/uploads\/2024\/03\/image-768x217.png 768w, https:\/\/www.aqua-informatics.jp\/wp-content\/uploads\/2024\/03\/image.png 1355w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:50%\"><\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%8A%B6%E6%B3%81%E7%A2%BA%E8%AA%8D\"><\/span>\u72b6\u6cc1\u78ba\u8a8d<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Raspberry Pi 5B\u306e.bash_history\u306b\u306fmariadb\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u5f62\u8de1\u306f\u306a\u3044\u3082\u306e\u306e\u3001\u65e2\u306b\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u306f\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3044\u308b\u306e\u306d\uff1f<br>\u30b5\u30fc\u30d0\u30fc\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u8a18\u9332\u304c\u3069\u3053\u306b\u3082\u306a\u3044\u306a\u2026<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>10:19 rpi@raspberrypi5b-alpha:~\n$dpkg -l | grep maria\nii  libmariadb3:arm64     1:10.11.6-0+deb12u1     arm64        MariaDB database client library\nii  mariadb-common        1:10.11.6-0+deb12u1     all          MariaDB common configuration files\n<\/code><\/pre>\n\n\n\n<p>Raspberry Pi 4B gamma\u306e.bash_history\u306e\u5185\u5bb9\u3002<br>\u5fc5\u8981\u306a\u3082\u306e\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u8a18\u9332\u304c\u307b\u307c\u6b8b\u3063\u3066\u308b\u304c\u3001\u8a2d\u5b9a\u306e\u5185\u5bb9\u304c\u308f\u304b\u3089\u3093\u306a\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo apt update\nsudo apt install apache2\nsudo apt install php php-dev php-fpm php-gd\nsudo apt install libapache2-mod-php7.4\na2enmod proxy_fcgi setenvif\na2enconf php7.4-fpm\nsudo systemctl restart apache2\nsudo apt install mariadb-server mariadb-client\nsudo apt install phpmyadmin\nvi \/etc\/phpmyadmin\/apache.conf\nsudo vi \/etc\/phpmyadmin\/apa\nsudo systemctl restart apache2\nsudo systemctl status apache2.service\nsudo vi \/etc\/phpmyadmin\/apache.conf\nsudo vi \/etc\/apache2\/apache2.conf\nsudo systemctl restart apache2\nsudo systemctl status apache2.service<\/code><\/pre>\n\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E3%82%A4%E3%83%B3%E3%82%B9%E3%83%88%E3%83%BC%E3%83%AB\"><\/span>\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u30a2\u30d1\u30c3\u30c1\u3068PHP\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u53ca\u3073\u8a2d\u5b9a\u3092\u3057\u3066\u307f\u305f\u3001\u4e0a\u8a18\u306esudo\u3057\u3066\u3044\u306a\u304b\u3063\u305f\u3051\u3069\u3001\u826f\u304b\u3063\u305f\u3093\u304b\u306a\uff1fphp\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306f\u5909\u3063\u3066\u3044\u308b\u306e\u3067\u3001a2enconf\u306e\u5f15\u6570\u306f\u5909\u3048\u306a\u3044\u3068\u3060\u3081\u3060\u308d\u3046\u306a\u3002\u3053\u308c\u3001\u3069\u3053\u306b\u3042\u308b\u3093\u3060\u308d\u3046(dpkg -l | grep php \u3067\u78ba\u8a8d\u3057\u305f\u3089php8.2-fpm\u304c\u3042\u3063\u305f)\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>10:35 rpi@raspberrypi5b-alpha:~\n$sudo a2enmod proxy_fcgi setenvif\nConsidering dependency proxy for proxy_fcgi:\nEnabling module proxy.\nEnabling module proxy_fcgi.\nModule setenvif already enabled\nTo activate the new configuration, you need to run:\n  systemctl restart apache2\n\n14:07 rpi@raspberrypi5b-alpha:\/var\/www\/html\n$sudo a2enconf php8.2-fpm\nEnabling conf php8.2-fpm.\nTo activate the new configuration, you need to run:\n  systemctl reload apache2\n14:09 rpi@raspberrypi5b-alpha:\/var\/www\/html\n$sudo systemctl restart apache2\n<\/code><\/pre>\n\n\n\n<div style=\"height:29px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\/var\/www\/html\/info.php \u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3001\u5185\u5bb9\u306f\u6b21\u306e\u901a\u308a\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;?php                                                                                                                               \n phpinfo();\n?&gt;<\/code><\/pre>\n\n\n\n<p>Web\u30d6\u30e9\u30a6\u30b6\u306b\u30a2\u30c9\u30ec\u30b9\u3092\u5165\u529b\u3057\u3066\u78ba\u8a8d\u3002rasberrypi5b-alpha.local\/info.php<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"331\" src=\"https:\/\/www.aqua-informatics.jp\/wp-content\/uploads\/2024\/03\/Screenshot-from-2024-03-25-14-16-56-1024x331.png\" alt=\"\" class=\"wp-image-1050\" srcset=\"https:\/\/www.aqua-informatics.jp\/wp-content\/uploads\/2024\/03\/Screenshot-from-2024-03-25-14-16-56-1024x331.png 1024w, https:\/\/www.aqua-informatics.jp\/wp-content\/uploads\/2024\/03\/Screenshot-from-2024-03-25-14-16-56-300x97.png 300w, https:\/\/www.aqua-informatics.jp\/wp-content\/uploads\/2024\/03\/Screenshot-from-2024-03-25-14-16-56-768x248.png 768w, https:\/\/www.aqua-informatics.jp\/wp-content\/uploads\/2024\/03\/Screenshot-from-2024-03-25-14-16-56.png 1430w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:36px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u6b21\u3044\u3067\u3001mariadb\u3068phpmyadmin\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>14:11 rpi@raspberrypi5b-alpha:\/var\/www\/html\n$sudo apt install mariadb-server mariadb-client phpmyadmin<\/code><\/pre>\n\n\n\n<div style=\"height:32px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\/etc\/phpmyadmin\/apache.conf \u3092\u7de8\u96c6\u3057\u3066\u3044\u308b\u3088\u3046\u3060\u304c\u3001\u7279\u306b\u5909\u66f4\u3059\u308b\u3068\u3053\u308d\u306f\u306a\u3055\u305d\u3046\u3060\u3002\u5de6\u304cRaspberry Pi 4B gamma\u3067\u53f3\u304cRaspberry Pi 5 alpha \u306e\u5185\u5bb9\u3002php8\u306e\u5185\u5bb9\u304c\u5897\u3048\u3066\u3044\u308b\u306d\u3002<\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<pre class=\"wp-block-code\"><code># phpMyAdmin default Apache configuration                                                                                           \n\nAlias \/phpmyadmin \/usr\/share\/phpmyadmin\n\n&lt;Directory \/usr\/share\/phpmyadmin&gt;\n    Options SymLinksIfOwnerMatch\n    DirectoryIndex index.php\n\n    # limit libapache2-mod-php to files and directories necessary by pma\n    &lt;IfModule mod_php7.c&gt;\n        php_admin_value upload_tmp_dir \/var\/lib\/phpmyadmin\/tmp\n        php_admin_value open_basedir \/usr\/share\/phpmyadmin\/:\/usr\/share\/doc\/phpmyadmin\/:\/etc\/phpmyadmin\/:\/var\/lib\/phpmyadmin\/:\/usr\/sh\n    &lt;\/IfModule&gt;\n\n&lt;\/Directory&gt;\n\n# Disallow web access to directories that don't need it\n&lt;Directory \/usr\/share\/phpmyadmin\/templates&gt;\n    Require all denied\n&lt;\/Directory&gt;\n&lt;Directory \/usr\/share\/phpmyadmin\/libraries&gt;\n    Require all denied\n&lt;\/Directory&gt;\n<\/code><\/pre>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<pre class=\"wp-block-code\"><code># phpMyAdmin default Apache configuration\n\nAlias \/phpmyadmin \/usr\/share\/phpmyadmin\n\n&lt;Directory \/usr\/share\/phpmyadmin&gt;\n    Options SymLinksIfOwnerMatch\n    DirectoryIndex index.php\n\n    # limit libapache2-mod-php to files and directories necessary by pma\n    &lt;IfModule mod_php7.c&gt;\n        php_admin_value upload_tmp_dir \/var\/lib\/phpmyadmin\/tmp\n        php_admin_value open_basedir \/usr\/share\/phpmyadmin\/:\/usr\/share\/doc\/phpmyadmin\/:\/etc\/phpmyadmin\/:\/var\/lib\/phpmyadmin\/:\/usr\/sh\n    &lt;\/IfModule&gt;\n\n    # PHP 8+\n    &lt;IfModule mod_php.c&gt;\n        php_admin_value upload_tmp_dir \/var\/lib\/phpmyadmin\/tmp\n        php_admin_value open_basedir \/usr\/share\/phpmyadmin\/:\/usr\/share\/doc\/phpmyadmin\/:\/etc\/phpmyadmin\/:\/var\/lib\/phpmyadmin\/:\/usr\/sh\n    &lt;\/IfModule&gt;\n\n&lt;\/Directory&gt;\n\n# Disallow web access to directories that don't need it\n&lt;Directory \/usr\/share\/phpmyadmin\/templates&gt;\n    Require all denied\n&lt;\/Directory&gt;\n&lt;Directory \/usr\/share\/phpmyadmin\/libraries&gt;\n    Require all denied\n&lt;\/Directory&gt;\n<\/code><\/pre>\n<\/div>\n<\/div>\n\n\n\n<p>\u30a2\u30d1\u30c3\u30c1\u3092\u30ea\u30b9\u30bf\u30fc\u30c8\u3001\u30b9\u30c6\u30fc\u30bf\u30b9\u3092\u78ba\u8a8d<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>14:53 rpi@raspberrypi5b-alpha:~\n$sudo systemctl restart apache2\n14:53 rpi@raspberrypi5b-alpha:~\n$sudo systemctl status apache2.service\n\u25cf apache2.service - The Apache HTTP Server\n     Loaded: loaded (\/lib\/systemd\/system\/apache2.service; enabled; preset: enabled)\n     Active: active (running) since Mon 2024-03-25 14:53:34 JST; 20s ago\n       Docs: https:\/\/httpd.apache.org\/docs\/2.4\/\n    Process: 57326 ExecStart=\/usr\/sbin\/apachectl start (code=exited, status=0\/SUCCESS)\n   Main PID: 57332 (apache2)\n      Tasks: 6 (limit: 9250)\n        CPU: 93ms\n     CGroup: \/system.slice\/apache2.service\n             \u251c\u250057332 \/usr\/sbin\/apache2 -k start\n             \u251c\u250057365 \/usr\/sbin\/apache2 -k start\n             \u251c\u250057366 \/usr\/sbin\/apache2 -k start\n             \u251c\u250057368 \/usr\/sbin\/apache2 -k start\n             \u251c\u250057372 \/usr\/sbin\/apache2 -k start\n             \u2514\u250057375 \/usr\/sbin\/apache2 -k start\n\nMar 25 14:53:33 raspberrypi5b-alpha systemd&#091;1]: Starting apache2.service - The Apache HTTP Server...\nMar 25 14:53:34 raspberrypi5b-alpha apachectl&#091;57330]: AH00558: apache2: Could not reliably determine the server's fully qualified d&gt;\nMar 25 14:53:34 raspberrypi<\/code><\/pre>\n\n\n\n<div style=\"height:42px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u30d1\u30b9\u30ef\u30fc\u30c9\u304c\u308f\u304b\u3089\u306a\u3044\u2026<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"582\" height=\"758\" src=\"https:\/\/www.aqua-informatics.jp\/wp-content\/uploads\/2024\/03\/Screenshot-from-2024-03-25-14-55-43.png\" alt=\"\" class=\"wp-image-1066\" srcset=\"https:\/\/www.aqua-informatics.jp\/wp-content\/uploads\/2024\/03\/Screenshot-from-2024-03-25-14-55-43.png 582w, https:\/\/www.aqua-informatics.jp\/wp-content\/uploads\/2024\/03\/Screenshot-from-2024-03-25-14-55-43-230x300.png 230w\" sizes=\"auto, (max-width: 582px) 100vw, 582px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"mariadb%E3%81%AE%E8%A8%AD%E5%AE%9A\"><\/span>mariadb\u306e\u8a2d\u5b9a<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>mariadb\u306e\u8a2d\u5b9a\u304c\u524d\u5f8c\u3057\u305f\u3088\u3046\u3060\u3002<br><a href=\"https:\/\/qiita.com\/airpocket\/items\/f1dd8e0d32be6075b7de\" data-type=\"link\" data-id=\"https:\/\/qiita.com\/airpocket\/items\/f1dd8e0d32be6075b7de\">\u3053\u3053<\/a>\u3092\u53c2\u8003\u306b\u3057\u305f\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>15:05 rpi@raspberrypi5b-alpha:~\n$sudo mysql_secure_installation\n\nNOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB\n      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!\n\nIn order to log into MariaDB to secure it, we'll need the current\npassword for the root user. If you've just installed MariaDB, and\nhaven't set the root password yet, you should just press enter here.\n\n<span data-color=\"#f78da7\" style=\"background: linear-gradient(transparent 60%,rgba(247, 141, 167, 0.7) 0);\" class=\"vk_highlighter\">Enter current password for root (enter for none): <\/span>\nOK, successfully used password, moving on...\n\nSetting the root password or using the unix_socket ensures that nobody\ncan log into the MariaDB root user without the proper authorisation.\n\nYou already have your root account protected, so you can safely answer 'n'.\n\n<span data-color=\"#f78da7\" style=\"background: linear-gradient(transparent 60%,rgba(247, 141, 167, 0.7) 0);\" class=\"vk_highlighter\">Switch to unix_socket authentication &#091;Y\/n] n<\/span>\n ... skipping.\n\nYou already have your root account protected, so you can safely answer 'n'.\n\n<span data-color=\"#f78da7\" style=\"background: linear-gradient(transparent 60%,rgba(247, 141, 167, 0.7) 0);\" class=\"vk_highlighter\">Change the root password? &#091;Y\/n] y<\/span>\nNew password: \nRe-enter new password: \nPassword updated successfully!\nReloading privilege tables..\n ... Success!\n\n\nBy default, a MariaDB installation has an anonymous user, allowing anyone\nto log into MariaDB without having to have a user account created for\nthem.  This is intended only for testing, and to make the installation\ngo a bit smoother.  You should remove them before moving into a\nproduction environment.\n\n<span data-color=\"#f78da7\" style=\"background: linear-gradient(transparent 60%,rgba(247, 141, 167, 0.7) 0);\" class=\"vk_highlighter\">Remove anonymous users? &#091;Y\/n] y<\/span>\n ... Success!\n\nNormally, root should only be allowed to connect from 'localhost'.  This\nensures that someone cannot guess at the root password from the network.\n\n<span data-color=\"#f78da7\" style=\"background: linear-gradient(transparent 60%,rgba(247, 141, 167, 0.7) 0);\" class=\"vk_highlighter\">Disallow root login remotely? &#091;Y\/n] n<\/span>\n ... skipping.\n\nBy default, MariaDB comes with a database named 'test' that anyone can\naccess.  This is also intended only for testing, and should be removed\nbefore moving into a production environment.\n\n<span data-color=\"#f78da7\" style=\"background: linear-gradient(transparent 60%,rgba(247, 141, 167, 0.7) 0);\" class=\"vk_highlighter\">Remove test database and access to it? &#091;Y\/n] y<\/span>\n - Dropping test database...\n ... Success!\n - Removing privileges on test database...\n ... Success!\n\nReloading the privilege tables will ensure that all changes made so far\nwill take effect immediately.\n\n<span data-color=\"#f78da7\" style=\"background: linear-gradient(transparent 60%,rgba(247, 141, 167, 0.7) 0);\" class=\"vk_highlighter\">Reload privilege tables now? &#091;Y\/n] y<\/span>\n ... Success!\n\nCleaning up...\n\nAll done!  If you've completed all of the above steps, your MariaDB\ninstallation should now be secure.\n\nThanks for using MariaDB!<\/code><\/pre>\n\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u306e\u5909\u66f4\u3001<br>binde-address\u306e\u884c\u3092\u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8\u3059\u308b\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>15:14 rpi@raspberrypi5b-alpha:~\n$sudo vi \/etc\/mysql\/mariadb.conf.d\/50-server.cnf <\/code><\/pre>\n\n\n\n<div style=\"height:26px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>mariadb\u306b\u63a5\u7d9a\u3057\u3066\u3001\u5916\u90e8\u304b\u3089\u306e\u30a2\u30af\u30bb\u30b9\u3092\u8a31\u53ef\u3057\u3066\u3001\u518d\u8d77\u52d5\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>15:17 rpi@raspberrypi5b-alpha:~\n$mysql -u root -p\nEnter password: \nWelcome to the MariaDB monitor.  Commands end with ; or \\g.\nYour MariaDB connection id is 40\nServer version: 10.11.6-MariaDB-0+deb12u1 Debian 12\n\nCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.\n\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\n\nMariaDB &#091;(none)]> grant all privileges on *.* to root@\"%\" identified by 'your password' with grant option;\nQuery OK, 0 rows affected (0.001 sec)\n\nMariaDB &#091;(none)]> exit;\nBye\n15:18 rpi@raspberrypi5b-alpha:~\n$sudo systemctl restart mysql\n<\/code><\/pre>\n\n\n\n<p>\u5165\u308c\u305f\uff01<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"811\" height=\"401\" src=\"https:\/\/www.aqua-informatics.jp\/wp-content\/uploads\/2024\/03\/Screenshot-from-2024-03-25-15-25-12.png\" alt=\"\" class=\"wp-image-1069\" srcset=\"https:\/\/www.aqua-informatics.jp\/wp-content\/uploads\/2024\/03\/Screenshot-from-2024-03-25-15-25-12.png 811w, https:\/\/www.aqua-informatics.jp\/wp-content\/uploads\/2024\/03\/Screenshot-from-2024-03-25-15-25-12-300x148.png 300w, https:\/\/www.aqua-informatics.jp\/wp-content\/uploads\/2024\/03\/Screenshot-from-2024-03-25-15-25-12-768x380.png 768w\" sizes=\"auto, (max-width: 811px) 100vw, 811px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\u306f\u3058\u3081\u306b \u6280\u9069\u306e\u3042\u308bRaspberry Pi 5\u3068Nvme base\u3092\u5165\u624b\u3057\u3066\u3044\u305f\u304c\u3001M.2\u898f\u683c\u306eSSD\u306e\u5165\u624b\u3092\u624b\u914d\u3057\u3066\u3044\u306a\u304b\u3063\u305f\u306e\u3067\u3001\u653e\u7f6e\u3057\u3066\u3044\u305f\u3002Amazon\u3067\u4e00\u756a\u5b89\u304b\u3063\u305f\u30b7\u30ea\u30b3\u30f3\u30d1\u30ef\u30fc\u306e128GB\u306eM.2\u3092\u5165\u624b\u3057\u305f [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":92,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_vk_print_noindex":"","sitemap_hide":"","_veu_custom_css":"","veu_display_promotion_alert":"common","vkexunit_cta_each_option":"","_lightning_design_setting":{"layout":"default"},"footnotes":""},"categories":[7],"tags":[],"class_list":["post-1035","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux"],"veu_head_title_object":{"title":"","add_site_title":""},"_links":{"self":[{"href":"https:\/\/www.aqua-informatics.jp\/index.php?rest_route=\/wp\/v2\/posts\/1035","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.aqua-informatics.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.aqua-informatics.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.aqua-informatics.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.aqua-informatics.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1035"}],"version-history":[{"count":30,"href":"https:\/\/www.aqua-informatics.jp\/index.php?rest_route=\/wp\/v2\/posts\/1035\/revisions"}],"predecessor-version":[{"id":1074,"href":"https:\/\/www.aqua-informatics.jp\/index.php?rest_route=\/wp\/v2\/posts\/1035\/revisions\/1074"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.aqua-informatics.jp\/index.php?rest_route=\/wp\/v2\/media\/92"}],"wp:attachment":[{"href":"https:\/\/www.aqua-informatics.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1035"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.aqua-informatics.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1035"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.aqua-informatics.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1035"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}