{"id":8271,"date":"2024-03-02T08:59:03","date_gmt":"2024-03-01T23:59:03","guid":{"rendered":"https:\/\/arakoki70.com\/?p=8271"},"modified":"2024-12-15T15:52:54","modified_gmt":"2024-12-15T06:52:54","slug":"raspberry-pi-%e3%81%ab%e3%81%82%e3%82%8b-mariadb-%e3%81%ab-ubuntu-%e3%81%8b%e3%82%89%e3%82%a2%e3%82%af%e3%82%bb%e3%82%b9%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/arakoki70.com\/?p=8271","title":{"rendered":"Raspberry Pi \u306b\u3042\u308b Mariadb \u306b Ubuntu \u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b"},"content":{"rendered":"<div style=\"background: #f5f5f5; padding: 10px; border: 2px solid #800000; text-align: center; box-shadow: 5px 5px 5px #aaa; font-size: 16px;\"><span style=\"font-size: 14pt;\"><strong><span style=\"font-size: 12pt;\">Ubuntu Desktop 22.04 LTS \u30ce\u30a6\u30cf\u30a6<\/span><br \/>\r\nUbuntu \u304b\u3089<br \/>\r\nRaspberry Pi \u306e Mariadb \u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b<\/strong><\/span><\/div>\r\n<div>\u00a0<\/div>\r\n<div>Raspberry Pi \u306e Mariadb \u306b\u84c4\u7a4d\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u3092\u3001Ubuntu \u304b\u3089 Python\u3092\u4f7f\u3063\u3066\u30a2\u30af\u30bb\u30eb\u3057\u3066\u307f\u308b\u3002<\/div>\r\n<div>\u00a0<\/div>\r\n<div><a href=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/ext-mariadb_0011.png\" data-rel=\"lightbox-gallery-3wrMaCoQ\" data-rl_title=\"ext-mariadb_0011\" data-rl_caption=\"\" title=\"ext-mariadb_0011\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8272\" src=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/ext-mariadb_0011.png\" alt=\"\u30dd\u30fc\u30c8\u756a\u53f7\u3092\u8abf\u3079\u308b\u30b3\u30de\u30f3\u30c9\" width=\"600\" height=\"126\" \/><\/a><\/div>\r\n<div style=\"text-align: center;\"><span style=\"font-size: 10pt;\">\u901a\u5e38 Mariadb \u306b\u306f\u30dd\u30fc\u30c8\u756a\u53f7\u300c3306\u300d\u304c\u4f7f\u7528\u3055\u308c\u308b\u3002<\/span><\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u00a0\u4ee5\u4e0b\u3001Ubuntu \u304b\u3089 Raspberry Pi \u306e Mariadb \u3092\u8aad\u3093\u3067\u3001\u300cCSV\u300d\u306b\u66f8\u304d\u51fa\u3057\u305f\u8a18\u9332\u3002<\/div>\r\n<div><!--more--><\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u00a0<\/div>\r\n<div>\t<p>&nbsp;<\/p>\n\t<div align=\"center\" style=\"font-size:8pt;\">\u30b9\u30dd\u30f3\u30b5\u30fc \u30ea\u30f3\u30af<br \/>\n<!-- \t<script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script> -->\n\t<!-- \u8a18\u4e8b\u30fb\u30ec\u30b9\u30dd\u30f3\u30b7\u30d6-7 -->\n\t<ins class=\"adsbygoogle\"\n     style=\"display:block\"\n     data-ad-client=\"ca-pub-3816629014893825\"\n     data-ad-slot=\"1428770894\"\n     data-ad-format=\"auto\"\n     data-full-width-responsive=\"true\"><\/ins>\n\t<script>\n\t(adsbygoogle = window.adsbygoogle || []).push({});\n\t<\/script>\n\t<amp-ad width=\"100vw\" height=\"320\"\n     type=\"adsense\"\n     data-ad-client=\"ca-pub-3816629014893825\"\n     data-ad-slot=\"1428770894\"\n     data-auto-format=\"rspv\"\n     data-full-width=\"\">\n\t <div overflow=\"\"><\/div>\n\t<\/amp-ad>\n\t<\/div>\n\t<p>&nbsp;<\/p>\n<\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u00a0<\/div>\r\n<div style=\"border: 1px solid #c0c0c0; padding: 7px; background: #f5f5f5; border-radius: 8px; position: relative; top: 0px; font-family: Arial, Helvetica, sans-serif; font-size: 16px;\">\r\n<div><strong><span style=\"font-size: 14pt;\">\u3000\u76ee\u3000\u6b21<\/span><\/strong><\/div>\r\n<div style=\"margin-left: 20pt; line-height: 200%;\"><span style=\"color: magenta;\">1.\u3000<\/span><a href=\"#title1\"><strong>Raspberry Pi\u3067\u306e\u30d5\u30a1\u30a4\u30a2\u30a6\u30a9\u30fc\u30eb\uff08ufw\uff09\u306e\u8a2d\u5b9a<\/strong><\/a><br \/>\r\n<span style=\"color: magenta;\">2.\u3000<\/span><a href=\"#title2\"><strong>Raspberry Pi\u5074 Mariadb \u306e\u8a2d\u5b9a<\/strong><\/a><br \/>\r\n<span style=\"color: magenta;\">3.\u3000<\/span><a href=\"#title3\"><strong>Ubuntu \u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b Python \u30b9\u30af\u30ea\u30d7\u30c8<\/strong><\/a><\/div>\r\n<\/div>\r\n<div>\u00a0<\/div>\r\n<div id=\"title1\">\u00a0<\/div>\r\n<div>\u00a0<\/div>\r\n<div style=\"border: 1px solid #800000; padding: 5px 10px 3px 10px; background: #c5ff88;\"><strong>1. Raspberry Pi\u3067\u306e\u30d5\u30a1\u30a4\u30a2\u30a6\u30a9\u30fc\u30eb\uff08ufw\uff09\u306e\u8a2d\u5b9a<\/strong><\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u901a\u5e38 Mariadb \u306b\u306f\u30dd\u30fc\u30c8\u756a\u53f7\u300c<span style=\"color: #ff0000;\"><strong>3306<\/strong><\/span>\u300d\u304c\u4f7f\u7528\u3055\u308c\u308b\u3002<\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u30dd\u30fc\u30c8\u756a\u53f7\u3092\u8abf\u3079\u308b\u30b3\u30de\u30f3\u30c9\u3002<\/div>\r\n<div style=\"border: 1px solid #4169e1; padding: 5px 10px 3px 10px; background: #f0f8ff; border-radius: 5px; position: relative; top: 0px;\"><strong>sudo mariadb<br \/>\r\nMariaDB[(none)]&gt; show variables like 'port';<\/strong><\/div>\r\n<div>\u00a0<\/div>\r\n<div><a href=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/ext-mariadb_0011.png\" data-rel=\"lightbox-gallery-3wrMaCoQ\" data-rl_title=\"ext-mariadb_0011\" data-rl_caption=\"\" title=\"ext-mariadb_0011\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8272\" src=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/ext-mariadb_0011.png\" alt=\"\u30dd\u30fc\u30c8\u756a\u53f7\u3092\u8abf\u3079\u308b\u30b3\u30de\u30f3\u30c9\" width=\"600\" height=\"126\" \/><\/a><\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u30dd\u30fc\u30c8\u756a\u53f7\u3092\u5909\u66f4\u3059\u308b\u306b\u306f\u3001MariaDB\u306e\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u3092\u7de8\u96c6\u3059\u308b\u3002\u3002<\/div>\r\n<div style=\"border: 1px solid #4169e1; padding: 5px 10px 3px 10px; background: #f0f8ff; border-radius: 5px; position: relative; top: 0px;\"><strong>sudo nano \/etc\/mysql\/mariadb.conf.d\/50-server.cnf<\/strong><\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u300cBasic Settings\u300d\u306b\u3001\u30dd\u30fc\u30c8\u756a\u53f7\u306e\u8a18\u8f09\u304c\u306a\u3044\u306e\u3067\u8ffd\u8a18\u3059\u308b\u3002<br \/>\r\nport = 12345<br \/>\r\n<a href=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/ext-mariadb_0021.png\" data-rel=\"lightbox-gallery-3wrMaCoQ\" data-rl_title=\"ext-mariadb_0021\" data-rl_caption=\"\" title=\"ext-mariadb_0021\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8273\" src=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/ext-mariadb_0021.png\" alt=\"\u300cBasic Settings\u300d\u306b\u3001\u30dd\u30fc\u30c8\u756a\u53f7\u306e\u8a18\u8f09\u304c\u306a\u3044\u306e\u3067\u8ffd\u8a18\u3059\u308b\" width=\"600\" height=\"355\" \/><\/a><\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u30d5\u30a1\u30a4\u30a2\u30a6\u30a9\u30fc\u30eb\u30673306\u30dd\u30fc\u30c8\u3092\u89e3\u653e\u3059\u308b\u3002<\/div>\r\n<div style=\"border: 1px solid #4169e1; padding: 5px 10px 3px 10px; background: #f0f8ff; border-radius: 5px; position: relative; top: 0px;\"><strong>sudo ufw allow 3306<\/strong><\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u5909\u66f4\u5185\u5bb9\u3092\u78ba\u8a8d\u3059\u308b\u3002<\/div>\r\n<div style=\"border: 1px solid #4169e1; padding: 5px 10px 3px 10px; background: #f0f8ff; border-radius: 5px; position: relative; top: 0px;\"><strong>sudo ufw status<\/strong><\/div>\r\n<div>\u00a0<\/div>\r\n<div><a href=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/ext-mariadb_0031.png\" data-rel=\"lightbox-gallery-3wrMaCoQ\" data-rl_title=\"ext-mariadb_0031\" data-rl_caption=\"\" title=\"ext-mariadb_0031\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8274\" src=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/ext-mariadb_0031.png\" alt=\"sudo ufw status\" width=\"600\" height=\"292\" \/><\/a><\/div>\r\n<div>\u00a0<\/div>\r\n<div id=\"title2\">\u00a0<\/div>\r\n<div>\u00a0<\/div>\r\n<div style=\"border: 1px solid #800000; padding: 5px 10px 3px 10px; background: #c5ff88;\"><strong>2. Raspberry Pi\u5074 Mariadb \u306e\u8a2d\u5b9a<\/strong><\/div>\r\n<div>\u00a0<\/div>\r\n<div style=\"border: 1px solid #4169e1; padding: 5px 10px 3px 10px; color: #ffffff; background: #191970; border-radius: 5px; position: relative; top: 0px;\">\u2460\uff0ebind-address\u3092\u5909\u66f4\u3059\u308b<\/div>\r\n<div>\u00a0<\/div>\r\n<div>MariaDB\u306e\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u3092\u7de8\u96c6\u3057\u3001bind-address\u3092\u5909\u66f4\u3059\u308b\u3002<\/div>\r\n<div style=\"border: 1px solid #4169e1; padding: 5px 10px 3px 10px; background: #f0f8ff; border-radius: 5px; position: relative; top: 0px;\"><strong>sudo nano \/etc\/mysql\/mariadb.conf.d\/50-server.cnf<\/strong><\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u4e0b\u8a18\u3092\u3001\u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8\u3068\u8ffd\u8a18\u3002<br \/>\r\n#bind-address = 127.0.0.1<br \/>\r\nbind-address = 0.0.0.0<br \/>\r\n<a href=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/ext-mariadb_0111.png\" data-rel=\"lightbox-gallery-3wrMaCoQ\" data-rl_title=\"ext-mariadb_0111\" data-rl_caption=\"\" title=\"ext-mariadb_0111\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8275\" src=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/ext-mariadb_0111.png\" alt=\"sudo nano \/etc\/mysql\/mariadb.conf.d\/50-server.cnf\" width=\"600\" height=\"303\" \/><\/a><\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u3053\u306e\u8a2d\u5b9a\u304c\u3055\u308c\u3066\u3044\u306a\u3044\u5834\u5408\u306b\u8868\u793a\u3055\u308c\u308b\u30a8\u30e9\u30fc\u3002<\/div>\r\n<div style=\"border: 1px solid #800000; padding: 10px; background: #FFF0F5;\"><strong>mysql.connector.errors.DatabaseError: 2003 (HY000): Can't connect to MySQL server on '192.168.11.112:3306' (111)<\/strong><\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u00a0<\/div>\r\n<div style=\"border: 1px solid #4169e1; padding: 5px 10px 3px 10px; color: #ffffff; background: #191970; border-radius: 5px; position: relative; top: 0px;\">\u2461\uff0e\u4f7f\u7528\u3059\u308b\u30e6\u30fc\u30b6\u30fc\u306b\u3001\u5916\u90e8\u304b\u3089\u306e\u30a2\u30af\u30bb\u30b9\u6a29\u3092\u8a2d\u5b9a\u3059\u308b<\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u30e6\u30fc\u30b6\u30fc\u4e00\u89a7\u3067\u3001user \u30ab\u30e9\u30e0\u3068 host \u30ab\u30e9\u30e0\u306e\u60c5\u5831\u3092\u78ba\u8a8d\u3057\u3066\u307f\u308b\u3002<\/div>\r\n<div style=\"border: 1px solid #4169e1; padding: 5px 10px 3px 10px; background: #f0f8ff; border-radius: 5px; position: relative; top: 0px;\"><strong>sudo mariadb<br \/>\r\nMariaDB[(none)]&gt; select user, host from mysql.user;<\/strong><\/div>\r\n<div>\u00a0<\/div>\r\n<pre><code class=\"hljs sql\">+<span class=\"hljs-comment\">-------------+-----------+<\/span>\r\n| User        | Host      |\r\n+<span class=\"hljs-comment\">-------------+-----------+<\/span>\r\n| flaskpy     | localhost |\r\n| mariadb.sys | localhost |\r\n| mysql       | localhost |\r\n| root        | localhost |\r\n+<span class=\"hljs-comment\">-------------+-----------+<\/span><\/code><\/pre>\r\n<div>\u4f7f\u7528\u3059\u308b\u30e6\u30fc\u30b6\u30fc\u300cflaskpy\u300d\u306e\u3001Host \u304c localhost \u306e\u307f\u306b\u306a\u3063\u3066\u3044\u308b\u3002<\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u4f7f\u7528\u3059\u308b\u30e6\u30fc\u30b6\u30fc\u306b\u5916\u90e8\u30a2\u30af\u30bb\u30b9\u3092\u8a31\u53ef\u3059\u308b\u6a29\u9650\u3092\u8a2d\u5b9a\u3059\u308b\u3002<\/div>\r\n<div style=\"border: 1px solid #4169e1; padding: 5px 10px 3px 10px; background: #f0f8ff; border-radius: 5px; position: relative; top: 0px;\"><strong>CREATE USER 'flaskpy' IDENTIFIED BY '';<br \/>\r\nGRANT ALL PRIVILEGES ON *.* TO 'flaskpy'@'%' WITH GRANT OPTION;<\/strong><\/div>\r\n<div>\u00a0<\/div>\r\n<pre><code class=\"hljs sql\">+<span class=\"hljs-comment\">-------------+-----------+<\/span>\r\n| User        | Host    \u3000|\r\n+<span class=\"hljs-comment\">-------------+-----------+<\/span>\r\n| flaskpy     | %         |\r\n| flaskpy     | localhost |\r\n| mariadb.sys | localhost |\r\n| mysql       | localhost |\r\n| root        | localhost |\r\n+<span class=\"hljs-comment\">-------------+-----------+<\/span><\/code><\/pre>\r\n<div>\u30e6\u30fc\u30b6\u30fc flaskpy \u304c\u65b0\u305f\u306b\u8ffd\u52a0\u3055\u308c\u3001Host \u304c %\uff08\u30ef\u30a4\u30eb\u30c9\u30ab\u30fc\u30c9\uff09\u306b\u306a\u3063\u3066\u3044\u308b\u3002<br \/>\r\n<a href=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/ext-mariadb_0121.png\" data-rel=\"lightbox-gallery-3wrMaCoQ\" data-rl_title=\"ext-mariadb_0121\" data-rl_caption=\"\" title=\"ext-mariadb_0121\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8276\" src=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/ext-mariadb_0121.png\" alt=\"flaskpy \u304c\u65b0\u305f\u306b\u8ffd\u52a0\u3055\u308c\u3001host \u304c %\uff08\u30ef\u30a4\u30eb\u30c9\u30ab\u30fc\u30c9\uff09\u306b\u306a\u3063\u3066\u3044\u308b\" width=\"600\" height=\"626\" \/><\/a><\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u3053\u308c\u3067 flaskpy \u306b\u5bfe\u3057\u3066\u3001\u30db\u30b9\u30c8\u5074\u306e\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304b\u3089\u306e\u30a2\u30af\u30bb\u30b9\u304c\u53ef\u80fd\u3068\u306a\u308b\u3002<\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u3053\u306e\u8a2d\u5b9a\u304c\u3055\u308c\u3066\u3044\u306a\u3044\u5834\u5408\u306b\u8868\u793a\u3055\u308c\u308b\u30a8\u30e9\u30fc\u3002<\/div>\r\n<div style=\"border: 1px solid #800000; padding: 10px; background: #FFF0F5;\"><strong>mysql.connector.errors.DatabaseError: 1130 (HY000): Host '192.168.11.121' is not allowed to connect to this MariaDB server<\/strong><\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u00a0<\/div>\r\n<div style=\"border: 1px solid #4169e1; padding: 5px 10px 3px 10px; color: #ffffff; background: #191970; border-radius: 5px; position: relative; top: 0px;\">\u2462\uff0eHost\u3092\u5916\u90e8\u304b\u3089\u63a5\u7d9a\u3067\u304d\u308b%\u306b\u3057\u3066\u30e6\u30fc\u30b6\u30fc\u3092\u4f5c\u308a\u76f4\u3059<\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u4f7f\u7528\u3059\u308b\u30e6\u30fc\u30b6\u30fc flaskpy \u306e Host \u306b\u300clocalhost\u300d \u304c\u6b8b\u3063\u3066\u3044\u308b\u3068\u3001<\/div>\r\n<pre><code class=\"hljs sql\">+<span class=\"hljs-comment\">-------------+-----------+<\/span>\r\n| User        | Host    \u3000|\r\n+<span class=\"hljs-comment\">-------------+-----------+<\/span>\r\n| flaskpy     | %         |\r\n| flaskpy     | localhost |\r\n+<span class=\"hljs-comment\">-------------+-----------+<\/span><\/code><\/pre>\r\n<div><a href=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/ext-mariadb_0131.png\" data-rel=\"lightbox-gallery-3wrMaCoQ\" data-rl_title=\"ext-mariadb_0131\" data-rl_caption=\"\" title=\"ext-mariadb_0131\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8277\" src=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/ext-mariadb_0131.png\" alt=\"\u4f7f\u7528\u3059\u308b\u30e6\u30fc\u30b6\u30fc flaskpy \u306b Host \u300clocalhost\u300d \u304c\u6b8b\u3063\u3066\u3044\u308b\" width=\"600\" height=\"288\" \/><\/a><\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u6b21\u306e\u30a8\u30e9\u30fc\u304c\u8868\u793a\u3055\u308c\u308b\u3002<\/div>\r\n<div style=\"border: 1px solid #800000; padding: 10px; background: #FFF0F5;\"><strong>mysql.connector.errors.ProgrammingError: 1045 (28000): Access denied for user 'flaskpy'@'192.168.11.121' (using password: YES)<\/strong><\/div>\r\n<div>\u00a0<\/div>\r\n<div>\u00a0<\/div>\r\n<div>Host\u3092\u5916\u90e8\u304b\u3089\u63a5\u7d9a\u3067\u304d\u308b\u300c%\u300d\u306b\u3057\u3066\u30e6\u30fc\u30b6\u30fc\u3092\u4f5c\u308a\u76f4\u3059\u3002<\/div>\r\n<div style=\"border: 1px solid #4169e1; padding: 5px 10px 3px 10px; background: #f0f8ff; border-radius: 5px; position: relative; top: 0px;\"><strong>drop user flaskpy@localhost;<br \/>\r\ngrant all privileges on ondodb.* to 'flaskpy'@'%' identified by 'password' with grant option;<\/strong><\/div>\r\n<pre><code class=\"hljs sql\">+<span class=\"hljs-comment\">-------------+-----------+<\/span>\r\n| User        | Host      |\r\n+<span class=\"hljs-comment\">-------------+-----------+<\/span>\r\n| flaskpy     | %         |\r\n| mariadb.sys | localhost |\r\n| mysql       | localhost |\r\n| root        | localhost |\r\n+<span class=\"hljs-comment\">-------------+-----------+<\/span><\/code><\/pre>\r\n<div>\u00a0<\/div>\r\n<div><a href=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/ext-mariadb_0141.png\" data-rel=\"lightbox-gallery-3wrMaCoQ\" data-rl_title=\"ext-mariadb_0141\" data-rl_caption=\"\" title=\"ext-mariadb_0141\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8278\" src=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/ext-mariadb_0141.png\" alt=\"host\u3092\u5916\u90e8\u304b\u3089\u63a5\u7d9a\u3067\u304d\u308b%\u306b\u3057\u3066\u30e6\u30fc\u30b6\u30fc\u3092\u4f5c\u308a\u76f4\u3059\" width=\"600\" height=\"245\" \/><\/a><\/div>\r\n<div>\u00a0<\/div>\r\n<div id=\"title3\">\u00a0<\/div>\r\n<div>\u00a0<\/div>\r\n<div style=\"border: 1px solid #800000; padding: 5px 10px 3px 10px; background: #c5ff88;\"><strong>3. Ubuntu \u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b Python \u30b9\u30af\u30ea\u30d7\u30c8<\/strong><\/div>\r\n<div>\u00a0<\/div>\r\n<div>Raspberry Pi\u5074\u306e Mariadb \u3092\u8aad\u3093\u3067\u3001 Ubuntu \u5074\u3067\u300cCSV\u300d\u306b\u66f8\u304d\u51fa\u3059\u30b9\u30af\u30ea\u30d7\u30c8\u3002<\/div>\r\n<div>\u00a0<\/div>\r\n<pre><code class=\u201dhljs python\"><span class=\"hljs-comment\"># -*- coding: utf-8 -*-<\/span>\r\n\r\n<span class=\"hljs-keyword\">import<\/span> csv\r\n<span class=\"hljs-keyword\">import<\/span> mysql.connector\r\n\r\n<span class=\"hljs-comment\"># \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a<\/span>\r\nconnection = mysql.connector.connect(\r\n        user=<span class=\"hljs-string\">\"flaskpy\"<\/span>,\r\n        password=<span class=\"hljs-string\">\"password\"<\/span>,\r\n        host=<span class=\"hljs-string\">\"192.168.11.112\"<\/span>,\r\n        port=<span class=\"hljs-string\">\"3306\"<\/span>,\r\n        database=<span class=\"hljs-string\">\"ondodb\"<\/span>\r\n)\r\n\r\n<span class=\"hljs-comment\"># CSV\u30d5\u30a1\u30a4\u30eb\u306b\u66f8\u304d\u51fa\u3059\u969b\u306e\u30d5\u30a1\u30a4\u30eb\u30d1\u30b9<\/span>\r\ncsv_file_path = <span class=\"hljs-string\">'work\/ondo_situdo_31.csv'<\/span>\r\n\r\n<span class=\"hljs-comment\"># \u30ab\u30fc\u30bd\u30eb\u306e\u4f5c\u6210<\/span>\r\ncursor = connection.cursor()\r\n\r\n<span class=\"hljs-keyword\">try<\/span>:\r\n    <span class=\"hljs-comment\"># \u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u30af\u30a8\u30ea<\/span>\r\n    query = <span class=\"hljs-string\">'SELECT * FROM ondo_situdo'<\/span>\r\n    cursor.execute(query)\r\n\r\n    <span class=\"hljs-comment\"># \u53d6\u5f97\u3057\u305f\u30c7\u30fc\u30bf\u3092CSV\u30d5\u30a1\u30a4\u30eb\u306b\u66f8\u304d\u51fa\u3059<\/span>\r\n    <span class=\"hljs-keyword\">with<\/span> open(csv_file_path, <span class=\"hljs-string\">'w'<\/span>, newline=<span class=\"hljs-string\">''<\/span>, encoding=<span class=\"hljs-string\">'utf-8'<\/span>) <span class=\"hljs-keyword\">as<\/span> csv_file:\r\n        csv_writer = csv.writer(csv_file)\r\n\r\n        <span class=\"hljs-comment\"># \u30d8\u30c3\u30c0\u30fc\u3092\u66f8\u304d\u8fbc\u3080<\/span>\r\n        csv_writer.writerow([i[<span class=\"hljs-number\">0<\/span>] <span class=\"hljs-keyword\">for<\/span> i <span class=\"hljs-keyword\">in<\/span> cursor.description])\r\n\r\n        <span class=\"hljs-comment\"># \u30c7\u30fc\u30bf\u3092\u66f8\u304d\u8fbc\u3080<\/span>\r\n        csv_writer.writerows(cursor.fetchall())\r\n\r\n    print(<span class=\"hljs-string\">f'Data exported to <span class=\"hljs-subst\">{csv_file_path}<\/span>'<\/span>)\r\n\r\n<span class=\"hljs-keyword\">except<\/span> Exception <span class=\"hljs-keyword\">as<\/span> e:\r\n    print(<span class=\"hljs-string\">f'Error: <span class=\"hljs-subst\">{e}<\/span>'<\/span>)\r\n\r\n<span class=\"hljs-keyword\">finally<\/span>:\r\n    <span class=\"hljs-comment\"># \u63a5\u7d9a\u3092\u9589\u3058\u308b<\/span>\r\n    cursor.close()\r\n    connection.close()\r\n\r\n<\/code><\/pre>\r\n<div>\u00a0<\/div>\r\n<div>\u300chost=\u300d\u3067\u3001Raspberry Pi\u306eIP\u30a2\u30c9\u30ec\u30b9\u3092\u6307\u5b9a\u3059\u308b\u3002<\/div>\r\n<pre><code class=\u201dhljs python\">        host=<span class=\"hljs-string\">\"192.168.11.112\"<\/span>,\r\n        port=<span class=\"hljs-string\">\"3306\"<\/span>,<\/code><\/pre>\r\n<div>\u00a0<\/div>\r\n<p>&nbsp;<\/p>\r\n<p style=\"text-align: right;\">\u4ee5\u4e0a\u3002<br \/>\r\n(2024.03.02)<\/p>\r\n<div style=\"clear: both;\">\u00a0<\/div>\r\n<div>\t<p>&nbsp;<\/p>\n\t<div align=\"center\" style=\"font-size:8pt;\">\u30b9\u30dd\u30f3\u30b5\u30fc \u30ea\u30f3\u30af<br \/>\n<!-- \t<script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script> -->\n\t<!-- \u8a18\u4e8b\u30fb\u30ec\u30b9\u30dd\u30f3\u30b7\u30d6-7 -->\n\t<ins class=\"adsbygoogle\"\n     style=\"display:block\"\n     data-ad-client=\"ca-pub-3816629014893825\"\n     data-ad-slot=\"1428770894\"\n     data-ad-format=\"auto\"\n     data-full-width-responsive=\"true\"><\/ins>\n\t<script>\n\t(adsbygoogle = window.adsbygoogle || []).push({});\n\t<\/script>\n\t<amp-ad width=\"100vw\" height=\"320\"\n     type=\"adsense\"\n     data-ad-client=\"ca-pub-3816629014893825\"\n     data-ad-slot=\"1428770894\"\n     data-auto-format=\"rspv\"\n     data-full-width=\"\">\n\t <div overflow=\"\"><\/div>\n\t<\/amp-ad>\n\t<\/div>\n\n\t<p>&nbsp;<\/p>\n\n\t<p align=\"center\">\n\t<amp-social-share type=\"email\"><\/amp-social-share>\n\t&nbsp;<amp-social-share type=\"facebook\" data-param-app_id=\"131027923993169\"><\/amp-social-share>\n\t&nbsp;<amp-social-share type=\"linkedin\"><\/amp-social-share>\n\t&nbsp;<amp-social-share type=\"pinterest\"><\/amp-social-share>\n\t&nbsp;<amp-social-share type=\"tumblr\"><\/amp-social-share>\n\t&nbsp;<amp-social-share type=\"twitter\"><\/amp-social-share>\n\t&nbsp;<amp-social-share type=\"whatsapp\"><\/amp-social-share>\n\t&nbsp;<amp-social-share type=\"line\"><\/amp-social-share>\n\t<\/p>\n\n\t<p>&nbsp;<\/p>\n\t\n\t<!-- \u95a2\u9023\u30fb\u30ec\u30b9\u30dd\u30f3\u30b7\u30d6 kanren-70 -->\n\t<div align=\"center\">\n\t\n\t<ins class=\"adsbygoogle\"\n     style=\"display:block\"\n     data-ad-format=\"autorelaxed\"\n     data-ad-client=\"ca-pub-3816629014893825\"\n     data-ad-slot=\"8839675487\"><\/ins>\n\t<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n\t<\/script>\n\t\n\t<amp-ad width=\"100vw\" height=\"320\"\n\t\ttype=\"adsense\"\n\t\tdata-ad-client=\"ca-pub-3816629014893825\"\n\t\tdata-ad-slot=\"8839675487\"\n\t\tdata-auto-format=\"mcrspv\"\n\t\tdata-full-width=\"\">\n\t\t<div overflow=\"\"><\/div>\n\t<\/amp-ad>\n\t\n\t<\/div>\n\t\n\t<div> <\/div>\n\n\t<p>&nbsp;<\/p>\n<\/div>\r\n<div>\u00a0<\/div>","protected":false},"excerpt":{"rendered":"Ubuntu Desktop 22.04 LTS \u30ce\u30a6\u30cf\u30a6 Ubuntu \u304b\u3089 Raspberry Pi \u306e Mariadb \u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b \u00a0 Raspberry Pi \u306e Mariadb \u306b\u84c4\u7a4d\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u3092\u3001U &hellip; <p class=\"link-more\"><a href=\"https:\/\/arakoki70.com\/?p=8271\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;Raspberry Pi \u306b\u3042\u308b Mariadb \u306b Ubuntu \u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>","protected":false},"author":1,"featured_media":8274,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[110],"tags":[],"class_list":["post-8271","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-02python"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Raspberry Pi \u306b\u3042\u308b Mariadb \u306b Ubuntu \u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b - \u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/arakoki70.com\/?p=8271\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Raspberry Pi \u306b\u3042\u308b Mariadb \u306b Ubuntu \u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b - \u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c\" \/>\n<meta property=\"og:description\" content=\"Ubuntu Desktop 22.04 LTS \u30ce\u30a6\u30cf\u30a6 Ubuntu \u304b\u3089 Raspberry Pi \u306e Mariadb \u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b \u00a0 Raspberry Pi \u306e Mariadb \u306b\u84c4\u7a4d\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u3092\u3001U &hellip; &quot;Raspberry Pi \u306b\u3042\u308b Mariadb \u306b Ubuntu \u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b&quot; \u306e\u7d9a\u304d\u3092\u8aad\u3080\" \/>\n<meta property=\"og:url\" content=\"https:\/\/arakoki70.com\/?p=8271\" \/>\n<meta property=\"og:site_name\" content=\"\u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-01T23:59:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-15T06:52:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/ext-mariadb_0031.png\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"292\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"tacsan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@hermione2207\" \/>\n<meta name=\"twitter:site\" content=\"@hermione2207\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"tacsan\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"10\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8271#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8271\"},\"author\":{\"name\":\"tacsan\",\"@id\":\"https:\\\/\\\/arakoki70.com\\\/#\\\/schema\\\/person\\\/d5fdbdb63e731d3f2d43880ccade4451\"},\"headline\":\"Raspberry Pi \u306b\u3042\u308b Mariadb \u306b Ubuntu \u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b\",\"datePublished\":\"2024-03-01T23:59:03+00:00\",\"dateModified\":\"2024-12-15T06:52:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8271\"},\"wordCount\":191,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/#\\\/schema\\\/person\\\/d5fdbdb63e731d3f2d43880ccade4451\"},\"image\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8271#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/arakoki70.com\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/ext-mariadb_0031.png\",\"articleSection\":[\"02 Python + MariaDB\"],\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/arakoki70.com\\\/?p=8271#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8271\",\"url\":\"https:\\\/\\\/arakoki70.com\\\/?p=8271\",\"name\":\"Raspberry Pi \u306b\u3042\u308b Mariadb \u306b Ubuntu \u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b - \u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8271#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8271#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/arakoki70.com\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/ext-mariadb_0031.png\",\"datePublished\":\"2024-03-01T23:59:03+00:00\",\"dateModified\":\"2024-12-15T06:52:54+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8271#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/arakoki70.com\\\/?p=8271\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8271#primaryimage\",\"url\":\"https:\\\/\\\/arakoki70.com\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/ext-mariadb_0031.png\",\"contentUrl\":\"https:\\\/\\\/arakoki70.com\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/ext-mariadb_0031.png\",\"width\":600,\"height\":292,\"caption\":\"sudo ufw status\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/arakoki70.com\\\/?p=8271#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u30db\u30fc\u30e0\",\"item\":\"https:\\\/\\\/arakoki70.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Raspberry Pi \u306b\u3042\u308b Mariadb \u306b Ubuntu \u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/arakoki70.com\\\/#website\",\"url\":\"https:\\\/\\\/arakoki70.com\\\/\",\"name\":\"\u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c\",\"description\":\"Around 70&#039;s \u30d6\u30ed\u30b0\u3078\u306e\u8a18\u4e8b\u6295\u7a3f\u304c\u751f\u6d3b\u76ee\u6a19\u306b \u30fb\u30fb\u30fb \u307e\u3060\u307e\u3060\u8f1d\u304f\",\"publisher\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/#\\\/schema\\\/person\\\/d5fdbdb63e731d3f2d43880ccade4451\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/arakoki70.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/arakoki70.com\\\/#\\\/schema\\\/person\\\/d5fdbdb63e731d3f2d43880ccade4451\",\"name\":\"tacsan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\\\/\\\/arakoki70.com\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/raspberry-toumei_4.png\",\"url\":\"https:\\\/\\\/arakoki70.com\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/raspberry-toumei_4.png\",\"contentUrl\":\"https:\\\/\\\/arakoki70.com\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/raspberry-toumei_4.png\",\"width\":80,\"height\":102,\"caption\":\"tacsan\"},\"logo\":{\"@id\":\"https:\\\/\\\/arakoki70.com\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/raspberry-toumei_4.png\"},\"sameAs\":[\"https:\\\/\\\/arakoki70.com\\\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Raspberry Pi \u306b\u3042\u308b Mariadb \u306b Ubuntu \u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b - \u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/arakoki70.com\/?p=8271","og_locale":"ja_JP","og_type":"article","og_title":"Raspberry Pi \u306b\u3042\u308b Mariadb \u306b Ubuntu \u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b - \u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c","og_description":"Ubuntu Desktop 22.04 LTS \u30ce\u30a6\u30cf\u30a6 Ubuntu \u304b\u3089 Raspberry Pi \u306e Mariadb \u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b \u00a0 Raspberry Pi \u306e Mariadb \u306b\u84c4\u7a4d\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u3092\u3001U &hellip; \"Raspberry Pi \u306b\u3042\u308b Mariadb \u306b Ubuntu \u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b\" \u306e\u7d9a\u304d\u3092\u8aad\u3080","og_url":"https:\/\/arakoki70.com\/?p=8271","og_site_name":"\u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c","article_published_time":"2024-03-01T23:59:03+00:00","article_modified_time":"2024-12-15T06:52:54+00:00","og_image":[{"width":600,"height":292,"url":"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/ext-mariadb_0031.png","type":"image\/png"}],"author":"tacsan","twitter_card":"summary_large_image","twitter_creator":"@hermione2207","twitter_site":"@hermione2207","twitter_misc":{"\u57f7\u7b46\u8005":"tacsan","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"10\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/arakoki70.com\/?p=8271#article","isPartOf":{"@id":"https:\/\/arakoki70.com\/?p=8271"},"author":{"name":"tacsan","@id":"https:\/\/arakoki70.com\/#\/schema\/person\/d5fdbdb63e731d3f2d43880ccade4451"},"headline":"Raspberry Pi \u306b\u3042\u308b Mariadb \u306b Ubuntu \u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b","datePublished":"2024-03-01T23:59:03+00:00","dateModified":"2024-12-15T06:52:54+00:00","mainEntityOfPage":{"@id":"https:\/\/arakoki70.com\/?p=8271"},"wordCount":191,"commentCount":0,"publisher":{"@id":"https:\/\/arakoki70.com\/#\/schema\/person\/d5fdbdb63e731d3f2d43880ccade4451"},"image":{"@id":"https:\/\/arakoki70.com\/?p=8271#primaryimage"},"thumbnailUrl":"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/ext-mariadb_0031.png","articleSection":["02 Python + MariaDB"],"inLanguage":"ja","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/arakoki70.com\/?p=8271#respond"]}]},{"@type":"WebPage","@id":"https:\/\/arakoki70.com\/?p=8271","url":"https:\/\/arakoki70.com\/?p=8271","name":"Raspberry Pi \u306b\u3042\u308b Mariadb \u306b Ubuntu \u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b - \u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c","isPartOf":{"@id":"https:\/\/arakoki70.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/arakoki70.com\/?p=8271#primaryimage"},"image":{"@id":"https:\/\/arakoki70.com\/?p=8271#primaryimage"},"thumbnailUrl":"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/ext-mariadb_0031.png","datePublished":"2024-03-01T23:59:03+00:00","dateModified":"2024-12-15T06:52:54+00:00","breadcrumb":{"@id":"https:\/\/arakoki70.com\/?p=8271#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/arakoki70.com\/?p=8271"]}]},{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/arakoki70.com\/?p=8271#primaryimage","url":"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/ext-mariadb_0031.png","contentUrl":"https:\/\/arakoki70.com\/wp-content\/uploads\/2024\/03\/ext-mariadb_0031.png","width":600,"height":292,"caption":"sudo ufw status"},{"@type":"BreadcrumbList","@id":"https:\/\/arakoki70.com\/?p=8271#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u30db\u30fc\u30e0","item":"https:\/\/arakoki70.com\/"},{"@type":"ListItem","position":2,"name":"Raspberry Pi \u306b\u3042\u308b Mariadb \u306b Ubuntu \u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b"}]},{"@type":"WebSite","@id":"https:\/\/arakoki70.com\/#website","url":"https:\/\/arakoki70.com\/","name":"\u30a2\u30e9\u30b3\u30ad\u304b\u3089\u306e Raspberry Pi \u96fb\u5b50\u5de5\u4f5c","description":"Around 70&#039;s \u30d6\u30ed\u30b0\u3078\u306e\u8a18\u4e8b\u6295\u7a3f\u304c\u751f\u6d3b\u76ee\u6a19\u306b \u30fb\u30fb\u30fb \u307e\u3060\u307e\u3060\u8f1d\u304f","publisher":{"@id":"https:\/\/arakoki70.com\/#\/schema\/person\/d5fdbdb63e731d3f2d43880ccade4451"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/arakoki70.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":["Person","Organization"],"@id":"https:\/\/arakoki70.com\/#\/schema\/person\/d5fdbdb63e731d3f2d43880ccade4451","name":"tacsan","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/arakoki70.com\/wp-content\/uploads\/2019\/12\/raspberry-toumei_4.png","url":"https:\/\/arakoki70.com\/wp-content\/uploads\/2019\/12\/raspberry-toumei_4.png","contentUrl":"https:\/\/arakoki70.com\/wp-content\/uploads\/2019\/12\/raspberry-toumei_4.png","width":80,"height":102,"caption":"tacsan"},"logo":{"@id":"https:\/\/arakoki70.com\/wp-content\/uploads\/2019\/12\/raspberry-toumei_4.png"},"sameAs":["https:\/\/arakoki70.com\/"]}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/arakoki70.com\/index.php?rest_route=\/wp\/v2\/posts\/8271","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/arakoki70.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/arakoki70.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/arakoki70.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/arakoki70.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8271"}],"version-history":[{"count":1,"href":"https:\/\/arakoki70.com\/index.php?rest_route=\/wp\/v2\/posts\/8271\/revisions"}],"predecessor-version":[{"id":8279,"href":"https:\/\/arakoki70.com\/index.php?rest_route=\/wp\/v2\/posts\/8271\/revisions\/8279"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/arakoki70.com\/index.php?rest_route=\/wp\/v2\/media\/8274"}],"wp:attachment":[{"href":"https:\/\/arakoki70.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8271"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/arakoki70.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8271"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/arakoki70.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8271"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}