{"id":28707,"date":"2023-01-10T19:16:29","date_gmt":"2023-03-09T11:26:47","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8ubuntu%e4%b8%8a%e5%ae%89%e8%a3%85mysql-8\/"},"modified":"2025-08-12T09:39:43","modified_gmt":"2025-08-12T01:39:43","slug":"%e5%9c%a8ubuntu%e4%b8%8a%e5%ae%89%e8%a3%85mysql-8","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8ubuntu%e4%b8%8a%e5%ae%89%e8%a3%85mysql-8\/","title":{"rendered":"\u5728Ubuntu\u4e0a\u5b89\u88c5MySQL"},"content":{"rendered":"

2020\u5e746\u670828\u65e5 \u8ffd\u52a0\u8bf4\u660e\u4e0d\u540c\u7248\u672c\u7684\u7cfb\u7edf\u53d8\u91cf\u683c\u5f0f\u6709\u6240\u4e0d\u540c\u3002<\/p>\n

\u73af\u5883Ubuntu\u670d\u52a1\u566818.04.3 LTS<\/p>\n

\u5b89\u88c5MySQL<\/p>\n

\u5c06\u5b89\u88c5MySQL\u670d\u52a1\u5668\u548c\u5ba2\u6237\u7aef\u5de5\u5177\u3002<\/p>\n
$<\/span> sudo <\/span>apt install <\/span>mysql-server mysql-client\r\n<\/code><\/pre>\n
\u5b89\u88c5\u5b8c\u6210\u540e\uff0c\u8bf7\u786e\u8ba4\u7248\u672c\u3002<\/p>\n
$<\/span> mysql --version<\/span>\r\nmysql  Ver 14.14 Distrib 5.7.27, for Linux (x86_64) using  EditLine wrapper\r\n<\/span><\/code><\/pre>\n
\u786e\u8ba4\u670d\u52a1\u7684\u542f\u52a8<\/p>\n
$<\/span> sudo <\/span>service mysql status\r\n\u25cf mysql.service - MySQL Community Server\r\n<\/span>   Loaded: loaded (\/lib\/systemd\/system\/mysql.service;<\/span> enabled;<\/span> vendor preset: enabled)<\/span>\r\n   Active: active (running) since Sat 2019-10-12 23:34:41 JST;<\/span> 21min ago\r\n Main PID: 2466 (mysqld)\r\n    Tasks: 27 (limit: 2319)\r\n   CGroup: \/system.slice\/mysql.service\r\n           mq2466 \/usr\/sbin\/mysqld --daemonize --pid-file=\/run\/mysqld\/mysqld.pid\r\n\r\n10\u6708 12 23:34:40 ubuntu-server-18-04 systemd[1]: Starting MySQL Community Server...\r\n10\u6708 12 23:34:41 ubuntu-server-18-04 systemd[1]: Started MySQL Community Server.\r\n<\/span><\/code><\/pre>\n
\u8bbe\u7f6eroot\u7528\u6237\u300c\u65b0\u5bc6\u7801\uff1a\u300d\u300c\u91cd\u65b0\u8f93\u5165\u65b0\u5bc6\u7801\uff1a\u300d\u8bf7\u8f93\u5165root\u7528\u6237\u5bc6\u7801\u3002\u300c\u8bf7\u8f93\u5165 0 = \u4f4e\u30011 = \u4e2d\u7b49\u548c 2 = \u5f3a:\u300d\u8fd9\u4e00\u6bb5\u4f1a\u9020\u6210\u7528\u6237\u521b\u5efa\u5bc6\u7801\u65f6\u7684\u9ebb\u70e6\uff0c\u6240\u4ee5\u6211\u9009\u62e9\u4e86\u4f4e\uff08\u7a0d\u540e\u53ef\u66f4\u6539\uff09\u3002\u7136\u540e\u5c31\u662f\u201cy\u201d\u3002<\/p>\n
$<\/span> sudo <\/span>mysql_secure_installation\r\n\r\nSecuring the MySQL server deployment.\r\n\r\nConnecting to MySQL using a blank password.\r\n\r\nVALIDATE PASSWORD PLUGIN can be used to test passwords\r\nand improve security. It checks the strength of password\r\nand allows the users to set only those passwords which are\r\nsecure enough. Would you like to setup VALIDATE PASSWORD plugin?\r\n\r\nPress y|Y for Yes, any other key for No: y\r\n\r\nThere are three levels of password validation policy:\r\n\r\n<\/span>LOW    Length ><\/span>=<\/span> 8\r\nMEDIUM Length ><\/span>=<\/span> 8, numeric, mixed case<\/span>, and special characters\r\nSTRONG Length ><\/span>=<\/span> 8, numeric, mixed case<\/span>, special characters and dictionary                  file\r\n\r\nPlease enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: 0\r\nPlease set the password for root here.\r\n\r\nNew password:\r\n\r\nRe-enter new password:\r\n\r\nEstimated strength of the password: 50\r\nDo you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y\r\nBy default, a MySQL installation has an anonymous user,\r\nallowing anyone to log into MySQL without having to have\r\na user account created for them. This is intended only for\r\ntesting, and to make the installation go a bit smoother.\r\nYou should remove them before moving into a production\r\nenvironment.\r\n\r\nRemove anonymous users? (Press y|Y for Yes, any other key for No) : y\r\nSuccess.\r\n\r\n\r\nNormally, root should only be allowed to connect from\r\n'localhost'. This ensures that someone cannot guess at\r\nthe root password from the network.\r\n\r\nDisallow root login remotely? (Press y|Y for Yes, any other key for No) : y\r\nSuccess.\r\n\r\nBy default, MySQL comes with a database named 'test' that\r\nanyone can access. This is also intended only for testing,\r\nand should be removed before moving into a production\r\nenvironment.\r\n\r\n\r\nRemove test database and access to it? (Press y|Y for Yes, any other key for No) : y\r\n - Dropping test database...\r\nSuccess.\r\n\r\n - Removing privileges on test database...\r\nSuccess.\r\n\r\nReloading the privilege tables will ensure that all changes\r\nmade so far will take effect immediately.\r\n\r\nReload privilege tables now? (Press y|Y for Yes, any other key for No) : y\r\nSuccess.\r\n\r\nAll done!\r\n<\/span><\/code><\/pre>\n
MySQL\u306b\u30ed\u30b0\u30a4\u30f3<\/p>\n
$<\/span> sudo <\/span>mysql -u<\/span> root\r\nWelcome to the MySQL monitor.  Commands end with ;<\/span> or \\g<\/span>.<\/span>\r\nYour MySQL connection id is 4\r\nServer version: 5.7.27-0ubuntu0.18.04.1 (Ubuntu)\r\n\r\nCopyright (c) 2000, 2019, Oracle and\/or its affiliates. All rights reserved.\r\n\r\nOracle is a registered trademark of Oracle Corporation and\/or its\r\naffiliates. Other names may be trademarks of their respective\r\nowners.\r\n\r\n<\/span>Type 'help;<\/span>' or '<\/span>\\h<\/span>' for help. Type '<\/span>\\c<\/span>' to clear the current input statement.\r\n<\/span>\r\nmysql><\/span>\r\n<\/code><\/pre>\n
\u30e6\u30fc\u30b6\u30fc\u3092\u8ffd\u52a0\u3059\u308b\u524d\u306b\u30d1\u30b9\u30ef\u30fc\u30c9\u30dd\u30ea\u30b7\u30fc\u306e\u8a2d\u5b9a\u3092\u5909\u66f4
\n\u30d1\u30b9\u30ef\u30fc\u30c9\u30dd\u30ea\u30b7\u30fc\u304c\u53b3\u3057\u304f\u306a\u3063\u3066\u3044\u308b\u306e\u3067\u3001\u57fa\u6e96\u3092\u6e80\u305f\u3057\u3066\u3044\u306a\u3044\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5165\u529b\u3059\u308b\u3068\u4e0b\u8a18\u306e\u3088\u3046\u306b\u30a8\u30e9\u30fc\u304c\u3067\u307e\u3059\u3002\u9762\u5012\u306a\u306e\u3067\u57fa\u6e96\u3092\u7de9\u304f\u3057\u307e\u3059\u3002<\/p>\n
ERROR<\/span> 1819<\/span> (<\/span>HY000<\/span>):<\/span> Your<\/span> password<\/span> does<\/span> not<\/span> satisfy<\/span> the<\/span> current<\/span> policy<\/span> requirements<\/span>\r\n<\/code><\/pre>\n
\u5f53\u524d\u7684\u8bbe\u7f6e de sh\u00e8 zh\u00ec)<\/p>\n
mysql<\/span>><\/span> SHOW<\/span> VARIABLES<\/span> LIKE<\/span> 'validate_password%'<\/span>;<\/span>\r\n+<\/span>--------------------------------------+-------+<\/span>\r\n|<\/span> Variable_name<\/span>                        |<\/span> Value<\/span> |<\/span>\r\n+<\/span>--------------------------------------+-------+<\/span>\r\n|<\/span> validate_password_check_user_name<\/span>    |<\/span> OFF<\/span>   |<\/span>\r\n|<\/span> validate_password_dictionary_file<\/span>    |<\/span>       |<\/span>\r\n|<\/span> validate_password_length<\/span>             |<\/span> 8<\/span>     |<\/span>\r\n|<\/span> validate_password_mixed_case_count<\/span>   |<\/span> 1<\/span>     |<\/span>\r\n|<\/span> validate_password_number_count<\/span>       |<\/span> 1<\/span>     |<\/span>\r\n|<\/span> validate_password_policy<\/span>             |<\/span> LOW<\/span>   |<\/span>\r\n|<\/span> validate_password_special_char_count<\/span> |<\/span> 1<\/span>     |<\/span>\r\n+<\/span>--------------------------------------+-------+<\/span>\r\n7<\/span> rows<\/span> in<\/span> set<\/span> (<\/span>0<\/span>.<\/span>00<\/span> sec<\/span>)<\/span>\r\n<\/code><\/pre>\n
\u8bf7\u6ce8\u610f\u4e0d\u540c\u7248\u672c\u7684\u7cfb\u7edf\u53d8\u91cf\u7684\u683c\u5f0f\u53ef\u80fd\u4f1a\u6709\u6240\u4e0d\u540c\u3002<\/p>\n
validate_password.<\/span>xxx\r\n<\/code><\/pre>\n
validate_password_xxx\r\n<\/code><\/pre>\n
\u5c06\u5bc6\u7801\u7684\u5b57\u7b26\u957f\u5ea6\u66f4\u6539\u4e3a5\u4e2a\u5b57\u7b26\uff08\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\u5c06\u957f\u5ea6\u66f4\u6539\u4e3a5\u4e2a\u5b57\u7b26\uff09\u3002<\/p>\n
mysql<\/span>><\/span> set<\/span> global<\/span> validate_password_length<\/span>=<\/span>5<\/span>;<\/span>\r\nQuery<\/span> OK<\/span>,<\/span> 0<\/span> rows<\/span> affected<\/span> (<\/span>0<\/span>.<\/span>00<\/span> sec<\/span>)<\/span>\r\n<\/code><\/pre>\n
\u30dd\u30ea\u30b7\u30fc\u306e\u5909\u66f4\u3092\u884c\u3046\u5834\u5408\uff08\u3053\u306e\u5834\u5408\u306fLOW\u306b\u8a2d\u5b9a\u3057\u3066\u3044\u307e\u3059\uff09<\/p>\n
mysql<\/span>><\/span> set<\/span> global<\/span> validate_password_policy<\/span>=<\/span>LOW<\/span>;<\/span>\r\n<\/code><\/pre>\n
\u8bf7\u786e\u8ba4\u662f\u5426\u5df2\u7ecf\u8fdb\u884c\u4e86\u66f4\u6539\u3002<\/p>\n
mysql<\/span>><\/span> show<\/span> variables<\/span> like<\/span> 'validate_password%'<\/span>;<\/span>\r\n+<\/span>--------------------------------------+-------+<\/span>\r\n|<\/span> Variable_name<\/span>                        |<\/span> Value<\/span> |<\/span>\r\n+<\/span>--------------------------------------+-------+<\/span>\r\n|<\/span> validate_password_check_user_name<\/span>    |<\/span> OFF<\/span>   |<\/span>\r\n|<\/span> validate_password_dictionary_file<\/span>    |<\/span>       |<\/span>\r\n|<\/span> validate_password_length<\/span>             |<\/span> 5<\/span>     |<\/span>\r\n|<\/span> validate_password_mixed_case_count<\/span>   |<\/span> 1<\/span>     |<\/span>\r\n|<\/span> validate_password_number_count<\/span>       |<\/span> 1<\/span>     |<\/span>\r\n|<\/span> validate_password_policy<\/span>             |<\/span> LOW<\/span>   |<\/span>\r\n|<\/span> validate_password_special_char_count<\/span> |<\/span> 1<\/span>     |<\/span>\r\n+<\/span>--------------------------------------+-------+<\/span>\r\n7<\/span> rows<\/span> in<\/span> set<\/span> (<\/span>0<\/span>.<\/span>00<\/span> sec<\/span>)<\/span>\r\n<\/code><\/pre>\n
\u6dfb\u52a0\u7528\u6237\u30e6\u30fc\u30b6\u30fc\u540d\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u306b\u306f\u3001\u4efb\u610f\u306e\u6587\u5b57\u5217\u3092\u8a2d\u5b9a\u3057\u3001\u30db\u30b9\u30c8\u540d\u306b\u306fMySQL\u3078\u63a5\u7d9a\u3059\u308b\u30db\u30b9\u30c8\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n
mysql<\/span>><\/span> CREATE<\/span> USER<\/span> '\u30e6\u30fc\u30b6\u30fc\u540d'<\/span>@<\/span>'\u30db\u30b9\u30c8\u540d'<\/span> IDENTIFIED<\/span> BY<\/span> '\u30d1\u30b9\u30ef\u30fc\u30c9'<\/span>;<\/span>\r\n<\/code><\/pre>\n
\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u7528\u6237\u540d\u662f’houtarou’\uff0c\u4e3b\u673a\u540d\u662f’localhost’\uff0c\u5bc6\u7801\u662f’kirin’\u3002<\/p>\n
mysql<\/span>><\/span> CREATE<\/span> USER<\/span> 'houtarou'<\/span>@<\/span>'localhost'<\/span> IDENTIFIED<\/span> BY<\/span> 'kirin'<\/span>;<\/span>\r\nQuery<\/span> OK<\/span>,<\/span> 0<\/span> rows<\/span> affected<\/span> (<\/span>0<\/span>.<\/span>00<\/span> sec<\/span>)<\/span>\r\n<\/code><\/pre>\n
\u663e\u793a\u7528\u6237\u6e05\u5355
\n‘\u5df2\u6dfb\u52a0\u4e86”houtarou”\u3002<\/p>\n
mysql<\/span>><\/span> select<\/span> user<\/span>,<\/span>host<\/span> from<\/span> mysql<\/span>.<\/span>user<\/span>;<\/span>\r\n+<\/span>------------------+-----------+<\/span>\r\n|<\/span> user<\/span>             |<\/span> host<\/span>      |<\/span>\r\n+<\/span>------------------+-----------+<\/span>\r\n|<\/span> debian<\/span>-<\/span>sys<\/span>-<\/span>maint<\/span> |<\/span> localhost<\/span> |<\/span>\r\n|<\/span> houtarou<\/span>         |<\/span> localhost<\/span> |<\/span>\r\n|<\/span> mysql<\/span>.<\/span>session<\/span>    |<\/span> localhost<\/span> |<\/span>\r\n|<\/span> mysql<\/span>.<\/span>sys<\/span>        |<\/span> localhost<\/span> |<\/span>\r\n|<\/span> root<\/span>             |<\/span> localhost<\/span> |<\/span>\r\n+<\/span>------------------+-----------+<\/span>\r\n5<\/span> rows<\/span> in<\/span> set<\/span> (<\/span>0<\/span>.<\/span>00<\/span> sec<\/span>)<\/span>\r\n<\/code><\/pre>\n
\u6388\u4e88\u6743\u9650\u6388\u4e88\u6240\u6709\u6743\u9650\u3002\u540c\u65f6\uff0c\u82e5\u5c06[\u6570\u636e\u5e93\u6216\u8868]\u8bbe\u4e3a*.*\uff0c\u5219\u9002\u7528\u8303\u56f4\u5c06\u6db5\u76d6\u6240\u6709\u6570\u636e\u5e93\u548c\u8868\u3002<\/p>\n
mysql<\/span>><\/span> GRANT<\/span> all<\/span> ON<\/span> [<\/span>DB<\/span> or<\/span> Table<\/span>]<\/span> TO<\/span> '\u30e6\u30fc\u30b6\u30fc\u540d'<\/span>@<\/span>'\u30db\u30b9\u30c8\u540d'<\/span>;<\/span>\r\n<\/code><\/pre>\n
\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u7528\u6237\u540d\u662f’houtarou’\uff0c\u4e3b\u673a\u540d\u662f’localhost’\u3002\u8fd9\u9002\u7528\u4e8e\u6240\u6709\u60c5\u51b5\u3002<\/p>\n
mysql<\/span>><\/span> GRANT<\/span> all<\/span> ON<\/span> *<\/span>.<\/span>*<\/span> TO<\/span> 'houtarou'<\/span>@<\/span>'localhost'<\/span>;<\/span>\r\nQuery<\/span> OK<\/span>,<\/span> 0<\/span> rows<\/span> affected<\/span> (<\/span>0<\/span>.<\/span>00<\/span> sec<\/span>)<\/span>\r\n<\/code><\/pre>\n
\u6a29\u9650\u306e\u78ba\u8a8d<\/p>\n
mysql<\/span>><\/span> SHOW<\/span> GRANTS<\/span> FOR<\/span> 'houtarou'<\/span>@<\/span>'localhost'<\/span>;<\/span>\r\n+<\/span>-------------------------------------------------------+<\/span>\r\n|<\/span> Grants<\/span> for<\/span> houtarou<\/span>@<\/span>localhost<\/span>                         |<\/span>\r\n+<\/span>-------------------------------------------------------+<\/span>\r\n|<\/span> GRANT<\/span> ALL<\/span> PRIVILEGES<\/span> ON<\/span> *<\/span>.<\/span>*<\/span> TO<\/span> 'houtarou'<\/span>@<\/span>'localhost'<\/span> |<\/span>\r\n+<\/span>-------------------------------------------------------+<\/span>\r\n1<\/span> row<\/span> in<\/span> set<\/span> (<\/span>0<\/span>.<\/span>00<\/span> sec<\/span>)<\/span>\r\n<\/code><\/pre>\n
\u30e6\u30fc\u30b6\u30fc\u306e\u524a\u9664<\/p>\n
mysql<\/span>><\/span> DROP<\/span> USER<\/span> '\u30e6\u30fc\u30b6\u30fc\u540d'<\/span>@<\/span>'\u30db\u30b9\u30c8\u540d'<\/span>;<\/span>\r\n<\/code><\/pre>\n
\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u7528\u6237\u540d\u4e3a’houtarou’\uff0c\u4e3b\u673a\u540d\u4e3a’localhost’\u3002<\/p>\n
mysql<\/span>><\/span> DROP<\/span> USER<\/span> 'houtarou'<\/span>@<\/span>'localhost'<\/span>;<\/span>\r\nQuery<\/span> OK<\/span>,<\/span> 0<\/span> rows<\/span> affected<\/span> (<\/span>0<\/span>.<\/span>01<\/span> sec<\/span>)<\/span>\r\n<\/code><\/pre>\n
\u786e\u8ba4\u662f\u5426\u5df2\u5220\u9664<\/p>\n
mysql<\/span>><\/span> select<\/span> user<\/span>,<\/span>host<\/span> from<\/span> mysql<\/span>.<\/span>user<\/span>;<\/span>\r\n+<\/span>------------------+-----------+<\/span>\r\n|<\/span> user<\/span>             |<\/span> host<\/span>      |<\/span>\r\n+<\/span>------------------+-----------+<\/span>\r\n|<\/span> debian<\/span>-<\/span>sys<\/span>-<\/span>maint<\/span> |<\/span> localhost<\/span> |<\/span>\r\n|<\/span> mysql<\/span>.<\/span>session<\/span>    |<\/span> localhost<\/span> |<\/span>\r\n|<\/span> mysql<\/span>.<\/span>sys<\/span>        |<\/span> localhost<\/span> |<\/span>\r\n|<\/span> root<\/span>             |<\/span> localhost<\/span> |<\/span>\r\n+<\/span>------------------+-----------+<\/span>\r\n4<\/span> rows<\/span> in<\/span> set<\/span> (<\/span>0<\/span>.<\/span>00<\/span> sec<\/span>)<\/span>\r\n<\/code><\/pre>\n
\u4ee5\u4e0a\u3067\u3059\u3002<\/p>\n
\u3082\u3057\u9593\u9055\u3044\u306a\u3069\u3042\u308a\u307e\u3057\u305f\u3089\u3001\u6559\u3048\u3066\u9802\u3051\u308b\u3068\u5e78\u3044\u3067\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
2020\u5e746\u670828\u65e5 \u8ffd\u52a0\u8bf4\u660e\u4e0d\u540c\u7248\u672c\u7684\u7cfb\u7edf\u53d8\u91cf\u683c\u5f0f\u6709\u6240\u4e0d\u540c\u3002 \u73af\u5883Ubuntu\u670d\u52a1\u566818.04.3 LTS  […]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[227],"class_list":["post-28707","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-227"],"yoast_head":"\n\u5728Ubuntu\u4e0a\u5b89\u88c5MySQL - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"\u5173\u4e8e\u5728Ubuntu\u4e0a\u5b89\u88c5MySQL\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\/\u5728ubuntu\u4e0a\u5b89\u88c5mysql-8\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u5728Ubuntu\u4e0a\u5b89\u88c5MySQL\" \/>\n<meta property=\"og:description\" content=\"\u5173\u4e8e\u5728Ubuntu\u4e0a\u5b89\u88c5MySQL\u7684\u6280\u672f\u6587\u7ae0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5728ubuntu\u4e0a\u5b89\u88c5mysql-8\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-09T11:26:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-12T01:39:43+00:00\" \/>\n<meta name=\"author\" content=\"\u6e05, \u626c\" \/>\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, \u626c\" \/>\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%a8ubuntu%e4%b8%8a%e5%ae%89%e8%a3%85mysql-8\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8ubuntu%e4%b8%8a%e5%ae%89%e8%a3%85mysql-8\/\",\"name\":\"\u5728Ubuntu\u4e0a\u5b89\u88c5MySQL - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-03-09T11:26:47+00:00\",\"dateModified\":\"2025-08-12T01:39:43+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461\"},\"description\":\"\u5173\u4e8e\u5728Ubuntu\u4e0a\u5b89\u88c5MySQL\u7684\u6280\u672f\u6587\u7ae0\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8ubuntu%e4%b8%8a%e5%ae%89%e8%a3%85mysql-8\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8ubuntu%e4%b8%8a%e5%ae%89%e8%a3%85mysql-8\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8ubuntu%e4%b8%8a%e5%ae%89%e8%a3%85mysql-8\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u5728Ubuntu\u4e0a\u5b89\u88c5MySQL\"}]},{\"@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\/cb5556d2501da73d864cac945e8d9461\",\"name\":\"\u6e05, \u626c\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g\",\"caption\":\"\u6e05, \u626c\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyang\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8ubuntu%e4%b8%8a%e5%ae%89%e8%a3%85mysql-8\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u5728Ubuntu\u4e0a\u5b89\u88c5MySQL - Blog - Silicon Cloud","description":"\u5173\u4e8e\u5728Ubuntu\u4e0a\u5b89\u88c5MySQL\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\/\u5728ubuntu\u4e0a\u5b89\u88c5mysql-8\/","og_locale":"zh_CN","og_type":"article","og_title":"\u5728Ubuntu\u4e0a\u5b89\u88c5MySQL","og_description":"\u5173\u4e8e\u5728Ubuntu\u4e0a\u5b89\u88c5MySQL\u7684\u6280\u672f\u6587\u7ae0","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u5728ubuntu\u4e0a\u5b89\u88c5mysql-8\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-03-09T11:26:47+00:00","article_modified_time":"2025-08-12T01:39:43+00:00","author":"\u6e05, \u626c","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u6e05, \u626c","\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%a8ubuntu%e4%b8%8a%e5%ae%89%e8%a3%85mysql-8\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8ubuntu%e4%b8%8a%e5%ae%89%e8%a3%85mysql-8\/","name":"\u5728Ubuntu\u4e0a\u5b89\u88c5MySQL - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-03-09T11:26:47+00:00","dateModified":"2025-08-12T01:39:43+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461"},"description":"\u5173\u4e8e\u5728Ubuntu\u4e0a\u5b89\u88c5MySQL\u7684\u6280\u672f\u6587\u7ae0","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8ubuntu%e4%b8%8a%e5%ae%89%e8%a3%85mysql-8\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8ubuntu%e4%b8%8a%e5%ae%89%e8%a3%85mysql-8\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8ubuntu%e4%b8%8a%e5%ae%89%e8%a3%85mysql-8\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u5728Ubuntu\u4e0a\u5b89\u88c5MySQL"}]},{"@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\/cb5556d2501da73d864cac945e8d9461","name":"\u6e05, \u626c","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g","caption":"\u6e05, \u626c"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyang\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8ubuntu%e4%b8%8a%e5%ae%89%e8%a3%85mysql-8\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/28707","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\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=28707"}],"version-history":[{"count":3,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/28707\/revisions"}],"predecessor-version":[{"id":111374,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/28707\/revisions\/111374"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=28707"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=28707"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=28707"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}