{"id":419,"date":"2024-02-26T14:46:29","date_gmt":"2023-06-16T20:15:51","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/index.php\/2023\/11\/30\/%e5%9c%a8debian-11-%e4%b8%8a%e5%ae%89%e8%a3%85mariadb-%e7%9a%84%e6%96%b9%e6%b3%95\/"},"modified":"2025-08-02T06:46:20","modified_gmt":"2025-08-01T22:46:20","slug":"%e5%9c%a8debian-11-%e4%b8%8a%e5%ae%89%e8%a3%85mariadb-%e7%9a%84%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8debian-11-%e4%b8%8a%e5%ae%89%e8%a3%85mariadb-%e7%9a%84%e6%96%b9%e6%b3%95\/","title":{"rendered":"Debian 11\u5b89\u88c5MariaDB\u5b8c\u6574\u6559\u7a0b\uff1a2023\u5e74\u8be6\u7ec6\u6b65\u9aa4\u6307\u5357"},"content":{"rendered":"<h3>\u5f15\u8a00<\/h3>\n<p>MariaDB\u662f\u4e00\u4e2a\u5f00\u6e90\u7684\u5173\u7cfb\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\uff0c\u901a\u5e38\u4f5c\u4e3aMySQL\u7684\u66ff\u4ee3\u65b9\u6848\uff0c\u4f5c\u4e3a\u6d41\u884c\u7684LAMP\uff08Linux\uff0cApache\uff0cMySQL\uff0cPHP\/Python\/Perl\uff09\u5806\u6808\u4e2d\u7684\u6570\u636e\u5e93\u90e8\u5206\u3002\u5b83\u65e8\u5728\u6210\u4e3aMySQL\u7684\u76f4\u63a5\u66ff\u4ee3\u54c1\u3002<\/p>\n<p>\u8fd9\u4e2a\u5b89\u88c5\u6307\u5357\u7684\u7b80\u77ed\u7248\u672c\u5305\u62ec\u4ee5\u4e0b\u4e09\u4e2a\u6b65\u9aa4\uff1a<\/p>\n<ul class=\"post-ul\">\n<li>Update your package index using apt<\/li>\n<li>Install the mariadb-server package using apt. The package also pulls in related tools to interact with MariaDB<\/li>\n<li>Run the included mysql_secure_installation security script to restrict access to the server<\/li>\n<\/ul>\n<pre class=\"post-pre\"><code><ol><li data-prefix=\"$\"><span class=\"token function\">sudo<\/span> <span class=\"token function\">apt<\/span> update\r\n<\/li><li data-prefix=\"$\"><span class=\"token function\">sudo<\/span> <span class=\"token function\">apt<\/span> <span class=\"token function\">install<\/span> mariadb-server\r\n<\/li><li data-prefix=\"$\"><span class=\"token function\">sudo<\/span> mysql_secure_installation\r\n<\/li><\/ol>\r\n<\/code><\/pre>\n<p>\u672c\u6559\u7a0b\u5c06\u89e3\u91ca\u5982\u4f55\u5728Debian 11\u670d\u52a1\u5668\u4e0a\u5b89\u88c5MariaDB\uff0c\u5e76\u9a8c\u8bc1\u5176\u662f\u5426\u6b63\u5e38\u8fd0\u884c\u5e76\u5177\u6709\u5b89\u5168\u7684\u521d\u59cb\u914d\u7f6e\u3002<\/p>\n<h2>\u5148\u51b3\u6761\u4ef6<\/h2>\n<ul class=\"post-ul\">\n<li>To follow this tutorial, you will need a server running Debian 11. This server should have a non-root administrative user and a firewall configured with UFW. Set this up by following our initial server setup guide for Debian 11.<\/li>\n<\/ul>\n<h2>\u6b65\u9aa41\u2014\u2014\u5b89\u88c5MariaDB<\/h2>\n<p>\u622a\u81f3\u64b0\u5199\u672c\u6587\u65f6\uff0cDebian 11\u7684\u9ed8\u8ba4\u8f6f\u4ef6\u6e90\u5305\u62ecMariaDB\u7248\u672c10.5.15\u3002\u5b83\u88abDebian MySQL\/MariaDB\u6253\u5305\u56e2\u961f\u6807\u8bb0\u4e3a\u9ed8\u8ba4\u7684MySQL\u53d8\u4f53\u3002<\/p>\n<p>\u8981\u5b89\u88c5\u5b83\uff0c\u8bf7\u4f7f\u7528apt\u66f4\u65b0\u60a8\u670d\u52a1\u5668\u4e0a\u7684\u8f6f\u4ef6\u5305\u7d22\u5f15\u3002<\/p>\n<pre class=\"post-pre\"><code><ol><li data-prefix=\"$\"><span class=\"token function\">sudo<\/span> <span class=\"token function\">apt<\/span> update\r\n<\/li><\/ol>\r\n<\/code><\/pre>\n<p>\u7136\u540e\u5b89\u88c5\u8fd9\u4e2a\u8f6f\u4ef6\u5305\u3002<\/p>\n<pre class=\"post-pre\"><code><ol><li data-prefix=\"$\"><span class=\"token function\">sudo<\/span> <span class=\"token function\">apt<\/span> <span class=\"token function\">install<\/span> mariadb-server\r\n<\/li><\/ol>\r\n<\/code><\/pre>\n<p>\u8fd9\u4e9b\u547d\u4ee4\u5c06\u5b89\u88c5MariaDB\uff0c\u4f46\u4e0d\u4f1a\u63d0\u793a\u60a8\u8bbe\u7f6e\u5bc6\u7801\u6216\u8fdb\u884c\u4efb\u4f55\u5176\u4ed6\u914d\u7f6e\u66f4\u6539\u3002\u7531\u4e8e\u9ed8\u8ba4\u914d\u7f6e\u4f1a\u4f7f\u60a8\u7684MariaDB\u5b89\u88c5\u4e0d\u5b89\u5168\uff0c\u56e0\u6b64\u60a8\u5c06\u4f7f\u7528mariadb-server\u8f6f\u4ef6\u5305\u63d0\u4f9b\u7684\u811a\u672c\u6765\u9650\u5236\u5bf9\u670d\u52a1\u5668\u7684\u8bbf\u95ee\u5e76\u5220\u9664\u672a\u4f7f\u7528\u7684\u8d26\u6237\u3002<\/p>\n<h2>\u6b65\u9aa4\u4e8c &#8211; \u914d\u7f6eMariaDB<\/h2>\n<p>\u5bf9\u4e8e\u65b0\u7684MariaDB\u5b89\u88c5\uff0c\u63a5\u4e0b\u6765\u7684\u6b65\u9aa4\u662f\u8fd0\u884c\u5305\u542b\u7684\u5b89\u5168\u811a\u672c\u3002\u6b64\u811a\u672c\u4f1a\u4fee\u6539\u4e00\u4e9b\u8f83\u4e0d\u5b89\u5168\u7684\u9ed8\u8ba4\u9009\u9879\uff0c\u5982\u8fdc\u7a0b\u6839\u7528\u6237\u767b\u5f55\u548c\u793a\u4f8b\u7528\u6237\u3002<\/p>\n<p>\u8fd0\u884c\u5b89\u5168\u811a\u672c\u3002<\/p>\n<pre class=\"post-pre\"><code><ol><li data-prefix=\"$\"><span class=\"token function\">sudo<\/span> mysql_secure_installation\r\n<\/li><\/ol>\r\n<\/code><\/pre>\n<p>\u8fd9\u5c06\u5e26\u9886\u4f60\u901a\u8fc7\u4e00\u7cfb\u5217\u63d0\u793a\uff0c\u4f60\u53ef\u4ee5\u5bf9MariaDB\u5b89\u88c5\u7684\u5b89\u5168\u9009\u9879\u8fdb\u884c\u4e00\u4e9b\u66f4\u6539\u3002\u7b2c\u4e00\u4e2a\u63d0\u793a\u5c06\u8981\u6c42\u4f60\u8f93\u5165\u5f53\u524d\u7684\u6570\u636e\u5e93\u6839\u5bc6\u7801\u3002\u7531\u4e8e\u4f60\u5c1a\u672a\u8bbe\u7f6e\u5bc6\u7801\uff0c\u8bf7\u6309ENTER\u8868\u793a\u201c\u65e0\u201d\u3002<\/p>\n<pre class=\"post-pre\"><code><div class=\"secondary-code-label\" title=\"Output\">Output<\/div>NOTE: 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, you'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\n<\/code><\/pre>\n<p>\u5728\u4f60\u4f1a\u88ab\u8981\u6c42\u662f\u5426\u8981\u5207\u6362\u5230Unix\u5957\u63a5\u5b57\u8ba4\u8bc1\u65f6\uff0c\u7531\u4e8e\u4f60\u5df2\u7ecf\u62e5\u6709\u53d7\u4fdd\u62a4\u7684\u6839\u8d26\u6237\uff0c\u4f60\u53ef\u4ee5\u8df3\u8fc7\u8fd9\u4e00\u6b65\u3002\u8f93\u5165n\u7136\u540e\u6309\u56de\u8f66\u952e\u3002<\/p>\n<pre class=\"post-pre\"><code><div class=\"secondary-code-label\" title=\"Output\">Output<\/div>. . .\r\nSetting the root password or using the unix_socket ensures that nobody\r\ncan log into the MariaDB root user without the proper authorisation.\r\n\r\nYou already have your root account protected, so you can safely answer 'n'.\r\n\r\nSwitch to unix_socket authentication [Y\/n] <mark>n<\/mark>\r\n<\/code><\/pre>\n<p>\u4e0b\u4e00\u4e2a\u63d0\u793a\u4f1a\u95ee\u4f60\u662f\u5426\u60f3\u66f4\u6539\u6839\u5bc6\u7801\u3002\u5728Debian 11\u4e0a\uff0cMariaDB\u7684\u6839\u8d26\u6237\u4e0e\u81ea\u52a8\u5316\u7cfb\u7edf\u7ef4\u62a4\u5bc6\u5207\u76f8\u5173\uff0c\u56e0\u6b64\u4e0d\u5e94\u66f4\u6539\u8be5\u8d26\u6237\u7684\u914d\u7f6e\u8ba4\u8bc1\u65b9\u5f0f\u3002<\/p>\n<p>\u8fd9\u6837\u505a\u53ef\u80fd\u4f1a\u5bfc\u81f4\u8f6f\u4ef6\u5305\u66f4\u65b0\u5220\u9664\u5bf9\u7ba1\u7406\u5458\u8d26\u6237\u7684\u8bbf\u95ee\u6743\u9650\uff0c\u4ece\u800c\u7834\u574f\u6570\u636e\u5e93\u7cfb\u7edf\u3002\u8bf7\u8f93\u5165\u5b57\u6bcd n\uff0c\u7136\u540e\u6309\u56de\u8f66\u952e\u3002<\/p>\n<pre class=\"post-pre\"><code><div class=\"secondary-code-label\" title=\"Output\">Output<\/div>Change the root password? [Y\/n]\r\n<\/code><\/pre>\n<p>\u4ee5\u540e\uff0c\u5982\u679c\u5957\u63a5\u5b57\u8eab\u4efd\u9a8c\u8bc1\u5728\u60a8\u7684\u4f7f\u7528\u60c5\u51b5\u4e0b\u4e0d\u5408\u9002\uff0c\u60a8\u5c06\u5b66\u4e60\u5982\u4f55\u8bbe\u7f6e\u4e00\u4e2a\u989d\u5916\u7684\u7ba1\u7406\u5458\u5e10\u6237\u4ee5\u8fdb\u884c\u5bc6\u7801\u8bbf\u95ee\u3002<\/p>\n<p>\u4ece\u90a3\u91cc\u5f00\u59cb\uff0c\u4f60\u53ef\u4ee5\u6309\u4e0bY\u7136\u540e\u6309\u4e0b\u56de\u8f66\u952e\u6765\u63a5\u53d7\u6240\u6709\u540e\u7eed\u95ee\u9898\u7684\u9ed8\u8ba4\u8bbe\u7f6e\u3002\u8fd9\u5c06\u5220\u9664\u4e00\u4e9b\u533f\u540d\u7528\u6237\u548c\u6d4b\u8bd5\u6570\u636e\u5e93\uff0c\u7981\u7528\u8fdc\u7a0broot\u767b\u5f55\uff0c\u5e76\u52a0\u8f7d\u8fd9\u4e9b\u65b0\u89c4\u5219\uff0c\u4ee5\u4fbfMariaDB\u7acb\u5373\u5b9e\u65bd\u4f60\u6240\u505a\u7684\u66f4\u6539\u3002<\/p>\n<p>\u6709\u4e86\u8fd9\u4e9b\uff0c\u60a8\u5df2\u7ecf\u5b8c\u6210\u4e86MariaDB\u7684\u521d\u59cb\u5b89\u5168\u914d\u7f6e\u3002\u4e0b\u4e00\u6b65\u662f\u4e00\u4e2a\u53ef\u9009\u6b65\u9aa4\uff0c\u4f46\u5982\u679c\u60a8\u5e0c\u671b\u4f7f\u7528\u5bc6\u7801\u8fdb\u884c\u8eab\u4efd\u9a8c\u8bc1\u5230MariaDB\u670d\u52a1\u5668\uff0c\u6211\u4eec\u5efa\u8bae\u60a8\u9075\u5faa\u6b64\u6b65\u9aa4\u3002<\/p>\n<h2>\u6b65\u9aa43 \u2014 (\u53ef\u9009) \u521b\u5efa\u4e00\u4e2a\u4f7f\u7528\u5bc6\u7801\u9a8c\u8bc1\u7684\u7ba1\u7406\u5458\u7528\u6237<\/h2>\n<p>\u5728\u8fd0\u884cMariaDB 10.5\u7684Debian\u7cfb\u7edf\u4e0a\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0croot MariaDB\u7528\u6237\u4f7f\u7528unix_socket\u63d2\u4ef6\u8fdb\u884c\u8eab\u4efd\u9a8c\u8bc1\uff0c\u800c\u4e0d\u662f\u4f7f\u7528\u5bc6\u7801\u3002\u8fd9\u5728\u8bb8\u591a\u60c5\u51b5\u4e0b\u53ef\u4ee5\u63d0\u4f9b\u66f4\u9ad8\u7684\u5b89\u5168\u6027\u548c\u53ef\u7528\u6027\uff0c\u4f46\u5f53\u60a8\u9700\u8981\u5141\u8bb8\u5916\u90e8\u7a0b\u5e8f\uff08\u4f8b\u5982phpMyAdmin\uff09\u62e5\u6709\u7ba1\u7406\u5458\u6743\u9650\u65f6\uff0c\u53ef\u80fd\u4f1a\u589e\u52a0\u4e00\u4e9b\u590d\u6742\u6027\u3002<\/p>\n<p>\u7531\u4e8e\u670d\u52a1\u5668\u4f7f\u7528root\u8d26\u6237\u6765\u6267\u884c\u8bf8\u5982\u65e5\u5fd7\u8f6e\u6362\u3001\u542f\u52a8\u548c\u505c\u6b62\u670d\u52a1\u5668\u4e4b\u7c7b\u7684\u4efb\u52a1\uff0c\u6700\u597d\u4e0d\u8981\u66f4\u6539root\u8d26\u6237\u7684\u8ba4\u8bc1\u4fe1\u606f\u3002\u867d\u7136\u5728\/etc\/mysql\/debian.cnf\u914d\u7f6e\u6587\u4ef6\u4e2d\u66f4\u6539\u51ed\u636e\u5728\u521d\u59cb\u9636\u6bb5\u53ef\u80fd\u6709\u6548\uff0c\u4f46\u662f\u8f6f\u4ef6\u5305\u66f4\u65b0\u6709\u53ef\u80fd\u4f1a\u8986\u76d6\u8fd9\u4e9b\u66f4\u6539\u3002\u4e0e\u5176\u4fee\u6539root\u8d26\u6237\uff0c\u8f6f\u4ef6\u5305\u7ef4\u62a4\u8005\u5efa\u8bae\u521b\u5efa\u4e00\u4e2a\u5355\u72ec\u7684\u7ba1\u7406\u8d26\u6237\uff0c\u7528\u4e8e\u57fa\u4e8e\u5bc6\u7801\u7684\u8bbf\u95ee\u3002<\/p>\n<p>\u4e3a\u6b64\uff0c\u6211\u4eec\u5c06\u521b\u5efa\u4e00\u4e2a\u540d\u4e3a\u201cadmin\u201d\u7684\u65b0\u8d26\u6237\uff0c\u5177\u6709\u4e0eroot\u8d26\u6237\u76f8\u540c\u7684\u6743\u9650\uff0c\u4f46\u914d\u7f6e\u4e3a\u5bc6\u7801\u9a8c\u8bc1\u3002\u4ece\u60a8\u7684\u7ec8\u7aef\u6253\u5f00MariaDB\u63d0\u793a\u7b26\uff1a<\/p>\n<pre class=\"post-pre\"><code><ol><li data-prefix=\"$\"><span class=\"token function\">sudo<\/span> mariadb\r\n<\/li><\/ol>\r\n<\/code><\/pre>\n<p>\u968f\u540e\u521b\u5efa\u4e00\u4e2a\u5177\u6709root\u6743\u9650\u548c\u57fa\u4e8e\u5bc6\u7801\u7684\u8bbf\u95ee\u7684\u65b0\u7528\u6237\u3002\u8bf7\u786e\u4fdd\u66f4\u6539\u7528\u6237\u540d\u548c\u5bc6\u7801\u4ee5\u5339\u914d\u60a8\u7684\u504f\u597d\u3002<\/p>\n<pre class=\"post-pre\"><code><ol><li data-prefix=\"MariaDB [(none)]>\">GRANT ALL ON *.* TO <span class=\"token string\">'<mark>admin<\/mark>'<\/span>@<span class=\"token string\">'localhost'<\/span> IDENTIFIED BY <span class=\"token string\">'<mark>password<\/mark>'<\/span> WITH GRANT OPTION<span class=\"token punctuation\">;<\/span>\r\n<\/li><\/ol>\r\n<\/code><\/pre>\n<p>\u5237\u65b0\u6743\u9650\u4ee5\u786e\u4fdd\u5b83\u4eec\u5728\u5f53\u524d\u4f1a\u8bdd\u4e2d\u5f97\u4ee5\u4fdd\u5b58\u548c\u751f\u6548\u3002<\/p>\n<pre class=\"post-pre\"><code><ol><li data-prefix=\"MariaDB [(none)]>\">FLUSH PRIVILEGES<span class=\"token punctuation\">;<\/span>\r\n<\/li><\/ol>\r\n<\/code><\/pre>\n<p>\u5b8c\u6210\u540e\uff0c\u8bf7\u9000\u51faMariaDB shell\u3002<\/p>\n<pre class=\"post-pre\"><code><ol><li data-prefix=\"MariaDB [(none)]>\"><span class=\"token builtin class-name\">exit<\/span>\r\n<\/li><\/ol>\r\n<\/code><\/pre>\n<p>\u6700\u540e\uff0c\u8ba9\u6211\u4eec\u6d4b\u8bd5\u4e00\u4e0bMariaDB\u7684\u5b89\u88c5\u3002<\/p>\n<h2>\u6b65\u9aa4\u56db \u2014 \u6d4b\u8bd5MariaDB<\/h2>\n<p>\u5f53\u4ece\u9ed8\u8ba4\u7684\u8d44\u6e90\u5e93\u5b89\u88c5\u4e86MariaDB\u540e\uff0c\u5b83\u4f1a\u81ea\u52a8\u5f00\u59cb\u8fd0\u884c\u3002\u4e3a\u4e86\u6d4b\u8bd5\u8fd9\u4e00\u70b9\uff0c\u68c0\u67e5\u5b83\u7684\u72b6\u6001\u5373\u53ef\u3002<\/p>\n<pre class=\"post-pre\"><code><ol><li data-prefix=\"$\"><span class=\"token function\">sudo<\/span> systemctl status mariadb\r\n<\/li><\/ol>\r\n<\/code><\/pre>\n<p>\u60a8\u5c06\u6536\u5230\u7c7b\u4f3c\u4e8e\u4e0b\u9762\u7684\u8f93\u51fa\u7ed3\u679c\uff1a<\/p>\n<pre class=\"post-pre\"><code><div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\u25cf mariadb.service - MariaDB 10.5.15 database server\r\n     Loaded: loaded (\/lib\/systemd\/system\/mariadb.service; enabled; vendor preset: enabled)\r\n     Active: active (running) since Fri 2022-03-11 22:01:33 UTC; 14min ago\r\n       Docs: man:mariadbd(8)\r\n             https:\/\/mariadb.com\/kb\/en\/library\/systemd\/\r\n. . .\r\n<\/code><\/pre>\n<p>\u5982\u679cMariaDB\u6ca1\u6709\u8fd0\u884c\uff0c\u60a8\u53ef\u4ee5\u4f7f\u7528\u547d\u4ee4sudo systemctl start mariadb\u6765\u542f\u52a8\u5b83\u3002<\/p>\n<p>\u4e3a\u4e86\u8fdb\u884c\u989d\u5916\u7684\u68c0\u67e5\uff0c\u60a8\u53ef\u4ee5\u5c1d\u8bd5\u4f7f\u7528mysqladmin\u5de5\u5177\u8fde\u63a5\u5230\u6570\u636e\u5e93\u3002\u8fd9\u662f\u4e00\u4e2a\u5ba2\u6237\u7aef\uff0c\u5141\u8bb8\u60a8\u8fd0\u884c\u7ba1\u7406\u547d\u4ee4\u3002\u4f8b\u5982\uff0c\u4ee5\u4e0b\u547d\u4ee4\u7528\u4e8e\u4f7f\u7528Unix\u5957\u63a5\u5b57\u8fde\u63a5\u5230MariaDB\u4f5c\u4e3aroot\u7528\u6237\uff0c\u5e76\u8fd4\u56de\u7248\u672c\u4fe1\u606f\u3002<\/p>\n<pre class=\"post-pre\"><code><ol><li data-prefix=\"$\"><span class=\"token function\">sudo<\/span> mysqladmin version\r\n<\/li><\/ol>\r\n<\/code><\/pre>\n<p>\u4f60\u5c06\u6536\u5230\u7c7b\u4f3c\u8fd9\u6837\u7684\u8f93\u51fa\u3002<\/p>\n<pre class=\"post-pre\"><code><div class=\"secondary-code-label\" title=\"Output\">Output<\/div>mysqladmin  Ver 9.1 Distrib 10.5.15-MariaDB, for debian-linux-gnu on x86_64\r\nCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.\r\n\r\nServer version          10.5.15-MariaDB-0+deb11u1\r\nProtocol version        10\r\nConnection              Localhost via UNIX socket\r\nUNIX socket             \/run\/mysqld\/mysqld.sock\r\nUptime:                 4 min 20 sec\r\n\r\nThreads: 1  Questions: 72  Slow queries: 0  Opens: 32  Open tables: 25  Queries per second avg: 0.276\r\n<\/code><\/pre>\n<h2>\u7ed3\u8bba<\/h2>\n<p>\u5728\u672c\u6307\u5357\u4e2d\uff0c\u60a8\u5b89\u88c5\u4e86MariaDB\u5173\u7cfb\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\uff0c\u5e76\u4f7f\u7528\u5176\u9ed8\u8ba4\u5b89\u88c5\u7684mysql_secure_installation\u811a\u672c\u8fdb\u884c\u4e86\u5b89\u5168\u8bbe\u7f6e\u3002\u60a8\u8fd8\u53ef\u4ee5\u9009\u62e9\u5728\u6d4b\u8bd5MariaDB\u670d\u52a1\u5668\u529f\u80fd\u4e4b\u524d\u521b\u5efa\u4e00\u4e2a\u4f7f\u7528\u5bc6\u7801\u8eab\u4efd\u9a8c\u8bc1\u7684\u65b0\u7684\u7ba1\u7406\u7528\u6237\u3002<\/p>\n<p>\u73b0\u5728\u60a8\u5df2\u7ecf\u62e5\u6709\u4e00\u4e2a\u8fd0\u884c\u4e14\u5b89\u5168\u7684MariaDB\u670d\u52a1\u5668\uff0c\u4ee5\u4e0b\u662f\u4e00\u4e9b\u793a\u4f8b\uff0c\u663e\u793a\u60a8\u53ef\u4ee5\u91c7\u53d6\u7684\u4e0b\u4e00\u6b65\u64cd\u4f5c\u6765\u4e0e\u670d\u52a1\u5668\u4e00\u8d77\u5de5\u4f5c\uff1a<\/p>\n<ul class=\"post-ul\">\n<li>Learn how to import and export databases<\/li>\n<li>Practice running SQL queries<\/li>\n<li>Incorporate MariaDB into a larger application stack<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u5f15\u8a00 MariaDB\u662f\u4e00\u4e2a\u5f00\u6e90\u7684\u5173\u7cfb\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\uff0c\u901a\u5e38\u4f5c\u4e3aMySQL\u7684\u66ff\u4ee3\u65b9\u6848\uff0c\u4f5c\u4e3a\u6d41\u884c\u7684LAMP\uff08Linu [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[338,311,313,257,331],"class_list":["post-419","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-debian-11","tag-linux","tag-mariadb","tag-257","tag-331"],"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>Debian 11\u5b89\u88c5MariaDB\u5b8c\u6574\u6559\u7a0b\uff1a2023\u5e74\u8be6\u7ec6\u6b65\u9aa4\u6307\u5357 - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"\u672c\u6559\u7a0b\u8be6\u7ec6\u4ecb\u7ecd\u5982\u4f55\u5728Debian 11\u7cfb\u7edf\u4e0a\u5b89\u88c5\u548c\u914d\u7f6eMariaDB\u6570\u636e\u5e93\u670d\u52a1\u5668\u3002\u5305\u542b\u4ece\u6dfb\u52a0\u8f6f\u4ef6\u6e90\u3001\u5b89\u88c5MariaDB\u3001\u5b89\u5168\u914d\u7f6e\u5230\u521b\u5efa\u6570\u636e\u5e93\u548c\u7528\u6237\u7684\u5b8c\u6574\u6b65\u9aa4\u3002\u9002\u5408Linux\u521d\u5b66\u8005\u548c\u7cfb\u7edf\u7ba1\u7406\u5458\u53c2\u8003\u3002\" \/>\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\/\u5728debian-11-\u4e0a\u5b89\u88c5mariadb-\u7684\u65b9\u6cd5\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Debian 11\u5b89\u88c5MariaDB\u5b8c\u6574\u6559\u7a0b\uff1a2023\u5e74\u8be6\u7ec6\u6b65\u9aa4\u6307\u5357\" \/>\n<meta property=\"og:description\" content=\"\u672c\u6559\u7a0b\u8be6\u7ec6\u4ecb\u7ecd\u5982\u4f55\u5728Debian 11\u7cfb\u7edf\u4e0a\u5b89\u88c5\u548c\u914d\u7f6eMariaDB\u6570\u636e\u5e93\u670d\u52a1\u5668\u3002\u5305\u542b\u4ece\u6dfb\u52a0\u8f6f\u4ef6\u6e90\u3001\u5b89\u88c5MariaDB\u3001\u5b89\u5168\u914d\u7f6e\u5230\u521b\u5efa\u6570\u636e\u5e93\u548c\u7528\u6237\u7684\u5b8c\u6574\u6b65\u9aa4\u3002\u9002\u5408Linux\u521d\u5b66\u8005\u548c\u7cfb\u7edf\u7ba1\u7406\u5458\u53c2\u8003\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5728debian-11-\u4e0a\u5b89\u88c5mariadb-\u7684\u65b9\u6cd5\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-16T20:15:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-01T22:46:20+00:00\" \/>\n<meta name=\"author\" content=\"\u6e05, \u5b87\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u6e05, \u5b87\" \/>\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\/%e5%9c%a8debian-11-%e4%b8%8a%e5%ae%89%e8%a3%85mariadb-%e7%9a%84%e6%96%b9%e6%b3%95\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8debian-11-%e4%b8%8a%e5%ae%89%e8%a3%85mariadb-%e7%9a%84%e6%96%b9%e6%b3%95\/\",\"name\":\"Debian 11\u5b89\u88c5MariaDB\u5b8c\u6574\u6559\u7a0b\uff1a2023\u5e74\u8be6\u7ec6\u6b65\u9aa4\u6307\u5357 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-06-16T20:15:51+00:00\",\"dateModified\":\"2025-08-01T22:46:20+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/1a6ecd3d914d22a5ac32791ffc1fbd8e\"},\"description\":\"\u672c\u6559\u7a0b\u8be6\u7ec6\u4ecb\u7ecd\u5982\u4f55\u5728Debian 11\u7cfb\u7edf\u4e0a\u5b89\u88c5\u548c\u914d\u7f6eMariaDB\u6570\u636e\u5e93\u670d\u52a1\u5668\u3002\u5305\u542b\u4ece\u6dfb\u52a0\u8f6f\u4ef6\u6e90\u3001\u5b89\u88c5MariaDB\u3001\u5b89\u5168\u914d\u7f6e\u5230\u521b\u5efa\u6570\u636e\u5e93\u548c\u7528\u6237\u7684\u5b8c\u6574\u6b65\u9aa4\u3002\u9002\u5408Linux\u521d\u5b66\u8005\u548c\u7cfb\u7edf\u7ba1\u7406\u5458\u53c2\u8003\u3002\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8debian-11-%e4%b8%8a%e5%ae%89%e8%a3%85mariadb-%e7%9a%84%e6%96%b9%e6%b3%95\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8debian-11-%e4%b8%8a%e5%ae%89%e8%a3%85mariadb-%e7%9a%84%e6%96%b9%e6%b3%95\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8debian-11-%e4%b8%8a%e5%ae%89%e8%a3%85mariadb-%e7%9a%84%e6%96%b9%e6%b3%95\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Debian 11\u5b89\u88c5MariaDB\u5b8c\u6574\u6559\u7a0b\uff1a2023\u5e74\u8be6\u7ec6\u6b65\u9aa4\u6307\u5357\"}]},{\"@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\/1a6ecd3d914d22a5ac32791ffc1fbd8e\",\"name\":\"\u6e05, \u5b87\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4b2016c18459a605fc469c7566608f5686491baa112d0871ee613f61b7210565?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4b2016c18459a605fc469c7566608f5686491baa112d0871ee613f61b7210565?s=96&d=mm&r=g\",\"caption\":\"\u6e05, \u5b87\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyu\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8debian-11-%e4%b8%8a%e5%ae%89%e8%a3%85mariadb-%e7%9a%84%e6%96%b9%e6%b3%95\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Debian 11\u5b89\u88c5MariaDB\u5b8c\u6574\u6559\u7a0b\uff1a2023\u5e74\u8be6\u7ec6\u6b65\u9aa4\u6307\u5357 - Blog - Silicon Cloud","description":"\u672c\u6559\u7a0b\u8be6\u7ec6\u4ecb\u7ecd\u5982\u4f55\u5728Debian 11\u7cfb\u7edf\u4e0a\u5b89\u88c5\u548c\u914d\u7f6eMariaDB\u6570\u636e\u5e93\u670d\u52a1\u5668\u3002\u5305\u542b\u4ece\u6dfb\u52a0\u8f6f\u4ef6\u6e90\u3001\u5b89\u88c5MariaDB\u3001\u5b89\u5168\u914d\u7f6e\u5230\u521b\u5efa\u6570\u636e\u5e93\u548c\u7528\u6237\u7684\u5b8c\u6574\u6b65\u9aa4\u3002\u9002\u5408Linux\u521d\u5b66\u8005\u548c\u7cfb\u7edf\u7ba1\u7406\u5458\u53c2\u8003\u3002","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\/\u5728debian-11-\u4e0a\u5b89\u88c5mariadb-\u7684\u65b9\u6cd5\/","og_locale":"zh_CN","og_type":"article","og_title":"Debian 11\u5b89\u88c5MariaDB\u5b8c\u6574\u6559\u7a0b\uff1a2023\u5e74\u8be6\u7ec6\u6b65\u9aa4\u6307\u5357","og_description":"\u672c\u6559\u7a0b\u8be6\u7ec6\u4ecb\u7ecd\u5982\u4f55\u5728Debian 11\u7cfb\u7edf\u4e0a\u5b89\u88c5\u548c\u914d\u7f6eMariaDB\u6570\u636e\u5e93\u670d\u52a1\u5668\u3002\u5305\u542b\u4ece\u6dfb\u52a0\u8f6f\u4ef6\u6e90\u3001\u5b89\u88c5MariaDB\u3001\u5b89\u5168\u914d\u7f6e\u5230\u521b\u5efa\u6570\u636e\u5e93\u548c\u7528\u6237\u7684\u5b8c\u6574\u6b65\u9aa4\u3002\u9002\u5408Linux\u521d\u5b66\u8005\u548c\u7cfb\u7edf\u7ba1\u7406\u5458\u53c2\u8003\u3002","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u5728debian-11-\u4e0a\u5b89\u88c5mariadb-\u7684\u65b9\u6cd5\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-06-16T20:15:51+00:00","article_modified_time":"2025-08-01T22:46:20+00:00","author":"\u6e05, \u5b87","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u6e05, \u5b87","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"1 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8debian-11-%e4%b8%8a%e5%ae%89%e8%a3%85mariadb-%e7%9a%84%e6%96%b9%e6%b3%95\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8debian-11-%e4%b8%8a%e5%ae%89%e8%a3%85mariadb-%e7%9a%84%e6%96%b9%e6%b3%95\/","name":"Debian 11\u5b89\u88c5MariaDB\u5b8c\u6574\u6559\u7a0b\uff1a2023\u5e74\u8be6\u7ec6\u6b65\u9aa4\u6307\u5357 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-06-16T20:15:51+00:00","dateModified":"2025-08-01T22:46:20+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/1a6ecd3d914d22a5ac32791ffc1fbd8e"},"description":"\u672c\u6559\u7a0b\u8be6\u7ec6\u4ecb\u7ecd\u5982\u4f55\u5728Debian 11\u7cfb\u7edf\u4e0a\u5b89\u88c5\u548c\u914d\u7f6eMariaDB\u6570\u636e\u5e93\u670d\u52a1\u5668\u3002\u5305\u542b\u4ece\u6dfb\u52a0\u8f6f\u4ef6\u6e90\u3001\u5b89\u88c5MariaDB\u3001\u5b89\u5168\u914d\u7f6e\u5230\u521b\u5efa\u6570\u636e\u5e93\u548c\u7528\u6237\u7684\u5b8c\u6574\u6b65\u9aa4\u3002\u9002\u5408Linux\u521d\u5b66\u8005\u548c\u7cfb\u7edf\u7ba1\u7406\u5458\u53c2\u8003\u3002","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8debian-11-%e4%b8%8a%e5%ae%89%e8%a3%85mariadb-%e7%9a%84%e6%96%b9%e6%b3%95\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8debian-11-%e4%b8%8a%e5%ae%89%e8%a3%85mariadb-%e7%9a%84%e6%96%b9%e6%b3%95\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8debian-11-%e4%b8%8a%e5%ae%89%e8%a3%85mariadb-%e7%9a%84%e6%96%b9%e6%b3%95\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"Debian 11\u5b89\u88c5MariaDB\u5b8c\u6574\u6559\u7a0b\uff1a2023\u5e74\u8be6\u7ec6\u6b65\u9aa4\u6307\u5357"}]},{"@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\/1a6ecd3d914d22a5ac32791ffc1fbd8e","name":"\u6e05, \u5b87","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4b2016c18459a605fc469c7566608f5686491baa112d0871ee613f61b7210565?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4b2016c18459a605fc469c7566608f5686491baa112d0871ee613f61b7210565?s=96&d=mm&r=g","caption":"\u6e05, \u5b87"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyu\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8debian-11-%e4%b8%8a%e5%ae%89%e8%a3%85mariadb-%e7%9a%84%e6%96%b9%e6%b3%95\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/419","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\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=419"}],"version-history":[{"count":3,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/419\/revisions"}],"predecessor-version":[{"id":110009,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/419\/revisions\/110009"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=419"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=419"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}