{"id":145,"date":"2024-03-21T11:10:40","date_gmt":"2024-03-21T03:10:40","guid":{"rendered":"https:\/\/xieshuoshuo.top\/?p=145"},"modified":"2024-06-03T16:16:37","modified_gmt":"2024-06-03T08:16:37","slug":"ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd","status":"publish","type":"post","link":"https:\/\/www.17ci.com\/index.php\/ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd\/","title":{"rendered":"Ubuntu\u4e2d\u5b9e\u73b0MySQL\u5b9a\u65f6\u5907\u4efd"},"content":{"rendered":"\n<p>\u4f7f\u7528\u7248\u672c\uff1aUbuntu 20.04.06 LTS\/Ubuntu 18.04.06 LTS  MySQL 5.7.42<\/p>\n\n\n\n<p>\u4f7f\u7528SSH\u8fde\u63a5\u4e0aUbuntu\u540e\uff0c\u6211\u4eec\u9996\u5148\u786e\u8ba4\u4e00\u4e0bmysqldump\u662f\u5426\u5b89\u88c5\u6210\u529f\uff0c\u8fd9\u4e2a\u662f\u5b89\u88c5MySQL\u65f6\u81ea\u52a8\u5b89\u88c5\u7684\uff0c\u540c\u65f6\u8fd9\u4e2a\u4e5f\u662f\u5907\u4efd\u6570\u636e\u5e93\u7684\u547d\u4ee4\u4e4b\u4e00\u3002<\/p>\n\n\n\n<p>1\u3001\u975eDocker\u5b89\u88c5\u7684MySQL<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqldump --version<\/code><\/pre>\n\n\n\n<p>\u5982\u679c\u8fd4\u56de\u7684\u662f\u4e00\u4e2a\u7248\u672c\u53f7\uff0c\u90a3\u5c31\u4ee3\u8868\u5b89\u88c5\u6210\u529f\uff0c\u4f8b\u5982\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqldump --version\nmysqldump  Ver 10.13 Distrib 5.7.40, for Linux (x86_64)<\/code><\/pre>\n\n\n\n<p>\u5982\u679c\u8fd4\u56de\u7684\u4e0d\u662f\u7248\u672c\u53f7\u6216\u8005\u662f\u5176\u4ed6\u9519\u8bef\u4fe1\u606f\uff0c\u5c31\u9700\u8981\u91cd\u65b0\u5b89\u88c5\uff0c\u5b89\u88c5\u547d\u4ee4\u5982\u4e0b\uff08\u4e24\u4e2a\u4efb\u9009\u5176\u4e00\u5373\u53ef\uff09\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo apt install mysql-client-core-8.0\nsudo apt install mariadb-client-10.3<\/code><\/pre>\n\n\n\n<p>\u5b89\u88c5\u5b8c\u6210\u540e\uff0c\u518d\u6b21\u4f7f\u7528mysqldump --version\u547d\u4ee4\u68c0\u67e5\u662f\u5426\u5b89\u88c5\u6210\u529f\u3002<\/p>\n\n\n\n<p>\u63a5\u4e0b\u6765\u6211\u4eec\u9700\u8981\u521b\u5efa\u4e00\u4e2a\u6587\u4ef6\u5939\uff0c\u8fd9\u4e2a\u6587\u4ef6\u5939\u7528\u4e8e\u50a8\u5b58\u811a\u672c\u6216\u8005\u662f\u5907\u4efd\u7684\u6570\u636e\u5e93\uff0c\u5305\u62ec\u9519\u8bef\u7684\u65e5\u5fd7\u4e5f\u53ef\u4ee5\u5b58\u653e\u5728\u91cc\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo mkdir \/home\/dates # \u521b\u5efa\u4e00\u4e2ahome\u6587\u4ef6\u5939\u4e0b\u7684dates\u6587\u4ef6\u5939\n\t\t\ncd \/home\/dates # \u8fdb\u5165dates\u6587\u4ef6\u5939\n\t\t\nsudo vim backup_mysql.sh # \u4f7f\u7528vim\u547d\u4ee4\u521b\u5efa\u4e00\u4e2a\u6587\u4ef6\uff0c\u6211\u8fd9\u91cc\u547d\u540d\u4e3abackup_mysql.sh<\/code><\/pre>\n\n\n\n<p>\u8fdb\u5165\u6587\u4ef6\u540e\uff0c\u628a\u4e0b\u9762\u7684\u6587\u4ef6\u590d\u5236\u8fdb\u53bb<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql_user=\"root\" # \u8fd9\u4e2a\u8d26\u53f7\u9700\u8981\u6709\u5907\u4efd\u7684\u6743\u9650\nmysql_password=\"123456\" # \u5bc6\u7801\nmysql_database=\"test\" # \u9700\u8981\u5907\u4efd\u7684\u6570\u636e\u5e93\n\nbackup_file=\"\/home\/dates\/mysql_backup_$(date +%Y%m%d_%H%M%S).sql\" # \u5907\u4efd\u7684\u6570\u636e\u5e93\u4fdd\u5b58\u8def\u5f84\n\nmysqldump -u $mysql_user -p$mysql_password $mysql_database &gt; $backup_file 2&gt; \/home\/dates\/mysql_backup_error.log # \u4f7f\u7528 mysqldump \u547d\u4ee4\u5907\u4efd\u6570\u636e\u5e93\uff0c\u4fdd\u5b58\u62a5\u9519\u4ea7\u751f\u7684\u65e5\u5fd7\u5b58\u653e\n\nif &#91; $? -eq 0 ]; then # \u68c0\u67e5\u5907\u4efd\u662f\u5426\u6210\u529f\n    echo \"Database backup successful. Backup saved to: $backup_file\"\nelse\n    echo \"Error: Database backup failed.\"\nfi<\/code><\/pre>\n\n\n\n<p>\u590d\u5236\u8fdb\u53bb\u540e\uff0c\u70b9\u51fbesc\uff0c\u7136\u540e\u4f7f\u7528:wq\u9000\u51fa\u4fdd\u5b58\uff0c\u9000\u51fa\u540e\uff0c\u4f7f\u7528\u4e0b\u9762\u7684\u547d\u4ee4\u8d4b\u4e88\u811a\u672c\u6743\u9650<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>chmod +x backup_mysql.sh<\/code><\/pre>\n\n\n\n<p>\u81f3\u6b64\uff0c\u811a\u672c\u5df2\u7ecf\u5199\u597d\u4e86\uff0c\u63a5\u4e0b\u6765\u5c31\u662f\u5b9a\u65f6\u6267\u884c\uff0c\u4f7f\u7528\u4e0b\u9762\u7684\u547d\u4ee4\u8fdb\u5165\u5b9a\u65f6\u4efb\u52a1<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo crontab -e<\/code><\/pre>\n\n\n\n<p>\u9996\u6b21\u8fdb\u5165\u4f1a\u6709\u8fd9\u6837\u7684\u63d0\u793a\uff0c\u6211\u4eec\u9009\u62e91\u5373\u53ef\uff0c\u7136\u540e\u56de\u8f66<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"723\" height=\"275\" src=\"https:\/\/xieshuoshuo.top\/wp-content\/uploads\/2024\/03\/1710987023-image.png\" alt=\"\" class=\"wp-image-149\" srcset=\"https:\/\/www.17ci.com\/wp-content\/uploads\/2024\/03\/1710987023-image.png 723w, https:\/\/www.17ci.com\/wp-content\/uploads\/2024\/03\/1710987023-image-300x114.png 300w\" sizes=\"auto, (max-width: 723px) 100vw, 723px\" \/><\/figure>\n\n\n\n<p>\u8fdb\u5165\u7f16\u8f91\u9875\u9762\u540e\uff0c\u5212\u5230\u6700\u4e0b\u9762\uff0c\u7136\u540e\u4f7f\u7528\u4e0b\u9762\u7684\u547d\u4ee4\u52a0\u5165\u5b9a\u65f6\u4efb\u52a1\uff0c\u4e0b\u9762\u7684\u5b9a\u65f6\u4efb\u52a1\u662f\u6bcf\u5929\u51cc\u666802\uff1a00\u6267\u884c\u811a\u672c\uff0c\u547d\u4ee4\u89e3\u91ca \u5206\u949f  \u5c0f\u65f6  * * * \u811a\u672c\u8def\u5f84<\/p>\n\n\n\n<p>0 2 * * * \/home\/dates\/backup_mysql.sh  #\u547d\u4ee4\u89e3\u91ca \u5206\u949f  \u5c0f\u65f6  * * * \u811a\u672c\u8def\u5f84<\/p>\n\n\n\n<p>\u540e\u9762\u5728Ubuntu 18.04.06 LTS\u4e0a\u6d4b\u8bd5\u7684\u65f6\u5019\uff0c\u53d1\u73b0\u4e00\u76f4\u5907\u4efd\u4e0d\u4e86\uff0c\u5c31\u6362\u6210\u4e86\u4e0b\u9762\u7684\u547d\u4ee4\uff0c\u5907\u4efd\u6210\u529f<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"498\" height=\"28\" src=\"https:\/\/xieshuoshuo.top\/wp-content\/uploads\/2024\/03\/1710990214-image.png\" alt=\"\" class=\"wp-image-161\" srcset=\"https:\/\/www.17ci.com\/wp-content\/uploads\/2024\/03\/1710990214-image.png 498w, https:\/\/www.17ci.com\/wp-content\/uploads\/2024\/03\/1710990214-image-300x17.png 300w\" sizes=\"auto, (max-width: 498px) 100vw, 498px\" \/><\/figure>\n\n\n\n<p>\u5907\u4efd\u6210\u529f\u540e\uff0c\u9519\u8bef\u65e5\u5fd7\u4f1a\u8bb0\u5f55mysqldump: [Warning] Using a password on the command line interface can be insecure.\u7684\u8b66\u544a\u3002<\/p>\n\n\n\n<p>\u5b89\u5168\u8d77\u89c1\u53ef\u4ee5\u4e0d\u4f7f\u7528\u660e\u6587\u5bc6\u7801\u6216\u8005\u4e0d\u7528\u7406\u4f1a\u3002<\/p>\n\n\n\n<p>1\u3001\u521b\u5efa~\/.my.cnf\u6587\u4ef6\uff0c\u547d\u4ee4\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>nano ~\/.my.cnf<\/code><\/pre>\n\n\n\n<p>2\u3001\u5728\u6587\u4ef6\u4e2d\u6dfb\u52a0\u8d26\u53f7\u5bc6\u7801<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;client]\nuser=root\npassword=123456<\/code><\/pre>\n\n\n\n<p>3\u3001\u8bbe\u7f6e\u6743\u9650\uff0c\u4ec5\u5141\u8bb8\u81ea\u5df1\u8bfb\u53d6\u5199\u5165<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>chmod 600 ~\/.my.cnf<\/code><\/pre>\n\n\n\n<p>4\u3001\u4fdd\u5b58\u5173\u95ed<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4f7f\u7528\u7248\u672c\uff1aUbuntu 20.04.06 LTS\/Ubuntu 18.04.06 LTS MySQL 5.7.42 \u4f7f\u7528SSH\u8fde\u63a5 &#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"emotion":"","emotion_color":"","title_style":"","license":"","footnotes":""},"categories":[12,5],"tags":[27,40],"class_list":["post-145","post","type-post","status-publish","format-standard","hentry","category-linux","category-mysql","tag-ubuntu","tag-40"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Ubuntu\u4e2d\u5b9e\u73b0MySQL\u5b9a\u65f6\u5907\u4efd - \u4ed6\u7684\u65e5\u5e38\u65f6\u5149<\/title>\n<meta name=\"description\" content=\"\u5728Ubuntu\u4e2d\uff0c\u4f7f\u7528Ubuntu\u4e2d\u7684\u5b9a\u65f6\u4efb\u52a1\uff0c\u5b9e\u73b0MySQL\u6570\u636e\u5e93\u7684\u5b9a\u65f6\u5907\u4efd\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.17ci.com\/index.php\/ubuntu\u4e2d\u5b9e\u73b0mysql\u5b9a\u65f6\u5907\u4efd\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Ubuntu\u4e2d\u5b9e\u73b0MySQL\u5b9a\u65f6\u5907\u4efd - \u4ed6\u7684\u65e5\u5e38\u65f6\u5149\" \/>\n<meta property=\"og:description\" content=\"\u5728Ubuntu\u4e2d\uff0c\u4f7f\u7528Ubuntu\u4e2d\u7684\u5b9a\u65f6\u4efb\u52a1\uff0c\u5b9e\u73b0MySQL\u6570\u636e\u5e93\u7684\u5b9a\u65f6\u5907\u4efd\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.17ci.com\/index.php\/ubuntu\u4e2d\u5b9e\u73b0mysql\u5b9a\u65f6\u5907\u4efd\/\" \/>\n<meta property=\"og:site_name\" content=\"\u4ed6\u7684\u65e5\u5e38\u65f6\u5149\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-21T03:10:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-03T08:16:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/xieshuoshuo.top\/wp-content\/uploads\/2024\/03\/1710987023-image.png\" \/>\n<meta name=\"author\" content=\"xieshuoshuo\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"xieshuoshuo\" \/>\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\":\"Article\",\"@id\":\"https:\\\/\\\/www.17ci.com\\\/index.php\\\/ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.17ci.com\\\/index.php\\\/ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd\\\/\"},\"author\":{\"name\":\"xieshuoshuo\",\"@id\":\"https:\\\/\\\/www.17ci.com\\\/#\\\/schema\\\/person\\\/2b6d2c8bdf88e9055aba3abf2f2852b8\"},\"headline\":\"Ubuntu\u4e2d\u5b9e\u73b0MySQL\u5b9a\u65f6\u5907\u4efd\",\"datePublished\":\"2024-03-21T03:10:40+00:00\",\"dateModified\":\"2024-06-03T08:16:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.17ci.com\\\/index.php\\\/ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd\\\/\"},\"wordCount\":39,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.17ci.com\\\/#\\\/schema\\\/person\\\/2b6d2c8bdf88e9055aba3abf2f2852b8\"},\"image\":{\"@id\":\"https:\\\/\\\/www.17ci.com\\\/index.php\\\/ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/xieshuoshuo.top\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/1710987023-image.png\",\"keywords\":[\"Ubuntu\",\"\u6570\u636e\u5e93\"],\"articleSection\":[\"Linux\",\"MySQL\"],\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.17ci.com\\\/index.php\\\/ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.17ci.com\\\/index.php\\\/ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd\\\/\",\"url\":\"https:\\\/\\\/www.17ci.com\\\/index.php\\\/ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd\\\/\",\"name\":\"Ubuntu\u4e2d\u5b9e\u73b0MySQL\u5b9a\u65f6\u5907\u4efd - \u4ed6\u7684\u65e5\u5e38\u65f6\u5149\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.17ci.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.17ci.com\\\/index.php\\\/ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.17ci.com\\\/index.php\\\/ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/xieshuoshuo.top\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/1710987023-image.png\",\"datePublished\":\"2024-03-21T03:10:40+00:00\",\"dateModified\":\"2024-06-03T08:16:37+00:00\",\"description\":\"\u5728Ubuntu\u4e2d\uff0c\u4f7f\u7528Ubuntu\u4e2d\u7684\u5b9a\u65f6\u4efb\u52a1\uff0c\u5b9e\u73b0MySQL\u6570\u636e\u5e93\u7684\u5b9a\u65f6\u5907\u4efd\u3002\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.17ci.com\\\/index.php\\\/ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd\\\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.17ci.com\\\/index.php\\\/ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\\\/\\\/www.17ci.com\\\/index.php\\\/ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd\\\/#primaryimage\",\"url\":\"https:\\\/\\\/xieshuoshuo.top\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/1710987023-image.png\",\"contentUrl\":\"https:\\\/\\\/xieshuoshuo.top\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/1710987023-image.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.17ci.com\\\/index.php\\\/ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\\\/\\\/www.17ci.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Ubuntu\u4e2d\u5b9e\u73b0MySQL\u5b9a\u65f6\u5907\u4efd\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.17ci.com\\\/#website\",\"url\":\"https:\\\/\\\/www.17ci.com\\\/\",\"name\":\"\u4ed6\u7684\u65e5\u5e38\u65f6\u5149\",\"description\":\"\u832b\u832b\u4eba\u751f\uff0c\u597d\u50cf\u8352\u91ce...\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.17ci.com\\\/#\\\/schema\\\/person\\\/2b6d2c8bdf88e9055aba3abf2f2852b8\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.17ci.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"zh-Hans\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.17ci.com\\\/#\\\/schema\\\/person\\\/2b6d2c8bdf88e9055aba3abf2f2852b8\",\"name\":\"xieshuoshuo\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\\\/\\\/www.17ci.com\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/1702602405-avatar.jpg\",\"url\":\"https:\\\/\\\/www.17ci.com\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/1702602405-avatar.jpg\",\"contentUrl\":\"https:\\\/\\\/www.17ci.com\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/1702602405-avatar.jpg\",\"width\":1619,\"height\":1619,\"caption\":\"xieshuoshuo\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.17ci.com\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/1702602405-avatar.jpg\"},\"description\":\"\u8fd9\u662f\u4e00\u4e2a\u795e\u79d8\u4eba\u58eb\uff0c\u6216\u8bb8\u7528\u6307\u5b9a\u7684\u65b9\u5f0f\u53ef\u4ee5\u8054\u7cfb\u5230......\",\"sameAs\":[\"https:\\\/\\\/www.17ci.com\"],\"url\":\"https:\\\/\\\/www.17ci.com\\\/index.php\\\/author\\\/xieshuoshuo\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Ubuntu\u4e2d\u5b9e\u73b0MySQL\u5b9a\u65f6\u5907\u4efd - \u4ed6\u7684\u65e5\u5e38\u65f6\u5149","description":"\u5728Ubuntu\u4e2d\uff0c\u4f7f\u7528Ubuntu\u4e2d\u7684\u5b9a\u65f6\u4efb\u52a1\uff0c\u5b9e\u73b0MySQL\u6570\u636e\u5e93\u7684\u5b9a\u65f6\u5907\u4efd\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.17ci.com\/index.php\/ubuntu\u4e2d\u5b9e\u73b0mysql\u5b9a\u65f6\u5907\u4efd\/","og_locale":"zh_CN","og_type":"article","og_title":"Ubuntu\u4e2d\u5b9e\u73b0MySQL\u5b9a\u65f6\u5907\u4efd - \u4ed6\u7684\u65e5\u5e38\u65f6\u5149","og_description":"\u5728Ubuntu\u4e2d\uff0c\u4f7f\u7528Ubuntu\u4e2d\u7684\u5b9a\u65f6\u4efb\u52a1\uff0c\u5b9e\u73b0MySQL\u6570\u636e\u5e93\u7684\u5b9a\u65f6\u5907\u4efd\u3002","og_url":"https:\/\/www.17ci.com\/index.php\/ubuntu\u4e2d\u5b9e\u73b0mysql\u5b9a\u65f6\u5907\u4efd\/","og_site_name":"\u4ed6\u7684\u65e5\u5e38\u65f6\u5149","article_published_time":"2024-03-21T03:10:40+00:00","article_modified_time":"2024-06-03T08:16:37+00:00","og_image":[{"url":"https:\/\/xieshuoshuo.top\/wp-content\/uploads\/2024\/03\/1710987023-image.png","type":"","width":"","height":""}],"author":"xieshuoshuo","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"xieshuoshuo","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"1 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.17ci.com\/index.php\/ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd\/#article","isPartOf":{"@id":"https:\/\/www.17ci.com\/index.php\/ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd\/"},"author":{"name":"xieshuoshuo","@id":"https:\/\/www.17ci.com\/#\/schema\/person\/2b6d2c8bdf88e9055aba3abf2f2852b8"},"headline":"Ubuntu\u4e2d\u5b9e\u73b0MySQL\u5b9a\u65f6\u5907\u4efd","datePublished":"2024-03-21T03:10:40+00:00","dateModified":"2024-06-03T08:16:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.17ci.com\/index.php\/ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd\/"},"wordCount":39,"commentCount":0,"publisher":{"@id":"https:\/\/www.17ci.com\/#\/schema\/person\/2b6d2c8bdf88e9055aba3abf2f2852b8"},"image":{"@id":"https:\/\/www.17ci.com\/index.php\/ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd\/#primaryimage"},"thumbnailUrl":"https:\/\/xieshuoshuo.top\/wp-content\/uploads\/2024\/03\/1710987023-image.png","keywords":["Ubuntu","\u6570\u636e\u5e93"],"articleSection":["Linux","MySQL"],"inLanguage":"zh-Hans","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.17ci.com\/index.php\/ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.17ci.com\/index.php\/ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd\/","url":"https:\/\/www.17ci.com\/index.php\/ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd\/","name":"Ubuntu\u4e2d\u5b9e\u73b0MySQL\u5b9a\u65f6\u5907\u4efd - \u4ed6\u7684\u65e5\u5e38\u65f6\u5149","isPartOf":{"@id":"https:\/\/www.17ci.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.17ci.com\/index.php\/ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd\/#primaryimage"},"image":{"@id":"https:\/\/www.17ci.com\/index.php\/ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd\/#primaryimage"},"thumbnailUrl":"https:\/\/xieshuoshuo.top\/wp-content\/uploads\/2024\/03\/1710987023-image.png","datePublished":"2024-03-21T03:10:40+00:00","dateModified":"2024-06-03T08:16:37+00:00","description":"\u5728Ubuntu\u4e2d\uff0c\u4f7f\u7528Ubuntu\u4e2d\u7684\u5b9a\u65f6\u4efb\u52a1\uff0c\u5b9e\u73b0MySQL\u6570\u636e\u5e93\u7684\u5b9a\u65f6\u5907\u4efd\u3002","breadcrumb":{"@id":"https:\/\/www.17ci.com\/index.php\/ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.17ci.com\/index.php\/ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd\/"]}]},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.17ci.com\/index.php\/ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd\/#primaryimage","url":"https:\/\/xieshuoshuo.top\/wp-content\/uploads\/2024\/03\/1710987023-image.png","contentUrl":"https:\/\/xieshuoshuo.top\/wp-content\/uploads\/2024\/03\/1710987023-image.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.17ci.com\/index.php\/ubuntu%e4%b8%ad%e5%ae%9e%e7%8e%b0mysql%e5%ae%9a%e6%97%b6%e5%a4%87%e4%bb%bd\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.17ci.com\/"},{"@type":"ListItem","position":2,"name":"Ubuntu\u4e2d\u5b9e\u73b0MySQL\u5b9a\u65f6\u5907\u4efd"}]},{"@type":"WebSite","@id":"https:\/\/www.17ci.com\/#website","url":"https:\/\/www.17ci.com\/","name":"\u4ed6\u7684\u65e5\u5e38\u65f6\u5149","description":"\u832b\u832b\u4eba\u751f\uff0c\u597d\u50cf\u8352\u91ce...","publisher":{"@id":"https:\/\/www.17ci.com\/#\/schema\/person\/2b6d2c8bdf88e9055aba3abf2f2852b8"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.17ci.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"zh-Hans"},{"@type":["Person","Organization"],"@id":"https:\/\/www.17ci.com\/#\/schema\/person\/2b6d2c8bdf88e9055aba3abf2f2852b8","name":"xieshuoshuo","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.17ci.com\/wp-content\/uploads\/2023\/12\/1702602405-avatar.jpg","url":"https:\/\/www.17ci.com\/wp-content\/uploads\/2023\/12\/1702602405-avatar.jpg","contentUrl":"https:\/\/www.17ci.com\/wp-content\/uploads\/2023\/12\/1702602405-avatar.jpg","width":1619,"height":1619,"caption":"xieshuoshuo"},"logo":{"@id":"https:\/\/www.17ci.com\/wp-content\/uploads\/2023\/12\/1702602405-avatar.jpg"},"description":"\u8fd9\u662f\u4e00\u4e2a\u795e\u79d8\u4eba\u58eb\uff0c\u6216\u8bb8\u7528\u6307\u5b9a\u7684\u65b9\u5f0f\u53ef\u4ee5\u8054\u7cfb\u5230......","sameAs":["https:\/\/www.17ci.com"],"url":"https:\/\/www.17ci.com\/index.php\/author\/xieshuoshuo\/"}]}},"_links":{"self":[{"href":"https:\/\/www.17ci.com\/index.php\/wp-json\/wp\/v2\/posts\/145","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.17ci.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.17ci.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.17ci.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.17ci.com\/index.php\/wp-json\/wp\/v2\/comments?post=145"}],"version-history":[{"count":18,"href":"https:\/\/www.17ci.com\/index.php\/wp-json\/wp\/v2\/posts\/145\/revisions"}],"predecessor-version":[{"id":171,"href":"https:\/\/www.17ci.com\/index.php\/wp-json\/wp\/v2\/posts\/145\/revisions\/171"}],"wp:attachment":[{"href":"https:\/\/www.17ci.com\/index.php\/wp-json\/wp\/v2\/media?parent=145"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.17ci.com\/index.php\/wp-json\/wp\/v2\/categories?post=145"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.17ci.com\/index.php\/wp-json\/wp\/v2\/tags?post=145"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}