{"id":53,"date":"2020-10-26T14:11:30","date_gmt":"2020-10-26T14:11:30","guid":{"rendered":"https:\/\/www.westdl.cn\/?page_id=53"},"modified":"2022-10-26T00:29:04","modified_gmt":"2022-10-26T00:29:04","slug":"mysql%e8%b5%84%e6%ba%90","status":"publish","type":"page","link":"https:\/\/www.unoxc.cn\/?page_id=53","title":{"rendered":"MySQL\u8d44\u6e90"},"content":{"rendered":"\n<pre class=\"wp-block-preformatted\">mysql\u5b98\u7f51\uff1a<a rel=\"noreferrer noopener\" href=\"https:\/\/dev.mysql.com\/downloads\/\" target=\"_blank\">https:\/\/dev.mysql.com\/downloads\/<\/a><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><span class=\"has-inline-color has-luminous-vivid-orange-color\">Windows setup:<\/span>\n<strong>HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Services\\EventLog\\Application<\/strong>\n<strong>HKEY_LOCAL_MACHINE\\SYSTEM\\ControlSet001\\Services\\EventLog\\Application<\/strong>\n<strong>HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Services<\/strong>\n\n<a rel=\"noreferrer noopener\" href=\"https:\/\/support.microsoft.com\/zh-cn\/help\/2977003\/the-latest-supported-visual-c-downloads\" target=\"_blank\">https:\/\/support.microsoft.com\/zh-cn\/help\/2977003\/the-latest-supported-visual-c-downloads<\/a><\/pre>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<pre class=\"wp-block-preformatted\"><em><span class=\"has-inline-color has-luminous-vivid-orange-color\">Ubuntu firewall setup:<\/span><\/em>\nsudo ufw status\uff5csudo ufw enable\uff5csudo ufw allow\/deny [service]<\/pre>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<pre class=\"wp-block-preformatted\"><span class=\"has-inline-color has-luminous-vivid-orange-color\">Redhat firewall setup:<\/span><a href=\"Redhat: redhat firewall setup\"> <\/a>\nfirewall-cmd --add-service=mysql --permanent\nfirewall-cmd --reload<\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\"><span class=\"has-inline-color has-luminous-vivid-orange-color\">Redhat <em>service add\/remove\/contorl:<\/em><\/span>\n<em>chkconfig --add\/del mysqld<\/em>\n<em>chkconfig mysqld on<\/em>\n<em>chkconfig --list mysqld<\/em><\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\">groupadd mysql\nuseradd -r -g mysql -s \/bin\/false mysql\nmkdir mysql-files\nchown mysql:mysql mysql-files\nchmod 750 mysql-files\nbin\/mysqld --initialize --user=mysql\nbin\/mysql_ssl_rsa_setup\ncp support-files\/mysql.server \/etc\/init.d\/mysqld\nchkconfig --add mysqld\nchkconfig mysqld on\nservice mysqld start<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>mysql\u5b98\u7f51\uff1ahttps:\/\/dev.mysql.com\/downloads\/ Windows setup: HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Services\\EventLog\\Application HKEY_LOCAL_MACHINE\\SYSTEM\\ControlSet001\\Services\\EventLog\\Application HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Services https:\/\/support.microsoft.com\/zh-cn\/help\/2977003\/the-latest-supported-visual-c-downloads Ubuntu firewall setup: sudo ufw status\uff5csudo ufw enable\uff5csudo ufw allow\/deny [service] Redhat firewall setup: firewall-cmd &#8211;add-service=mysql &#8211;permanent firewall-cmd &#8211;reload Redhat service add\/remove\/contorl: chkconfig &#8211;add\/del mysqld chkconfig mysqld on chkconfig &#8211;list mysqld groupadd mysql useradd -r -g mysql -s \/bin\/false mysql mkdir mysql-files chown mysql:mysql mysql-files chmod 750 mysql-files [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/www.unoxc.cn\/index.php?rest_route=\/wp\/v2\/pages\/53"}],"collection":[{"href":"https:\/\/www.unoxc.cn\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.unoxc.cn\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.unoxc.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.unoxc.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=53"}],"version-history":[{"count":36,"href":"https:\/\/www.unoxc.cn\/index.php?rest_route=\/wp\/v2\/pages\/53\/revisions"}],"predecessor-version":[{"id":613,"href":"https:\/\/www.unoxc.cn\/index.php?rest_route=\/wp\/v2\/pages\/53\/revisions\/613"}],"wp:attachment":[{"href":"https:\/\/www.unoxc.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=53"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}