{"id":28641,"date":"2022-12-03T07:26:50","date_gmt":"2023-07-04T23:29:45","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8jupyter-notebook%e6%9d%a5%e6%93%8d%e4%bd%9cmariadb\/"},"modified":"2025-08-12T09:18:45","modified_gmt":"2025-08-12T01:18:45","slug":"%e4%bd%bf%e7%94%a8jupyter-notebook%e6%9d%a5%e6%93%8d%e4%bd%9cmariadb","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8jupyter-notebook%e6%9d%a5%e6%93%8d%e4%bd%9cmariadb\/","title":{"rendered":"\u4f7f\u7528Jupyter Notebook\u6765\u64cd\u4f5cMariaDB"},"content":{"rendered":"<h1>\u9996\u5148(Hajime ni)<\/p>\n<p>\u6211\u5011\u5c07\u5efa\u7acb\u4e00\u500b\u74b0\u5883\uff0c\u4ee5\u4fbf\u5728Jupyter\u4e2d\u4f7f\u7528MariaDB\u3002<\/p>\n<h1>\u8bf7\u53c2\u7167<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">MariaDB10.1\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u65b9\u6cd5<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">MariaDB Package Repository Setup and Usage<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">MariaDB\u3092CentOS\u306b\u5c0e\u5165\u3057\u3066\u307f\u305f<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">MySql\u306e\u30bd\u30b1\u30c3\u30c8\u30a8\u30e9\u30fc\u3092\u89e3\u6c7a\u3059\u308b<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">MySQL 5.7 \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u3089\u6700\u521d\u306b\u884c\u3046\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">MariaDB ColumnStore \u3092 Jupyter Notebook \u304b\u3089\u4f7f\u3046<\/ul>\n<h1>\u73af\u5883<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Amazon Linux 2<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">jupyter\u306f\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6e08\u307f<\/ul>\n<h1>\u64cd\u4f5c\u6b65\u9a5f<\/p>\n<h2>\u5b89\u88c5MariaDBMariaDB\u53d1\u5e03\u72b6\u6001\u5728\u6b64\u5904\u53ef\u4ee5\u627e\u5230\u30022018\/01\u7684\u5f53\u524d\u7a33\u5b9a\u7248\u672c\u662f10.3\u3002<\/p>\n<p>MariaDB Package Repository Setup and Usage \u7684\u7f51\u9875\u4e0a\u6709\u5173\u4e8e\u5b89\u88c5\u65b9\u6cd5\u7684\u8bf4\u660e\u3002<\/p>\n<p>\u8bf7\u5728 root \u7528\u6237\u4e0b\u6267\u884c\u4ee5\u4e0b\u547d\u4ee4\u3002<\/p>\n<pre class=\"post-pre\"><code># curl -sS https:\/\/downloads.mariadb.com\/MariaDB\/mariadb_repo_setup | sudo bash\r\n\r\n[error] Could not identify OS type or version.\r\n[error] The MariaDB Repository supports these Linux OSs, on x86-64 only:\r\n    * RHEL\/CentOS 6 &amp; 7\r\n    * Ubuntu 14.04 LTS (trusty), 16.04 LTS (xenial), &amp; 18.04 LTS (bionic)\r\n    * Debian 8 (jessie) &amp; 9 (stretch)\r\n    * SLES 12 &amp; 15\r\n<\/code><\/pre>\n<p>\u5f88\u907a\u61be\uff0cAmazon Linux 2\u4e0d\u53d7\u652f\u63f4\uff0c\u6240\u4ee5\u7121\u6cd5\u4f7f\u7528\u9019\u500b\u65b9\u6cd5\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657cfd3837434c4406bc218e\/13-0.png\" alt=\"image.png\" \/><br \/>\n\u521b\u5efa\u4e00\u4e2a\u65b0\u6587\u4ef6\u3002<\/p>\n<pre class=\"post-pre\"><code># vi \/etc\/yum.repos.d\/mariadb.repo\r\n\r\n# MariaDB 10.3 CentOS repository list - created 2019-01-03 18:00 UTC\r\n# http:\/\/downloads.mariadb.org\/mariadb\/repositories\/\r\n[mariadb]\r\nname = MariaDB\r\nbaseurl = http:\/\/yum.mariadb.org\/10.3\/centos7-amd64\r\ngpgkey=https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB\r\ngpgcheck=1\r\n<\/code><\/pre>\n<p>\u6211\u4f1a\u5148\u8bd5\u7740\u6e05\u9664\u4e00\u4e0byum\u7684\u7f13\u5b58\u3002<\/p>\n<pre class=\"post-pre\"><code># yum clean all\r\n<\/code><\/pre>\n<p>\u4f7f\u7528 yum \u8fdb\u884c\u5b89\u88c5\u3002<\/p>\n<pre class=\"post-pre\"><code># sudo yum install MariaDB-server MariaDB-client\r\n\r\n\u8aad\u307f\u8fbc\u3093\u3060\u30d7\u30e9\u30b0\u30a4\u30f3:extras_suggestions, langpacks, priorities, update-motd\r\namzn2-core                                               | 2.4 kB     00:00\r\nmariadb                                                  | 2.9 kB     00:00\r\npgdg11                                                   | 4.1 kB     00:00\r\n(1\/6): amzn2-core\/2\/x86_64\/group_gz                        | 2.4 kB   00:00\r\n(2\/6): amzn2-core\/2\/x86_64\/updateinfo                      |  69 kB   00:00\r\n(3\/6): amzn2-core\/2\/x86_64\/primary_db                      |  25 MB   00:00\r\n(4\/6): pgdg11\/x86_64\/group_gz                              |  245 B   00:00\r\n(5\/6): mariadb\/primary_db                                  |  50 kB   00:01\r\n(6\/6): pgdg11\/x86_64\/primary_db                            | 141 kB   00:01\r\n7 packages excluded due to repository priority protections\r\n\u4f9d\u5b58\u6027\u306e\u89e3\u6c7a\u3092\u3057\u3066\u3044\u307e\u3059\r\n--&gt; \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u78ba\u8a8d\u3092\u5b9f\u884c\u3057\u3066\u3044\u307e\u3059\u3002\r\n---&gt; \u30d1\u30c3\u30b1\u30fc\u30b8 MariaDB-client.x86_64 0:10.3.11-1.el7.centos \u3092 \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\r\n--&gt; \u4f9d\u5b58\u6027\u306e\u51e6\u7406\u3092\u3057\u3066\u3044\u307e\u3059: MariaDB-common \u306e\u30d1\u30c3\u30b1\u30fc\u30b8: MariaDB-client-10.3.11-1.el7.centos.x86_64\r\n--&gt; \u4f9d\u5b58\u6027\u306e\u51e6\u7406\u3092\u3057\u3066\u3044\u307e\u3059: libncurses.so.5()(64bit) \u306e\u30d1\u30c3\u30b1\u30fc\u30b8: MariaDB-client-10.3.11-1.el7.centos.x86_64\r\n--&gt; \u4f9d\u5b58\u6027\u306e\u51e6\u7406\u3092\u3057\u3066\u3044\u307e\u3059: libtinfo.so.5()(64bit) \u306e\u30d1\u30c3\u30b1\u30fc\u30b8: MariaDB-client-10.3.11-1.el7.centos.x86_64\r\n---&gt; \u30d1\u30c3\u30b1\u30fc\u30b8 MariaDB-server.x86_64 0:10.3.11-1.el7.centos \u3092 \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\r\n--&gt; \u4f9d\u5b58\u6027\u306e\u51e6\u7406\u3092\u3057\u3066\u3044\u307e\u3059: perl(DBI) \u306e\u30d1\u30c3\u30b1\u30fc\u30b8: MariaDB-server-10.3.11-1.el7.centos.x86_64\r\n--&gt; \u4f9d\u5b58\u6027\u306e\u51e6\u7406\u3092\u3057\u3066\u3044\u307e\u3059: galera \u306e\u30d1\u30c3\u30b1\u30fc\u30b8: MariaDB-server-10.3.11-1.el7.centos.x86_64\r\n--&gt; \u4f9d\u5b58\u6027\u306e\u51e6\u7406\u3092\u3057\u3066\u3044\u307e\u3059: perl(Data::Dumper) \u306e\u30d1\u30c3\u30b1\u30fc\u30b8: MariaDB-server-10.3.11-1.el7.centos.x86_64\r\n--&gt; \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u78ba\u8a8d\u3092\u5b9f\u884c\u3057\u3066\u3044\u307e\u3059\u3002\r\n---&gt; \u30d1\u30c3\u30b1\u30fc\u30b8 MariaDB-common.x86_64 0:10.3.11-1.el7.centos \u3092 \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\r\n--&gt; \u4f9d\u5b58\u6027\u306e\u51e6\u7406\u3092\u3057\u3066\u3044\u307e\u3059: MariaDB-compat \u306e\u30d1\u30c3\u30b1\u30fc\u30b8: MariaDB-common-10.3.11-1.el7.centos.x86_64\r\n---&gt; \u30d1\u30c3\u30b1\u30fc\u30b8 galera.x86_64 0:25.3.24-1.rhel7.el7.centos \u3092 \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\r\n--&gt; \u4f9d\u5b58\u6027\u306e\u51e6\u7406\u3092\u3057\u3066\u3044\u307e\u3059: libboost_program_options.so.1.53.0()(64bit) \u306e\u30d1\u30c3\u30b1\u30fc\u30b8: galera-25.3.24-1.rhel7.el7.centos.x86_64\r\n---&gt; \u30d1\u30c3\u30b1\u30fc\u30b8 ncurses-compat-libs.x86_64 0:6.0-8.20170212.amzn2.1.2 \u3092 \u30a4\u30f3\u30b9 \u30c8\u30fc\u30eb\r\n---&gt; \u30d1\u30c3\u30b1\u30fc\u30b8 perl-DBI.x86_64 0:1.627-4.amzn2.0.2 \u3092 \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\r\n--&gt; \u4f9d\u5b58\u6027\u306e\u51e6\u7406\u3092\u3057\u3066\u3044\u307e\u3059: perl(RPC::PlServer) &gt;= 0.2001 \u306e\u30d1\u30c3\u30b1\u30fc\u30b8: perl-DBI-1.627-4.amzn2.0.2.x86_64\r\n--&gt; \u4f9d\u5b58\u6027\u306e\u51e6\u7406\u3092\u3057\u3066\u3044\u307e\u3059: perl(RPC::PlClient) &gt;= 0.2000 \u306e\u30d1\u30c3\u30b1\u30fc\u30b8: perl-DBI-1.627-4.amzn2.0.2.x86_64\r\n---&gt; \u30d1\u30c3\u30b1\u30fc\u30b8 perl-Data-Dumper.x86_64 0:2.145-3.amzn2.0.2 \u3092 \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\r\n--&gt; \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u78ba\u8a8d\u3092\u5b9f\u884c\u3057\u3066\u3044\u307e\u3059\u3002\r\n---&gt; \u30d1\u30c3\u30b1\u30fc\u30b8 MariaDB-compat.x86_64 0:10.3.11-1.el7.centos \u3092 \u975e\u63a8\u5968\r\n---&gt; \u30d1\u30c3\u30b1\u30fc\u30b8 boost-program-options.x86_64 0:1.53.0-27.amzn2.0.3 \u3092 \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\r\n---&gt; \u30d1\u30c3\u30b1\u30fc\u30b8 mariadb-libs.x86_64 1:5.5.60-1.amzn2 \u3092 \u4e0d\u8981\r\n---&gt; \u30d1\u30c3\u30b1\u30fc\u30b8 perl-PlRPC.noarch 0:0.2020-14.amzn2 \u3092 \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\r\n--&gt; \u4f9d\u5b58\u6027\u306e\u51e6\u7406\u3092\u3057\u3066\u3044\u307e\u3059: perl(Net::Daemon) &gt;= 0.13 \u306e\u30d1\u30c3\u30b1\u30fc\u30b8: perl-PlRPC-0.2020-14.amzn2.noarch\r\n--&gt; \u4f9d\u5b58\u6027\u306e\u51e6\u7406\u3092\u3057\u3066\u3044\u307e\u3059: perl(Net::Daemon::Test) \u306e\u30d1\u30c3\u30b1\u30fc\u30b8: perl-PlRPC-0.2020-14.amzn2.noarch\r\n--&gt; \u4f9d\u5b58\u6027\u306e\u51e6\u7406\u3092\u3057\u3066\u3044\u307e\u3059: perl(Net::Daemon::Log) \u306e\u30d1\u30c3\u30b1\u30fc\u30b8: perl-PlRPC-0.2020-14.amzn2.noarch\r\n--&gt; \u4f9d\u5b58\u6027\u306e\u51e6\u7406\u3092\u3057\u3066\u3044\u307e\u3059: perl(Compress::Zlib) \u306e\u30d1\u30c3\u30b1\u30fc\u30b8: perl-PlRPC-0.2020-14.amzn2.noarch\r\n--&gt; \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u78ba\u8a8d\u3092\u5b9f\u884c\u3057\u3066\u3044\u307e\u3059\u3002\r\n---&gt; \u30d1\u30c3\u30b1\u30fc\u30b8 perl-IO-Compress.noarch 0:2.061-2.amzn2 \u3092 \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\r\n--&gt; \u4f9d\u5b58\u6027\u306e\u51e6\u7406\u3092\u3057\u3066\u3044\u307e\u3059: perl(Compress::Raw::Zlib) &gt;= 2.061 \u306e\u30d1\u30c3\u30b1\u30fc\u30b8: perl-IO-Compress-2.061-2.amzn2.noarch\r\n--&gt; \u4f9d\u5b58\u6027\u306e\u51e6\u7406\u3092\u3057\u3066\u3044\u307e\u3059: perl(Compress::Raw::Bzip2) &gt;= 2.061 \u306e\u30d1\u30c3\u30b1\u30fc\u30b8: perl-IO-Compress-2.061-2.amzn2.noarch\r\n---&gt; \u30d1\u30c3\u30b1\u30fc\u30b8 perl-Net-Daemon.noarch 0:0.48-5.amzn2 \u3092 \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\r\n--&gt; \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u78ba\u8a8d\u3092\u5b9f\u884c\u3057\u3066\u3044\u307e\u3059\u3002\r\n---&gt; \u30d1\u30c3\u30b1\u30fc\u30b8 perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.amzn2.0.2 \u3092 \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\r\n---&gt; \u30d1\u30c3\u30b1\u30fc\u30b8 perl-Compress-Raw-Zlib.x86_64 1:2.061-4.amzn2.0.2 \u3092 \u30a4\u30f3\u30b9\u30c8\u30fc \u30eb\r\n--&gt; \u4f9d\u5b58\u6027\u89e3\u6c7a\u3092\u7d42\u4e86\u3057\u307e\u3057\u305f\u3002\r\n\r\n\u4f9d\u5b58\u6027\u3092\u89e3\u6c7a\u3057\u307e\u3057\u305f\r\n\r\n================================================================================\r\n Package                  \u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u30fc\r\n                                  \u30d0\u30fc\u30b8\u30e7\u30f3                  \u30ea\u30dd\u30b8\u30c8\u30ea\u30fc\r\n                                                                           \u5bb9\u91cf\r\n================================================================================\r\n\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d:\r\n MariaDB-client           x86_64  10.3.11-1.el7.centos        mariadb      53 M\r\n MariaDB-compat           x86_64  10.3.11-1.el7.centos        mariadb     2.8 M\r\n     mariadb-libs.x86_64 1:5.5.60-1.amzn2 \u3092\u5165\u308c\u66ff\u3048\u307e\u3059\r\n MariaDB-server           x86_64  10.3.11-1.el7.centos        mariadb     123 M\r\n\u4f9d\u5b58\u6027\u95a2\u9023\u3067\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3092\u3057\u307e\u3059:\r\n MariaDB-common           x86_64  10.3.11-1.el7.centos        mariadb     157 k\r\n boost-program-options    x86_64  1.53.0-27.amzn2.0.3         amzn2-core  163 k\r\n galera                   x86_64  25.3.24-1.rhel7.el7.centos  mariadb     8.1 M\r\n ncurses-compat-libs      x86_64  6.0-8.20170212.amzn2.1.2    amzn2-core  314 k\r\n perl-Compress-Raw-Bzip2  x86_64  2.061-3.amzn2.0.2           amzn2-core   32 k\r\n perl-Compress-Raw-Zlib   x86_64  1:2.061-4.amzn2.0.2         amzn2-core   58 k\r\n perl-DBI                 x86_64  1.627-4.amzn2.0.2           amzn2-core  804 k\r\n perl-Data-Dumper         x86_64  2.145-3.amzn2.0.2           amzn2-core   48 k\r\n perl-IO-Compress         noarch  2.061-2.amzn2               amzn2-core  260 k\r\n perl-Net-Daemon          noarch  0.48-5.amzn2                amzn2-core   51 k\r\n perl-PlRPC               noarch  0.2020-14.amzn2             amzn2-core   36 k\r\n\r\n\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u8981\u7d04\r\n================================================================================\r\n\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb  3 \u30d1\u30c3\u30b1\u30fc\u30b8 (+11 \u500b\u306e\u4f9d\u5b58\u95a2\u4fc2\u306e\u30d1\u30c3\u30b1\u30fc\u30b8)\r\n\r\n\u7dcf\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u5bb9\u91cf: 189 M\r\nIs this ok [y\/d\/N]: y\r\nDownloading packages:\r\n\u8b66\u544a: \/var\/cache\/yum\/x86_64\/2\/mariadb\/packages\/MariaDB-10.3.11-centos73-x86_64-common.rpm: \u30d8\u30c3\u30c0\u30fc V4 DSA\/SHA1 Signature\u3001\u9375 ID 1bb943db: NOKEY\r\nMariaDB-10.3.11-centos73-x86_64-common.rpm \u306e\u516c\u958b\u9375\u304c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3044\u307e\u305b\u3093\r\n(1\/14): MariaDB-10.3.11-centos73-x86_64-common.rpm         | 157 kB   00:01\r\n(2\/14): MariaDB-10.3.11-centos73-x86_64-compat.rpm         | 2.8 MB   00:04\r\n(3\/14): boost-program-options-1.53.0-27.amzn2.0.3.x86_64.r | 163 kB   00:00\r\n(4\/14): MariaDB-10.3.11-centos73-x86_64-client.rpm         |  53 MB   00:29\r\n(5\/14): ncurses-compat-libs-6.0-8.20170212.amzn2.1.2.x86_6 | 314 kB   00:00\r\n(6\/14): perl-Compress-Raw-Bzip2-2.061-3.amzn2.0.2.x86_64.r |  32 kB   00:00\r\n(7\/14): perl-Compress-Raw-Zlib-2.061-4.amzn2.0.2.x86_64.rp |  58 kB   00:00\r\n(8\/14): perl-Data-Dumper-2.145-3.amzn2.0.2.x86_64.rpm      |  48 kB   00:00\r\n(9\/14): perl-DBI-1.627-4.amzn2.0.2.x86_64.rpm              | 804 kB   00:00\r\n(10\/14): perl-Net-Daemon-0.48-5.amzn2.noarch.rpm           |  51 kB   00:00\r\n(11\/14): perl-IO-Compress-2.061-2.amzn2.noarch.rpm         | 260 kB   00:00\r\n(12\/14): perl-PlRPC-0.2020-14.amzn2.noarch.rpm             |  36 kB   00:00\r\n(13\/14): MariaDB-10.3.11-centos73-x86_64-server.rpm        | 123 MB   00:26\r\n(14\/14): galera-25.3.24-1.rhel7.el7.centos.x86_64.rpm      | 8.1 MB   00:03\r\n--------------------------------------------------------------------------------\r\n\u5408\u8a08                                               5.7 MB\/s | 189 MB  00:32\r\nhttps:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB \u304b\u3089\u9375\u3092\u53d6\u5f97\u4e2d\u3067\u3059\u3002\r\nImporting GPG key 0x1BB943DB:\r\n Userid     : \"MariaDB Package Signing Key &lt;package-signing-key@mariadb.org&gt;\"\r\n Fingerprint: 1993 69e5 404b d5fc 7d2f e43b cbcb 082a 1bb9 43db\r\n From       : https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB\r\n\u4e0a\u8a18\u306e\u51e6\u7406\u3092\u884c\u3044\u307e\u3059\u3002\u3088\u308d\u3057\u3044\u3067\u3057\u3087\u3046\u304b\uff1f [y\/N]y\r\nRunning transaction check\r\nRunning transaction test\r\nTransaction test succeeded\r\nRunning transaction\r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d          : MariaDB-compat-10.3.11-1.el7.centos.x86_64     1\/15\r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d          : MariaDB-common-10.3.11-1.el7.centos.x86_64     2\/15\r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d          : perl-Data-Dumper-2.145-3.amzn2.0.2.x86_64      3\/15\r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d          : perl-Compress-Raw-Bzip2-2.061-3.amzn2.0.2.x    4\/15\r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d          : ncurses-compat-libs-6.0-8.20170212.amzn2.1.    5\/15\r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d          : MariaDB-client-10.3.11-1.el7.centos.x86_64     6\/15\r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d          : boost-program-options-1.53.0-27.amzn2.0.3.x    7\/15\r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d          : galera-25.3.24-1.rhel7.el7.centos.x86_64       8\/15\r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d          : perl-Net-Daemon-0.48-5.amzn2.noarch            9\/15\r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d          : 1:perl-Compress-Raw-Zlib-2.061-4.amzn2.0.2.   10\/15\r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d          : perl-IO-Compress-2.061-2.amzn2.noarch         11\/15\r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d          : perl-PlRPC-0.2020-14.amzn2.noarch             12\/15\r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d          : perl-DBI-1.627-4.amzn2.0.2.x86_64             13\/15\r\n  \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e2d          : MariaDB-server-10.3.11-1.el7.centos.x86_64    14\/15\r\nchown: \u30e6\u30fc\u30b6\u6307\u5b9a\u304c\u4e0d\u6b63: `mysql'\r\n\r\n\r\nPLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !\r\nTo do so, start the server, then issue the following commands:\r\n\r\n'\/usr\/bin\/mysqladmin' -u root password 'new-password'\r\n'\/usr\/bin\/mysqladmin' -u root -h ip-172-31-23-119.ap-northeast-1.compute.internal password 'new-password'\r\n\r\nAlternatively you can run:\r\n'\/usr\/bin\/mysql_secure_installation'\r\n\r\nwhich will also give you the option of removing the test\r\ndatabases and anonymous user created by default.  This is\r\nstrongly recommended for production servers.\r\n\r\nSee the MariaDB Knowledgebase at http:\/\/mariadb.com\/kb or the\r\nMySQL manual for more instructions.\r\n\r\nPlease report any problems at http:\/\/mariadb.org\/jira\r\n\r\nThe latest information about MariaDB is available at http:\/\/mariadb.org\/.\r\nYou can find additional information about the MySQL part at:\r\nhttp:\/\/dev.mysql.com\r\nConsider joining MariaDB's strong and vibrant community:\r\n<blockquote class=\"wp-embedded-content\" data-secret=\"N1iDDgQphG\"><a href=\"https:\/\/mariadb.org\/get-involved\/\">Get Involved<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;Get Involved&#8221; &#8212; MariaDB.org\" src=\"https:\/\/mariadb.org\/get-involved\/embed\/#?secret=dgruQxHdIo#?secret=N1iDDgQphG\" data-secret=\"N1iDDgQphG\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\r\n\r\n  \u524a\u9664\u4e2d                  : 1:mariadb-libs-5.5.60-1.amzn2.x86_64          15\/15\r\n  \u691c\u8a3c\u4e2d                  : MariaDB-common-10.3.11-1.el7.centos.x86_64     1\/15\r\n  \u691c\u8a3c\u4e2d                  : 1:perl-Compress-Raw-Zlib-2.061-4.amzn2.0.2.    2\/15\r\n  \u691c\u8a3c\u4e2d                  : perl-IO-Compress-2.061-2.amzn2.noarch          3\/15\r\n  \u691c\u8a3c\u4e2d                  : perl-Net-Daemon-0.48-5.amzn2.noarch            4\/15\r\n  \u691c\u8a3c\u4e2d                  : MariaDB-client-10.3.11-1.el7.centos.x86_64     5\/15\r\n  \u691c\u8a3c\u4e2d                  : perl-Data-Dumper-2.145-3.amzn2.0.2.x86_64      6\/15\r\n  \u691c\u8a3c\u4e2d                  : galera-25.3.24-1.rhel7.el7.centos.x86_64       7\/15\r\n  \u691c\u8a3c\u4e2d                  : MariaDB-compat-10.3.11-1.el7.centos.x86_64     8\/15\r\n  \u691c\u8a3c\u4e2d                  : boost-program-options-1.53.0-27.amzn2.0.3.x    9\/15\r\n  \u691c\u8a3c\u4e2d                  : MariaDB-server-10.3.11-1.el7.centos.x86_64    10\/15\r\n  \u691c\u8a3c\u4e2d                  : ncurses-compat-libs-6.0-8.20170212.amzn2.1.   11\/15\r\n  \u691c\u8a3c\u4e2d                  : perl-Compress-Raw-Bzip2-2.061-3.amzn2.0.2.x   12\/15\r\n  \u691c\u8a3c\u4e2d                  : perl-DBI-1.627-4.amzn2.0.2.x86_64             13\/15\r\n  \u691c\u8a3c\u4e2d                  : perl-PlRPC-0.2020-14.amzn2.noarch             14\/15\r\n  \u691c\u8a3c\u4e2d                  : 1:mariadb-libs-5.5.60-1.amzn2.x86_64          15\/15\r\n\r\n\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb:\r\n  MariaDB-client.x86_64 0:10.3.11-1.el7.centos\r\n  MariaDB-compat.x86_64 0:10.3.11-1.el7.centos\r\n  MariaDB-server.x86_64 0:10.3.11-1.el7.centos\r\n\r\n\u4f9d\u5b58\u6027\u95a2\u9023\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3057\u305f:\r\n  MariaDB-common.x86_64 0:10.3.11-1.el7.centos\r\n  boost-program-options.x86_64 0:1.53.0-27.amzn2.0.3\r\n  galera.x86_64 0:25.3.24-1.rhel7.el7.centos\r\n  ncurses-compat-libs.x86_64 0:6.0-8.20170212.amzn2.1.2\r\n  perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.amzn2.0.2\r\n  perl-Compress-Raw-Zlib.x86_64 1:2.061-4.amzn2.0.2\r\n  perl-DBI.x86_64 0:1.627-4.amzn2.0.2\r\n  perl-Data-Dumper.x86_64 0:2.145-3.amzn2.0.2\r\n  perl-IO-Compress.noarch 0:2.061-2.amzn2\r\n  perl-Net-Daemon.noarch 0:0.48-5.amzn2\r\n  perl-PlRPC.noarch 0:0.2020-14.amzn2\r\n\r\n\u7f6e\u63db:\r\n  mariadb-libs.x86_64 1:5.5.60-1.amzn2\r\n\r\n\u5b8c\u4e86\u3057\u307e\u3057\u305f!\r\n<\/code><\/pre>\n<p>\u670d\u52a1\u5f00\u59cb\u3002<\/p>\n<pre class=\"post-pre\"><code># sudo systemctl start mariadb\r\n<\/code><\/pre>\n<p>\u8bbe\u5b9a\u670d\u52a1\u7684\u81ea\u52a8\u542f\u52a8\u3002<\/p>\n<pre class=\"post-pre\"><code># sudo systemctl enable mariadb\r\n<\/code><\/pre>\n<p>\u8fde\u63a5\u5230\u6570\u636e\u5e93\u3002<\/p>\n<pre class=\"post-pre\"><code># mysql\r\nERROR 2002 (HY000): Can't connect to local MySQL server through socket '\/var\/lib\/mysql\/mysql.sock' (2)\r\n<\/code><\/pre>\n<p>\u7531\u4e8e\u6ca1\u6709\u627e\u5230 socket \u6587\u4ef6\uff0c\u53d1\u751f\u4e86\u9519\u8bef\u3002\u901a\u5e38\u60c5\u51b5\u4e0b\uff0c\u91cd\u65b0\u542f\u52a8\u670d\u52a1\u4f1a\u521b\u5efa socket \u6587\u4ef6\u3002\u5728\u8fd9\u6b21\u91cd\u65b0\u542f\u52a8\u540e\uff0csocket \u6587\u4ef6\u88ab\u6210\u529f\u521b\u5efa\u3002<\/p>\n<p>\u6211\u5c06\u5c1d\u8bd5\u91cd\u65b0\u8fde\u63a5\u3002\u7cfb\u7edf\u4f1a\u8981\u6c42\u8f93\u5165\u5bc6\u7801\uff0c\u4f46\u60a8\u53ef\u4ee5\u76f4\u63a5\u6309Enter\u952e\u8df3\u8fc7\u3002<\/p>\n<pre class=\"post-pre\"><code># mysql\r\n\r\nWelcome to the MariaDB monitor.  Commands end with ; or \\g.\r\nYour MariaDB connection id is 8\r\nServer version: 10.3.11-MariaDB MariaDB Server\r\n\r\nCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\nMariaDB [(none)]&gt;\r\n<\/code><\/pre>\n<h2>\u8fdb\u884c\u521d\u59cb\u8bbe\u5b9a<br \/>\n\u6211\u4eec\u5c06\u4f7f\u7528mysql_secure_installation\u8fdb\u884c\u521d\u59cb\u8bbe\u7f6e\u3002\u672c\u6b21\u6211\u4eec\u5c06\u5c06\u5bc6\u7801\u8bbe\u7f6e\u4e3amysql\u3002<br \/>\n\u53c2\u8003\uff1amysql_secure_installation<\/p>\n<blockquote><p>\u60a8\u53ef\u4ee5\u8bbe\u7f6eroot\u8d26\u6237\u7684\u5bc6\u7801\u3002<br \/>\n\u60a8\u53ef\u4ee5\u5220\u9664\u53ef\u4ee5\u4ece\u672c\u5730\u4e3b\u673a\u4ee5\u5916\u8bbf\u95ee\u7684root\u8d26\u6237\u3002<br \/>\n\u60a8\u53ef\u4ee5\u5220\u9664\u533f\u540d\u7528\u6237\u8d26\u6237\u3002<br \/>\n\u60a8\u53ef\u4ee5\u5220\u9664\u533f\u540d\u7528\u6237\u5bf9\u9ed8\u8ba4\u53ef\u8bbf\u95ee\u7684test\u6570\u636e\u5e93\u7684\u8bbf\u95ee\u6743\u9650\u3002<\/p><\/blockquote>\n<pre class=\"post-pre\"><code># mysql_secure_installation\r\n\r\nNOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB\r\n      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!\r\n\r\nIn order to log into MariaDB to secure it, we'll need the current\r\npassword for the root user.  If you've just installed MariaDB, and\r\nyou haven't set the root password yet, the password will be blank,\r\nso you should just press enter here.\r\n\r\nEnter current password for root (enter for none):\r\nOK, successfully used password, moving on...\r\n\r\nSetting the root password ensures that nobody can log into the MariaDB\r\nroot user without the proper authorisation.\r\n\r\nSet root password? [Y\/n] y\r\nNew password:\r\nRe-enter new password:\r\nPassword updated successfully!\r\nReloading privilege tables..\r\n ... Success!\r\n\r\n\r\nBy default, a MariaDB installation has an anonymous user, allowing anyone\r\nto log into MariaDB without having to have a user account created for\r\nthem.  This is intended only for testing, and to make the installation\r\ngo a bit smoother.  You should remove them before moving into a\r\nproduction environment.\r\n\r\nRemove anonymous users? [Y\/n] y\r\n ... Success!\r\n\r\nNormally, root should only be allowed to connect from 'localhost'.  This\r\nensures that someone cannot guess at the root password from the network.\r\n\r\nDisallow root login remotely? [Y\/n] y\r\n ... Success!\r\n\r\nBy default, MariaDB comes with a database named 'test' that anyone can\r\naccess.  This is also intended only for testing, and should be removed\r\nbefore moving into a production environment.\r\n\r\nRemove test database and access to it? [Y\/n] y\r\n - Dropping test database...\r\n ... Success!\r\n - Removing privileges on test database...\r\n ... Success!\r\n\r\nReloading the privilege tables will ensure that all changes made so far\r\nwill take effect immediately.\r\n\r\nReload privilege tables now? [Y\/n] y\r\n ... Success!\r\n\r\nCleaning up...\r\n\r\nAll done!  If you've completed all of the above steps, your MariaDB\r\ninstallation should now be secure.\r\n\r\nThanks for using MariaDB!\r\n<\/code><\/pre>\n<h2>\u521b\u5efa\u6837\u672c\u6570\u636e\u5e93\u8bf7\u4ece\u8fd9\u91cc\u4e0b\u8f7d sakila \u6570\u636e\u5e93\u7684\u538b\u7f29\u6587\u4ef6\uff0c\u5e76\u90e8\u7f72\u5230\u670d\u52a1\u5668\u4e0a\u3002\u672c\u6b21\u90e8\u7f72\u4e8e ec2-user \u7684 home \u76ee\u5f55\u4e0b\u3002\u7528 unzip \u6765\u89e3\u538b\u7f29\u3002<\/p>\n<pre class=\"post-pre\"><code># ls\r\nsakila-data.sql  sakila-schema.sql  sakila.mwb\r\n<\/code><\/pre>\n<p>\u6211\u8981\u8fde\u63a5\u5230MySQL\u6570\u636e\u5e93\u3002<\/p>\n<pre class=\"post-pre\"><code># mysql -u root -p\r\n\r\nEnter password:\r\nMariaDB [(none)]&gt;\r\n<\/code><\/pre>\n<p>\u8bf7\u6309\u7167 sakila-schema.sql \u548c sakila-data.sql \u7684\u987a\u5e8f\u6267\u884c\u3002<\/p>\n<pre class=\"post-pre\"><code>MariaDB [(none)]&gt; source \/home\/ec2-user\/sakila-db\/sakila-schema.sql;\r\nMariaDB [sakila]&gt; source \/home\/ec2-user\/sakila-db\/sakila-data.sql;\r\n<\/code><\/pre>\n<p>\u6211\u53ef\u4ee5\u7528\u8fd9\u4e2a\u6765\u6062\u590d\u6570\u636e\u5e93\u3002<br \/>\n\u6211\u6765\u770b\u770b\u6570\u636e\u5e93\u5217\u8868\uff0csakila\u5df2\u7ecf\u88ab\u6dfb\u52a0\u8fdb\u6765\u4e86\u3002<\/p>\n<pre class=\"post-pre\"><code>MariaDB [sakila]&gt; show databases;\r\n+--------------------+\r\n| Database           |\r\n+--------------------+\r\n| information_schema |\r\n| mysql              |\r\n| performance_schema |\r\n| sakila             |\r\n+--------------------+\r\n4 rows in set (0.000 sec)\r\n<\/code><\/pre>\n<p>\u6211\u4eec\u4e5f\u6765\u786e\u8ba4\u4e00\u4e0b\u684c\u5b50\u5427\u3002<\/p>\n<pre class=\"post-pre\"><code>MariaDB [sakila]&gt; show tables;\r\n+----------------------------+\r\n| Tables_in_sakila           |\r\n+----------------------------+\r\n| actor                      |\r\n| actor_info                 |\r\n| address                    |\r\n| category                   |\r\n| city                       |\r\n| country                    |\r\n| customer                   |\r\n| customer_list              |\r\n| film                       |\r\n| film_actor                 |\r\n| film_category              |\r\n| film_list                  |\r\n| film_text                  |\r\n| inventory                  |\r\n| language                   |\r\n| nicer_but_slower_film_list |\r\n| payment                    |\r\n| rental                     |\r\n| sales_by_film_category     |\r\n| sales_by_store             |\r\n| staff                      |\r\n| staff_list                 |\r\n| store                      |\r\n+----------------------------+\r\n23 rows in set (0.000 sec)\r\n<\/code><\/pre>\n<p>\u73b0\u5728\u6211\u4eec\u5df2\u7ecf\u6210\u529f\u6dfb\u52a0\u4e86\u793a\u4f8b\u6570\u636e\u5e93\u3002<\/p>\n<h2>\u5b89\u88c5Python\u6a21\u5757\u3002<br \/>\n\u5b89\u88c5\u7528\u4e8e\u8fde\u63a5MariaDB\uff08MySQL\uff09\u7684\u6a21\u5757\u3002<\/p>\n<p>\u5728conda\u4e2d\u5b89\u88c5pymysql\u3002<\/p>\n<pre class=\"post-pre\"><code># conda install pymysql\r\n\r\nSolving environment: done\r\n\r\n## Package Plan ##\r\n\r\n  environment location: \/root\/anaconda3\/envs\/py37\r\n\r\n  added \/ updated specs:\r\n    - pymysql\r\n\r\n\r\nThe following packages will be downloaded:\r\n\r\n    package                    |            build\r\n    ---------------------------|-----------------\r\n    pymysql-0.9.2              |           py36_0          82 KB\r\n    python-3.6.8               |       h0371630_0        34.4 MB\r\n    ------------------------------------------------------------\r\n                                           Total:        34.5 MB\r\n\r\nThe following NEW packages will be INSTALLED:\r\n\r\n    pymysql:         0.9.2-py36_0\r\n\r\nThe following packages will be UPDATED:\r\n\r\n    cryptography:    2.3.1-py36hdffb7b8_0    conda-forge --&gt; 2.4.2-py36h1ba5d50_0\r\n    curl:            7.63.0-h74213dd_0       conda-forge --&gt; 7.63.0-hbc83047_1000\r\n    grpcio:          1.16.0-py36hd60e7a3_0   conda-forge --&gt; 1.16.1-py36hf8bcb03_1\r\n    libarchive:      3.3.3-h823be47_0        conda-forge --&gt; 3.3.3-h5d8350f_5   \r\n    libcurl:         7.63.0-hbdb9355_0       conda-forge --&gt; 7.63.0-h20c2e04_1000\r\n    libpq:           10.6-he29860b_0         conda-forge --&gt; 11.1-h20c2e04_0    \r\n    libssh2:         1.8.0-h5b517e9_3        conda-forge --&gt; 1.8.0-h1ba5d50_4   \r\n    openssl:         1.0.2p-h470a237_1       conda-forge --&gt; 1.1.1a-h7b6447c_0  \r\n    psycopg2:        2.7.6.1-py36hdffb7b8_0  conda-forge --&gt; 2.7.6.1-py36h1ba5d50_0\r\n    pycurl:          7.43.0.2-py36hb7f436b_0             --&gt; 7.43.0.2-py36h1ba5d50_0\r\n    python:          3.6.6-h5001a0f_3        conda-forge --&gt; 3.6.8-h0371630_0   \r\n    qt:              5.9.6-h8703b6f_2                    --&gt; 5.9.7-h5867ecd_1   \r\n\r\nThe following packages will be DOWNGRADED:\r\n\r\n    ca-certificates: 2018.11.29-ha4d7672_0   conda-forge --&gt; 2018.03.07-0       \r\n    certifi:         2018.11.29-py36_1000    conda-forge --&gt; 2018.11.29-py36_0  \r\n    krb5:            1.16.2-hbb41f41_0       conda-forge --&gt; 1.16.1-h173b8e3_7  \r\n\r\nProceed ([y]\/n)? y\r\n\r\n\r\nDownloading and Extracting Packages\r\npymysql-0.9.2        | 82 KB     | ##################################### | 100%\r\npython-3.6.8         | 34.4 MB   | ##################################### | 100%\r\nPreparing transaction: done\r\nVerifying transaction: done\r\nExecuting transaction: done\r\n<\/code><\/pre>\n<p>\u7531\u4e8e\u6ca1\u6709conda\uff0c\u9700\u8981\u4f7f\u7528pip\u6765\u5b89\u88c5ipython-sql\u3002<\/p>\n<pre class=\"post-pre\"><code># pip install ipython-sql\r\n<\/code><\/pre>\n<h2>\u4f7f\u7528jupyter notebook\u8fdb\u884c\u6570\u636e\u5e93\u64cd\u4f5c\uff08pymysql\uff09\u3002<br \/>\n\u6211\u4f1a\u5efa\u7acb\u8fde\u63a5\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"kn\">import<\/span> <span class=\"nn\">pymysql<\/span>\r\n\r\n<span class=\"n\">conn<\/span> <span class=\"o\">=<\/span> <span class=\"n\">pymysql<\/span><span class=\"p\">.<\/span><span class=\"n\">connect<\/span><span class=\"p\">(<\/span>\r\n    <span class=\"n\">host<\/span> <span class=\"o\">=<\/span> <span class=\"s\">'localhost'<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">port<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">3306<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">user<\/span> <span class=\"o\">=<\/span> <span class=\"s\">'root'<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">passwd<\/span> <span class=\"o\">=<\/span> <span class=\"s\">'mysql'<\/span><span class=\"p\">,<\/span>\r\n    <span class=\"n\">db<\/span> <span class=\"o\">=<\/span> <span class=\"s\">'sakila'<\/span><span class=\"p\">)<\/span>\r\n<\/code><\/pre>\n<p>\u6211\u8981\u6267\u884cselect\u8bed\u53e5\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"n\">cursor<\/span> <span class=\"o\">=<\/span> <span class=\"n\">conn<\/span><span class=\"p\">.<\/span><span class=\"n\">cursor<\/span><span class=\"p\">()<\/span>\r\n<span class=\"n\">cursor<\/span><span class=\"p\">.<\/span><span class=\"n\">execute<\/span><span class=\"p\">(<\/span><span class=\"s\">\"SELECT * FROM city\"<\/span><span class=\"p\">)<\/span>\r\n<span class=\"n\">results<\/span> <span class=\"o\">=<\/span> <span class=\"n\">cursor<\/span><span class=\"p\">.<\/span><span class=\"n\">fetchall<\/span><span class=\"p\">()<\/span>\r\n\r\n<span class=\"k\">for<\/span> <span class=\"n\">row<\/span> <span class=\"ow\">in<\/span> <span class=\"n\">results<\/span><span class=\"p\">:<\/span>\r\n  <span class=\"k\">print<\/span><span class=\"p\">(<\/span><span class=\"n\">row<\/span><span class=\"p\">)<\/span>\r\n\r\n<span class=\"n\">conn<\/span><span class=\"p\">.<\/span><span class=\"n\">commit<\/span><span class=\"p\">()<\/span>\r\n<span class=\"n\">cursor<\/span><span class=\"p\">.<\/span><span class=\"n\">close<\/span><span class=\"p\">()<\/span>\r\n\r\n<span class=\"c1\"># \u4ee5\u4e0b\u51fa\u529b\r\n<\/span><span class=\"p\">(<\/span><span class=\"mi\">1<\/span><span class=\"p\">,<\/span> <span class=\"s\">'A Corua (La Corua)'<\/span><span class=\"p\">,<\/span> <span class=\"mi\">87<\/span><span class=\"p\">,<\/span> <span class=\"n\">datetime<\/span><span class=\"p\">.<\/span><span class=\"n\">datetime<\/span><span class=\"p\">(<\/span><span class=\"mi\">2006<\/span><span class=\"p\">,<\/span> <span class=\"mi\">2<\/span><span class=\"p\">,<\/span> <span class=\"mi\">15<\/span><span class=\"p\">,<\/span> <span class=\"mi\">4<\/span><span class=\"p\">,<\/span> <span class=\"mi\">45<\/span><span class=\"p\">,<\/span> <span class=\"mi\">25<\/span><span class=\"p\">))<\/span>\r\n<span class=\"p\">(<\/span><span class=\"mi\">2<\/span><span class=\"p\">,<\/span> <span class=\"s\">'Abha'<\/span><span class=\"p\">,<\/span> <span class=\"mi\">82<\/span><span class=\"p\">,<\/span> <span class=\"n\">datetime<\/span><span class=\"p\">.<\/span><span class=\"n\">datetime<\/span><span class=\"p\">(<\/span><span class=\"mi\">2006<\/span><span class=\"p\">,<\/span> <span class=\"mi\">2<\/span><span class=\"p\">,<\/span> <span class=\"mi\">15<\/span><span class=\"p\">,<\/span> <span class=\"mi\">4<\/span><span class=\"p\">,<\/span> <span class=\"mi\">45<\/span><span class=\"p\">,<\/span> <span class=\"mi\">25<\/span><span class=\"p\">))<\/span>\r\n<span class=\"p\">(<\/span><span class=\"mi\">3<\/span><span class=\"p\">,<\/span> <span class=\"s\">'Abu Dhabi'<\/span><span class=\"p\">,<\/span> <span class=\"mi\">101<\/span><span class=\"p\">,<\/span> <span class=\"n\">datetime<\/span><span class=\"p\">.<\/span><span class=\"n\">datetime<\/span><span class=\"p\">(<\/span><span class=\"mi\">2006<\/span><span class=\"p\">,<\/span> <span class=\"mi\">2<\/span><span class=\"p\">,<\/span> <span class=\"mi\">15<\/span><span class=\"p\">,<\/span> <span class=\"mi\">4<\/span><span class=\"p\">,<\/span> <span class=\"mi\">45<\/span><span class=\"p\">,<\/span> <span class=\"mi\">25<\/span><span class=\"p\">))<\/span>\r\n<span class=\"p\">(<\/span><span class=\"mi\">4<\/span><span class=\"p\">,<\/span> <span class=\"s\">'Acua'<\/span><span class=\"p\">,<\/span> <span class=\"mi\">60<\/span><span class=\"p\">,<\/span> <span class=\"n\">datetime<\/span><span class=\"p\">.<\/span><span class=\"n\">datetime<\/span><span class=\"p\">(<\/span><span class=\"mi\">2006<\/span><span class=\"p\">,<\/span> <span class=\"mi\">2<\/span><span class=\"p\">,<\/span> <span class=\"mi\">15<\/span><span class=\"p\">,<\/span> <span class=\"mi\">4<\/span><span class=\"p\">,<\/span> <span class=\"mi\">45<\/span><span class=\"p\">,<\/span> <span class=\"mi\">25<\/span><span class=\"p\">))<\/span>\r\n<span class=\"p\">(<\/span><span class=\"mi\">5<\/span><span class=\"p\">,<\/span> <span class=\"s\">'Adana'<\/span><span class=\"p\">,<\/span> <span class=\"mi\">97<\/span><span class=\"p\">,<\/span> <span class=\"n\">datetime<\/span><span class=\"p\">.<\/span><span class=\"n\">datetime<\/span><span class=\"p\">(<\/span><span class=\"mi\">2006<\/span><span class=\"p\">,<\/span> <span class=\"mi\">2<\/span><span class=\"p\">,<\/span> <span class=\"mi\">15<\/span><span class=\"p\">,<\/span> <span class=\"mi\">4<\/span><span class=\"p\">,<\/span> <span class=\"mi\">45<\/span><span class=\"p\">,<\/span> <span class=\"mi\">25<\/span><span class=\"p\">))<\/span>\r\n<span class=\"p\">(<\/span><span class=\"mi\">6<\/span><span class=\"p\">,<\/span> <span class=\"s\">'Addis Abeba'<\/span><span class=\"p\">,<\/span> <span class=\"mi\">31<\/span><span class=\"p\">,<\/span> <span class=\"n\">datetime<\/span><span class=\"p\">.<\/span><span class=\"n\">datetime<\/span><span class=\"p\">(<\/span><span class=\"mi\">2006<\/span><span class=\"p\">,<\/span> <span class=\"mi\">2<\/span><span class=\"p\">,<\/span> <span class=\"mi\">15<\/span><span class=\"p\">,<\/span> <span class=\"mi\">4<\/span><span class=\"p\">,<\/span> <span class=\"mi\">45<\/span><span class=\"p\">,<\/span> <span class=\"mi\">25<\/span><span class=\"p\">))<\/span>\r\n<span class=\"p\">(<\/span><span class=\"mi\">7<\/span><span class=\"p\">,<\/span> <span class=\"s\">'Aden'<\/span><span class=\"p\">,<\/span> <span class=\"mi\">107<\/span><span class=\"p\">,<\/span> <span class=\"n\">datetime<\/span><span class=\"p\">.<\/span><span class=\"n\">datetime<\/span><span class=\"p\">(<\/span><span class=\"mi\">2006<\/span><span class=\"p\">,<\/span> <span class=\"mi\">2<\/span><span class=\"p\">,<\/span> <span class=\"mi\">15<\/span><span class=\"p\">,<\/span> <span class=\"mi\">4<\/span><span class=\"p\">,<\/span> <span class=\"mi\">45<\/span><span class=\"p\">,<\/span> <span class=\"mi\">25<\/span><span class=\"p\">))<\/span>\r\n<span class=\"p\">(<\/span><span class=\"mi\">8<\/span><span class=\"p\">,<\/span> <span class=\"s\">'Adoni'<\/span><span class=\"p\">,<\/span> <span class=\"mi\">44<\/span><span class=\"p\">,<\/span> <span class=\"n\">datetime<\/span><span class=\"p\">.<\/span><span class=\"n\">datetime<\/span><span class=\"p\">(<\/span><span class=\"mi\">2006<\/span><span class=\"p\">,<\/span> <span class=\"mi\">2<\/span><span class=\"p\">,<\/span> <span class=\"mi\">15<\/span><span class=\"p\">,<\/span> <span class=\"mi\">4<\/span><span class=\"p\">,<\/span> <span class=\"mi\">45<\/span><span class=\"p\">,<\/span> <span class=\"mi\">25<\/span><span class=\"p\">))<\/span>\r\n<span class=\"p\">(<\/span><span class=\"mi\">9<\/span><span class=\"p\">,<\/span> <span class=\"s\">'Ahmadnagar'<\/span><span class=\"p\">,<\/span> <span class=\"mi\">44<\/span><span class=\"p\">,<\/span> <span class=\"n\">datetime<\/span><span class=\"p\">.<\/span><span class=\"n\">datetime<\/span><span class=\"p\">(<\/span><span class=\"mi\">2006<\/span><span class=\"p\">,<\/span> <span class=\"mi\">2<\/span><span class=\"p\">,<\/span> <span class=\"mi\">15<\/span><span class=\"p\">,<\/span> <span class=\"mi\">4<\/span><span class=\"p\">,<\/span> <span class=\"mi\">45<\/span><span class=\"p\">,<\/span> <span class=\"mi\">25<\/span><span class=\"p\">))<\/span>\r\n<span class=\"p\">(<\/span><span class=\"mi\">10<\/span><span class=\"p\">,<\/span> <span class=\"s\">'Akishima'<\/span><span class=\"p\">,<\/span> <span class=\"mi\">50<\/span><span class=\"p\">,<\/span> <span class=\"n\">datetime<\/span><span class=\"p\">.<\/span><span class=\"n\">datetime<\/span><span class=\"p\">(<\/span><span class=\"mi\">2006<\/span><span class=\"p\">,<\/span> <span class=\"mi\">2<\/span><span class=\"p\">,<\/span> <span class=\"mi\">15<\/span><span class=\"p\">,<\/span> <span class=\"mi\">4<\/span><span class=\"p\">,<\/span> <span class=\"mi\">45<\/span><span class=\"p\">,<\/span> <span class=\"mi\">25<\/span><span class=\"p\">))<\/span>\r\n<span class=\"p\">...<\/span>\r\n<\/code><\/pre>\n<p>\u5728Pandas\u4e2d\u7684pd.read_sql_query\u51fd\u6570\u53ef\u4ee5\u5c06\u67e5\u8be2\u7ed3\u679c\u8f6c\u6362\u4e3a\u6570\u636e\u6846\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"kn\">import<\/span> <span class=\"nn\">pandas<\/span> <span class=\"k\">as<\/span> <span class=\"n\">pd<\/span>\r\n\r\n<span class=\"n\">df<\/span> <span class=\"o\">=<\/span> <span class=\"n\">pd<\/span><span class=\"p\">.<\/span><span class=\"n\">read_sql_query<\/span><span class=\"p\">(<\/span><span class=\"s\">\"SELECT * FROM city\"<\/span><span class=\"p\">,<\/span> <span class=\"n\">conn<\/span><span class=\"p\">)<\/span>\r\n<span class=\"n\">df<\/span><span class=\"p\">.<\/span><span class=\"n\">head<\/span><span class=\"p\">(<\/span><span class=\"mi\">10<\/span><span class=\"p\">)<\/span>\r\n<\/code><\/pre>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657cfd3837434c4406bc218e\/58-0.png\" alt=\"image.png\" \/><\/p>\n<h2>\u4f7f\u7528Jupyter Notebook\u64cd\u4f5c\u6570\u636e\u5e93\uff08ipython-sql\uff09\u3002\u5982\u679c\u60f3\u66f4\u76f4\u63a5\u5730\u7f16\u5199SQL\uff0c\u53ef\u4ee5\u4f7f\u7528\u9b54\u672f\u547d\u4ee4\u3002\u901a\u8fc7%load_ext sql\u53ef\u4ee5\u6269\u5c55SQL\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"o\">%<\/span><span class=\"n\">load_ext<\/span> <span class=\"n\">sql<\/span>\r\n<span class=\"c1\"># dsl = 'mysql+pymysql:\/\/{user}:{password}@{host}:{port}\/{database}'.format(**pgconfig)\r\n<\/span><span class=\"n\">dsl<\/span> <span class=\"o\">=<\/span> <span class=\"s\">'mysql+pymysql:\/\/root:mysql@localhost:3306\/sakila?charset=utf8mb4'<\/span><span class=\"p\">.<\/span><span class=\"nb\">format<\/span><span class=\"p\">(<\/span><span class=\"o\">**<\/span><span class=\"n\">pgconfig<\/span><span class=\"p\">)<\/span>\r\n<span class=\"o\">%<\/span><span class=\"n\">sql<\/span> <span class=\"err\">$<\/span><span class=\"n\">dsl<\/span>\r\n\r\n<span class=\"c1\"># \u4ee5\u4e0b\u306f\u51fa\u529b\r\n<\/span><span class=\"s\">'Connected: root@sakila'<\/span>\r\n<\/code><\/pre>\n<p>select\u8bed\u53e5\u53ef\u5982\u4e0b\u5199\uff1a<\/p>\n<pre class=\"post-pre\"><code><span class=\"o\">%%<\/span><span class=\"k\">sql<\/span>\r\n<span class=\"k\">select<\/span> <span class=\"o\">*<\/span> <span class=\"k\">from<\/span> <span class=\"n\">actor<\/span> <span class=\"k\">order<\/span> <span class=\"k\">by<\/span> <span class=\"n\">actor_id<\/span> <span class=\"k\">limit<\/span> <span class=\"mi\">10<\/span>\r\n\r\n<span class=\"o\">#<\/span> <span class=\"err\">\u4ee5\u4e0b\u306f\u51fa\u529b<\/span>\r\n <span class=\"o\">*<\/span> <span class=\"n\">mysql<\/span><span class=\"o\">+<\/span><span class=\"n\">pymysql<\/span><span class=\"p\">:<\/span><span class=\"o\">\/\/<\/span><span class=\"n\">root<\/span><span class=\"p\">:<\/span><span class=\"o\">***@<\/span><span class=\"n\">localhost<\/span><span class=\"p\">:<\/span><span class=\"mi\">3306<\/span><span class=\"o\">\/<\/span><span class=\"n\">sakila<\/span><span class=\"o\">?<\/span><span class=\"n\">charset<\/span><span class=\"o\">=<\/span><span class=\"n\">utf8mb4<\/span>\r\n<span class=\"mi\">10<\/span> <span class=\"k\">rows<\/span> <span class=\"n\">affected<\/span><span class=\"p\">.<\/span>\r\n<\/code><\/pre>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657cfd3837434c4406bc218e\/64-0.png\" alt=\"image.png\" \/>\u987a\u4fbf\u8bf4\u4e00\u4e0b\uff0c\u6267\u884c\u7ed3\u679c\u88ab\u5b58\u50a8\u5728_\u4e2d\u3002<br \/>\n\u5176\u7c7b\u578b\u662fsql.run.ResultSet\u3002<\/p>\n<p>\u5f53\u7136\u4e5f\u53ef\u4ee5\u5c06\u5176\u5b58\u50a8\u5728\u53d8\u91cf\u4e2d\u3002\u4e24\u4e2a\u767e\u5206\u53f7\u5c06\u53d8\u4e3a\u4e00\u4e2a\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"n\">result<\/span> <span class=\"o\">=<\/span> <span class=\"o\">%<\/span><span class=\"n\">sql<\/span> <span class=\"n\">select<\/span> <span class=\"o\">*<\/span> <span class=\"k\">from<\/span> <span class=\"n\">actor<\/span> <span class=\"n\">order<\/span> <span class=\"n\">by<\/span> <span class=\"n\">actor_id<\/span> <span class=\"n\">limit<\/span> <span class=\"mi\">10<\/span>\r\n<\/code><\/pre>\n<p>\u53ef\u4ee5\u4f7f\u7528.DataFrame()\u5c06\u5176\u8f6c\u6362\u4e3a\u6570\u636e\u5e27\u3002<\/p>\n<pre class=\"post-pre\"><code>result.DataFrame()\r\n<\/code><\/pre>\n<p>\u6216\u8005\u901a\u8fc7\u5199\u4e0b\u8ff0\u5185\u5bb9\uff0c\u53ef\u4ee5\u81ea\u52a8\u5c06\u5176\u8f6c\u6362\u4e3apandas\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"o\">%<\/span><span class=\"n\">config<\/span> <span class=\"n\">SqlMagic<\/span><span class=\"p\">.<\/span><span class=\"n\">autopandas<\/span> <span class=\"o\">=<\/span> <span class=\"bp\">True<\/span>\r\n\r\n<span class=\"n\">df<\/span> <span class=\"o\">=<\/span> <span class=\"o\">%<\/span><span class=\"n\">sql<\/span> <span class=\"n\">select<\/span> <span class=\"o\">*<\/span> <span class=\"k\">from<\/span> <span class=\"n\">actor<\/span> <span class=\"n\">order<\/span> <span class=\"n\">by<\/span> <span class=\"n\">actor_id<\/span>\r\n<span class=\"nb\">type<\/span><span class=\"p\">(<\/span><span class=\"n\">df<\/span><span class=\"p\">)<\/span>\r\n<\/code><\/pre>\n<h2>\u5176\u4ed6\u6307\u4ee4\u53ef\u4ee5\u63a5\u53d7\u6570\u636e\u5e93\u64cd\u4f5c\u548c\u8868\u64cd\u4f5c\u3002<\/p>\n<p>\u663e\u793a\u6570\u636e\u5e93\u5217\u8868\u3002<\/p>\n<pre class=\"post-pre\"><code>%%sql\r\nshow databases;\r\n<\/code><\/pre>\n<p>\u663e\u793a\u8868\u683c\u5217\u8868\u3002<\/p>\n<pre class=\"post-pre\"><code>%%sql\r\nshow tables;\r\n<\/code><\/pre>\n<h1>\u6700\u540e\u6211\u5df2\u7ecf\u5728Jupyter\u4e2d\u914d\u7f6e\u4e86MariaDB\uff0c\u73b0\u5728\u53ef\u4ee5\u4f7f\u7528SQL\u5bf9\u6570\u636e\u8fdb\u884c\u6574\u7406\uff0c\u5e76\u7ed3\u5408pandas\u548cmatplotlib\u8fdb\u884c\u53ef\u89c6\u5316\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u9996\u5148(Hajime ni) \u6211\u5011\u5c07\u5efa\u7acb\u4e00\u500b\u74b0\u5883\uff0c\u4ee5\u4fbf\u5728Jupyter\u4e2d\u4f7f\u7528MariaDB\u3002 \u8bf7\u53c2\u7167 Maria [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[227],"class_list":["post-28641","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-227"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u4f7f\u7528Jupyter Notebook\u6765\u64cd\u4f5cMariaDB - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"\u5173\u4e8e\u4f7f\u7528Jupyter Notebook\u6765\u64cd\u4f5cMariaDB\u7684\u6280\u672f\u6587\u7ae0\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528jupyter-notebook\u6765\u64cd\u4f5cmariadb\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u4f7f\u7528Jupyter Notebook\u6765\u64cd\u4f5cMariaDB\" \/>\n<meta property=\"og:description\" content=\"\u5173\u4e8e\u4f7f\u7528Jupyter Notebook\u6765\u64cd\u4f5cMariaDB\u7684\u6280\u672f\u6587\u7ae0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528jupyter-notebook\u6765\u64cd\u4f5cmariadb\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-04T23:29:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-12T01:18:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657cfd3837434c4406bc218e\/13-0.png\" \/>\n<meta name=\"author\" content=\"\u79d1, \u9896\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u79d1, \u9896\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8jupyter-notebook%e6%9d%a5%e6%93%8d%e4%bd%9cmariadb\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8jupyter-notebook%e6%9d%a5%e6%93%8d%e4%bd%9cmariadb\/\",\"name\":\"\u4f7f\u7528Jupyter Notebook\u6765\u64cd\u4f5cMariaDB - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-07-04T23:29:45+00:00\",\"dateModified\":\"2025-08-12T01:18:45+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/8ca01ba7f7362ad4edb7da206a12f29e\"},\"description\":\"\u5173\u4e8e\u4f7f\u7528Jupyter Notebook\u6765\u64cd\u4f5cMariaDB\u7684\u6280\u672f\u6587\u7ae0\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8jupyter-notebook%e6%9d%a5%e6%93%8d%e4%bd%9cmariadb\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8jupyter-notebook%e6%9d%a5%e6%93%8d%e4%bd%9cmariadb\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8jupyter-notebook%e6%9d%a5%e6%93%8d%e4%bd%9cmariadb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u4f7f\u7528Jupyter Notebook\u6765\u64cd\u4f5cMariaDB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/8ca01ba7f7362ad4edb7da206a12f29e\",\"name\":\"\u79d1, \u9896\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g\",\"caption\":\"\u79d1, \u9896\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/keying\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8jupyter-notebook%e6%9d%a5%e6%93%8d%e4%bd%9cmariadb\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u4f7f\u7528Jupyter Notebook\u6765\u64cd\u4f5cMariaDB - Blog - Silicon Cloud","description":"\u5173\u4e8e\u4f7f\u7528Jupyter Notebook\u6765\u64cd\u4f5cMariaDB\u7684\u6280\u672f\u6587\u7ae0","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:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528jupyter-notebook\u6765\u64cd\u4f5cmariadb\/","og_locale":"zh_CN","og_type":"article","og_title":"\u4f7f\u7528Jupyter Notebook\u6765\u64cd\u4f5cMariaDB","og_description":"\u5173\u4e8e\u4f7f\u7528Jupyter Notebook\u6765\u64cd\u4f5cMariaDB\u7684\u6280\u672f\u6587\u7ae0","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528jupyter-notebook\u6765\u64cd\u4f5cmariadb\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-07-04T23:29:45+00:00","article_modified_time":"2025-08-12T01:18:45+00:00","og_image":[{"url":"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657cfd3837434c4406bc218e\/13-0.png"}],"author":"\u79d1, \u9896","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u79d1, \u9896","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"1 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8jupyter-notebook%e6%9d%a5%e6%93%8d%e4%bd%9cmariadb\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8jupyter-notebook%e6%9d%a5%e6%93%8d%e4%bd%9cmariadb\/","name":"\u4f7f\u7528Jupyter Notebook\u6765\u64cd\u4f5cMariaDB - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-07-04T23:29:45+00:00","dateModified":"2025-08-12T01:18:45+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/8ca01ba7f7362ad4edb7da206a12f29e"},"description":"\u5173\u4e8e\u4f7f\u7528Jupyter Notebook\u6765\u64cd\u4f5cMariaDB\u7684\u6280\u672f\u6587\u7ae0","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8jupyter-notebook%e6%9d%a5%e6%93%8d%e4%bd%9cmariadb\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8jupyter-notebook%e6%9d%a5%e6%93%8d%e4%bd%9cmariadb\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8jupyter-notebook%e6%9d%a5%e6%93%8d%e4%bd%9cmariadb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u4f7f\u7528Jupyter Notebook\u6765\u64cd\u4f5cMariaDB"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/8ca01ba7f7362ad4edb7da206a12f29e","name":"\u79d1, \u9896","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8a6fb3cc7ba2f69d2189ba532aec4633ea7ed75ac0af162ec367cb3abc0fb2af?s=96&d=mm&r=g","caption":"\u79d1, \u9896"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/keying\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8jupyter-notebook%e6%9d%a5%e6%93%8d%e4%bd%9cmariadb\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/28641","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=28641"}],"version-history":[{"count":3,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/28641\/revisions"}],"predecessor-version":[{"id":111359,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/28641\/revisions\/111359"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=28641"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=28641"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=28641"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}