{"id":3977,"date":"2021-11-25T22:57:59","date_gmt":"2021-11-26T06:57:59","guid":{"rendered":"https:\/\/www.xh86.me\/?p=3977"},"modified":"2021-11-25T23:08:38","modified_gmt":"2021-11-26T07:08:38","slug":"centos-8-x%e5%ae%89%e8%a3%85mysql-8-x%e5%b9%b6%e5%88%9b%e5%bb%ba%e6%95%b0%e6%8d%ae%e5%ba%93%e6%b7%bb%e5%8a%a0%e7%94%a8%e6%88%b7%e5%af%b9%e7%94%a8%e6%88%b7%e8%bf%9b%e8%a1%8c%e6%8e%88%e6%9d%83","status":"publish","type":"post","link":"https:\/\/www.xh86.me\/?p=3977","title":{"rendered":"CentOS 8.x\u5b89\u88c5MySQL 8.x\u5e76\u521b\u5efa\u6570\u636e\u5e93\u6dfb\u52a0\u7528\u6237\u5bf9\u7528\u6237\u8fdb\u884c\u6388\u6743"},"content":{"rendered":"<div class=\"wxsyncmain\">\n<p style=\"text-align: center;\"><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/www.xh86.me\/wp-content\/uploads\/2021\/11\/wxsync-2021-11-24e7510613f5d15d640bf3d5534755f8.jpeg'><img class=\"lazyload lazyload-style-1\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  decoding=\"async\" class=\"rich_pages\" data-original=\"https:\/\/www.xh86.me\/wp-content\/uploads\/2021\/11\/wxsync-2021-11-24e7510613f5d15d640bf3d5534755f8.jpeg\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" data-galleryid=\"\" data-ratio=\"0.42592592592592593\" data-s=\"300,640\" data-type=\"jpeg\" data-w=\"1080\" \/><\/div><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\"><span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\"><strong>\u672c\u6587CentOS\u7248\u672c\uff1aCentOS 8.x<\/strong><\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\"><span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\"><strong>MySQL\u7248\u672c\uff1amysql-8.0.x<\/strong><\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\"><span style=\"background: transparent; color: #ff0000; border: 0px initial initial;\">\u4e00\u3001\u9632\u706b\u5899\u914d\u7f6e<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">CentOS \u4ece7.x\u5f00\u59cb\u9ed8\u8ba4\u4f7f\u7528\u7684\u662ffirewall\u4f5c\u4e3a\u9632\u706b\u5899\uff0c\u8fd9\u91cc\u6539\u4e3aiptables\u9632\u706b\u5899\u3002<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">1\u3001\u5173\u95edfirewall\uff1a<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">systemctl stop firewalld.service #\u505c\u6b62firewall<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">systemctl disable firewalld.service #\u7981\u6b62firewall\u5f00\u673a\u542f\u52a8<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">systemctl mask firewalld<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">systemctl stop firewalld<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">yum remove firewalld<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">2\u3001\u5b89\u88c5iptables\u9632\u706b\u5899<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">yum install iptables-services #\u5b89\u88c5<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">vi \/etc\/sysconfig\/iptables\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u7f16\u8f91\u9632\u706b\u5899\u914d\u7f6e\u6587\u4ef6\uff0c\u5f00\u53d1mysql\u9ed8\u8ba4\u7aef\u53e33306<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\"># sample configuration for iptables service<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\"># you can edit this manually or use system-config-firewall<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\"># please do not ask us to add additional ports\/services to this default configuration<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">*filter<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">:INPUT ACCEPT [0:0]<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">:FORWARD ACCEPT [0:0]<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">:OUTPUT ACCEPT [0:0]<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">-A INPUT -m state &#8211;state RELATED,ESTABLISHED -j ACCEPT<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">-A INPUT -p icmp -j ACCEPT<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">-A INPUT -i lo -j ACCEPT<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">-A INPUT -p tcp -m state &#8211;state NEW -m tcp &#8211;dport 22 -j ACCEPT<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\"><span style=\"background: transparent; color: #ff0000; border: 0px initial initial;\">-A INPUT -p tcp -m state &#8211;state NEW -m tcp &#8211;dport 3306 -j ACCEPT<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">-A INPUT -j REJECT &#8211;reject-with icmp-host-prohibited<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">-A FORWARD -j REJECT &#8211;reject-with icmp-host-prohibited<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">COMMIT<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">:wq! #\u4fdd\u5b58\u9000\u51fa<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">systemctl restart iptables.service #\u6700\u540e\u91cd\u542f\u9632\u706b\u5899\u4f7f\u914d\u7f6e\u751f\u6548<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">systemctl enable iptables.service #\u8bbe\u7f6e\u9632\u706b\u5899\u5f00\u673a\u542f\u52a8<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">\/usr\/libexec\/iptables\/iptables.init restart #\u91cd\u542f\u9632\u706b\u5899<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">\u4e8c\u3001\u5173\u95edSELINUX<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">vi \/etc\/selinux\/config<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">#SELINUX=enforcing #\u6ce8\u91ca\u6389<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">#SELINUXTYPE=targeted #\u6ce8\u91ca\u6389<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">SELINUX=disabled #\u589e\u52a0<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">:wq! #\u4fdd\u5b58\u9000\u51fa<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">setenforce 0 #\u4f7f\u914d\u7f6e\u7acb\u5373\u751f\u6548<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">\u4e09 \u3001\u7cfb\u7edf\u7ea6\u5b9a<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">\u8f6f\u4ef6\u6e90\u4ee3\u7801\u5305\u5b58\u653e\u4f4d\u7f6e\uff1a\/usr\/local\/src<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">\u6e90\u7801\u5305\u7f16\u8bd1\u5b89\u88c5\u4f4d\u7f6e\uff1a\/usr\/local\/\u8f6f\u4ef6\u540d\u5b57<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">\u56db\u3001\u4e0b\u8f7d\u8f6f\u4ef6\u5305<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">1\u3001mysql<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">https:\/\/cdn.mysql.com\/\/Downloads\/MySQL-8.0\/mysql-8.0.18.tar.gz<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">2\u3001rpcsvc-proto #CentOS 8\u7f16\u8bd1\u5b89\u88c5MySQL8\u9700\u8981<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">https:\/\/github.com\/thkukuk\/rpcsvc-proto\/releases\/download\/v1.4\/rpcsvc-proto-1.4.tar.gz<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">3\u3001boost_1_70_0 #CentOS 8\u7f16\u8bd1\u5b89\u88c5MySQL8\u9700\u8981<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">https:\/\/dl.bintray.com\/boostorg\/release\/1.70.0\/source\/boost_1_70_0.tar.gz<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">4\u3001cmake #\u7f16\u8bd1\u5b89\u88c5MySQL\u9700\u8981<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">https:\/\/github.com\/Kitware\/CMake\/releases\/download\/v3.15.4\/cmake-3.15.4.tar.gz<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">\u4e94\u3001\u5b89\u88c5\u7f16\u8bd1\u5de5\u5177\u53ca\u5e93\u6587\u4ef6\uff08\u4f7f\u7528yum\u547d\u4ee4\u5b89\u88c5\uff09<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">yum install apr* autoconf automake bison bzip2 bzip2* cpp curl curl-devel fontconfig fontconfig-devel freetype-devel gcc gcc-c++ gd gd-devel gettext gettext-devel glibc kernel kernel-headers keyutils keyutils-libs-devel krb5-devel libcom_err-devel libpng libpng-devel libjpeg* libsepol-devel libselinux-devel libstdc++-devel libtool* libgomp libxml2 libxml2-devel libXpm* libxml* libXaw-devel libXmu-devel libtiff libtiff* make openssl openssl-devel patch pcre-devel perl php-common php-gd policycoreutils telnet wget zlib-devel ncurses-devel libtirpc-devel gtk* ntpstat na* bison*<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\"><strong style=\"color: #ff0000; text-indent: 2em;\">\u5b89\u88c5\u7bc7<\/strong><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">\u4ee5\u4e0b\u662f\u7528putty\u5de5\u5177\u8fdc\u7a0b\u767b\u5f55\u5230\u670d\u52a1\u5668\uff0c\u5728\u547d\u4ee4\u884c\u4e0b\u9762\u64cd\u4f5c\u7684<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">\u4e00\u3001\u5b89\u88c5MySQL<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">1\u3001\u5b89\u88c5rpcsvc-proto<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">cd \/usr\/local\/src<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">tar zxvf rpcsvc-proto-1.4.tar.gz<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">cd rpcsvc-proto-1.4<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">.\/configure<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">make<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">make install<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">2\u3001\u5b89\u88c5cmake<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">cd \/usr\/local\/src<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">tar zxvf cmake-3.15.4.tar.gz<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">cd cmake-3.15.4<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">.\/configure<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">make<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">make install<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">3\u3001\u5b89\u88c5MySQL<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">cd \/usr\/local\/src<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">mkdir -p \/usr\/local\/boost<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">cp boost_1_70_0.tar.gz \/usr\/local\/boost<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">groupadd mysql #\u6dfb\u52a0mysql\u7ec4<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">useradd -g mysql mysql -s \/bin\/false #\u521b\u5efa\u7528\u6237mysql\u5e76\u52a0\u5165\u5230mysql\u7ec4\uff0c\u4e0d\u5141\u8bb8mysql\u7528\u6237\u76f4\u63a5\u767b\u5f55\u7cfb\u7edf<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">mkdir -p \/data\/mysql #\u521b\u5efaMySQL\u6570\u636e\u5e93\u5b58\u653e\u76ee\u5f55<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">chown -R mysql:mysql \/data\/mysql #\u8bbe\u7f6eMySQL\u6570\u636e\u5e93\u5b58\u653e\u76ee\u5f55\u6743\u9650<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">mkdir -p \/usr\/local\/mysql #\u521b\u5efaMySQL\u5b89\u88c5\u76ee\u5f55<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">cd \/usr\/local\/src #\u8fdb\u5165\u8f6f\u4ef6\u5305\u5b58\u653e\u76ee\u5f55<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">tar zxvf mysql-8.0.18.tar.gz #\u89e3\u538b<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">cd mysql-8.0.18 #\u8fdb\u5165\u76ee\u5f55<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">cmake . -DCMAKE_INSTALL_PREFIX=\/usr\/local\/mysql -DINSTALL_DATADIR=\/data\/mysql -DMYSQL_USER=mysql -DMYSQL_UNIX_ADDR=\/tmp\/mysqld.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_EMBEDDED_SERVER=1 -DFORCE_INSOURCE_BUILD=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 -DEXTRA_CHARSETS=all -DWITH_BOOST=\/usr\/local\/boost<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">make #\u7f16\u8bd1<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">make install #\u5b89\u88c5<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">rm -rf \/etc\/my.cnf\u00a0\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u5220\u9664\u7cfb\u7edf\u9ed8\u8ba4\u7684\u914d\u7f6e\u6587\u4ef6\uff08\u5982\u679c\u9ed8\u8ba4\u6ca1\u6709\u5c31\u4e0d\u7528\u5220\u9664\uff09<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">cd \/usr\/local\/mysql\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u8fdb\u5165MySQL\u5b89\u88c5\u76ee\u5f55<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">.\/bin\/mysqld &#8211;user=mysql &#8211;initialize &#8211;basedir=\/usr\/local\/mysql &#8211;datadir=\/data\/mysql\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u751f\u6210mysql\u7cfb\u7edf\u6570\u636e\u5e93<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\"><span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\"><span style=\"background: transparent; color: #ff0000; border: 0px initial initial;\">&#8211;initialize<\/span>\u8868\u793a\u9ed8\u8ba4\u751f\u6210\u5bc6\u7801,\u00a0<span style=\"background: transparent; color: #ff0000; border: 0px initial initial;\">&#8211;initialize-insecure<\/span>\u00a0\u8868\u793a\u4e0d\u751f\u6210\u5bc6\u7801, \u5bc6\u7801\u4e3a\u7a7a\u3002<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">#\u770b\u5230\u8fd9\u4e00\u884c[Note] [MY-010454] [Server] A temporary password is generated for root@localhost:\u00a0<span style=\"background: transparent; color: #ff0000; border: 0px initial initial;\">!w1YKyVFFa?-<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">\u8bb0\u5f55\u4e0b\u81ea\u52a8\u751f\u6210\u7684mysql\u7ba1\u7406\u5458root\u8d26\u53f7\u767b\u5f55\u5bc6\u7801<span style=\"background: transparent; color: #ff0000; border: 0px initial initial;\">!w1YKyVFFa?-<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">vi \/usr\/local\/mysql\/my.cnf \u00a0\u00a0#mysql 8.x\u9ed8\u8ba4\u6ca1\u6709\u914d\u7f6e\u6587\u4ef6\uff0c\u6211\u4eec\u81ea\u5df1\u521b\u5efa\u4e00\u4e2a\u3002<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">[client]<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">port=3306<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">socket=\/tmp\/mysql.sock<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">[mysqld]<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">port=3306<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">user = mysql<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">socket=\/tmp\/mysql.sock<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">tmpdir = \/tmp<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">key_buffer_size=16M<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">max_allowed_packet=128M<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">default_authentication_plugin=mysql_native_password\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u8bbe\u7f6e\u52a0\u5bc6\u65b9\u5f0f\u4e3amysql_native_password\uff0cMySQL 8.0\u9ed8\u8ba4\u4f7f\u7528caching_sha2_password\u52a0\u5bc6\u3002<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">open_files_limit = 60000<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">explicit_defaults_for_timestamp<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">server-id = 1<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">character-set-server = utf8<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">federated<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">max_connections = 1000<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">max_connect_errors = 100000<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">interactive_timeout = 86400<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">wait_timeout = 86400<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">sync_binlog=0<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">back_log=100<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">default-storage-engine = InnoDB<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">log_slave_updates = 1<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">[mysqldump]<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">quick<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">[client]<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\"># The following password will be sent to all standard MySQL clients<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">password=&#8221;my password&#8221;<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">[mysqld-8.0]<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">sql_mode=TRADITIONAL<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">[mysqladmin]<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">force<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">[mysqld]<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">key_buffer_size=16M<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">:wq!\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u4fdd\u5b58\u9000\u51fa<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">ln -s \/usr\/local\/mysql\/my.cnf \/etc\/my.cnf\u00a0\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u6dfb\u52a0\u5230\/etc\u76ee\u5f55\u7684\u8f6f\u8fde\u63a5<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">cp \/usr\/local\/mysql\/support-files\/mysql.server \/etc\/rc.d\/init.d\/mysqld\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u628aMysql\u52a0\u5165\u7cfb\u7edf\u542f\u52a8<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">chmod 755 \/etc\/init.d\/mysqld<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">\u00a0#\u589e\u52a0\u6267\u884c\u6743\u9650<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">chkconfig mysqld on\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u52a0\u5165\u5f00\u673a\u542f\u52a8<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">vi \/etc\/rc.d\/init.d\/mysqld\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u7f16\u8f91<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">basedir=\/usr\/local\/mysql\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#MySQL\u7a0b\u5e8f\u5b89\u88c5\u8def\u5f84<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">datadir=\/data\/mysql\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#MySQl\u6570\u636e\u5e93\u5b58\u653e\u76ee\u5f55<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">:wq!\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u4fdd\u5b58\u9000\u51fa<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">service mysqld start\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u542f\u52a8<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">vi \/etc\/profile\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u628amysql\u670d\u52a1\u52a0\u5165\u7cfb\u7edf\u73af\u5883\u53d8\u91cf\uff1a\u5728\u6700\u540e\u6dfb\u52a0\u4e0b\u9762\u8fd9\u4e00\u884c<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">export PATH=$PATH:\/usr\/local\/mysql\/bin<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">:wq!\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u4fdd\u5b58\u9000\u51fa<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">source \/etc\/profile\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u4f7f\u914d\u7f6e\u7acb\u523b\u751f\u6548<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\"><span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">\u4e0b\u9762\u8fd9\u4e24\u884c\u628amyslq\u7684\u5e93\u6587\u4ef6\u94fe\u63a5\u5230\u7cfb\u7edf\u9ed8\u8ba4\u7684\u4f4d\u7f6e\uff0c\u8fd9\u6837\u4f60\u5728\u7f16\u8bd1\u7c7b\u4f3cPHP\u7b49\u8f6f\u4ef6\u65f6\u53ef\u4ee5\u4e0d\u7528\u6307\u5b9amysql\u7684\u5e93\u6587\u4ef6\u5730\u5740\u3002<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">ln -s \/usr\/local\/mysql\/lib\/mysql \/usr\/lib\/mysql<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">ln -s \/usr\/local\/mysql\/include\/mysql \/usr\/include\/mysql<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">mkdir \/var\/lib\/mysql\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u521b\u5efa\u76ee\u5f55<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">ln -s \/tmp\/mysql.sock \/var\/lib\/mysql\/mysql.sock\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u6dfb\u52a0\u8f6f\u94fe\u63a5<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">mysql -u root -p<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">\u00a0 #\u8f93\u5165\u4e4b\u524d\u751f\u6210\u7684\u5bc6\u7801<span style=\"background: transparent; color: #ff0000; border: 0px initial initial;\">!w1YKyVFFa?-<\/span>\uff0c\u56de\u8f66<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">ALTER USER &#8216;<span style=\"background: transparent; color: #ff0000; border: 0px initial initial;\">root<\/span>&#8216;@&#8217;<span style=\"background: transparent; color: #ff0000; border: 0px initial initial;\">localhost<\/span>&#8216; IDENTIFIED BY &#8216;<span style=\"background: transparent; color: #ff0000; border: 0px initial initial;\">123456<\/span>&#8216; PASSWORD EXPIRE NEVER;\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u4fee\u6539\u5bc6\u7801\uff0c<span style=\"background: transparent; color: #ff0000; border: 0px initial initial;\">NEVER<\/span>\u8868\u793a\u5bc6\u7801\u6c38\u4e0d\u8fc7\u671f<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">ALTER USER &#8216;root&#8217;@&#8217;localhost&#8217; IDENTIFIED\u00a0<span style=\"background: transparent; color: #ff0000; border: 0px initial initial;\">WITH mysql_native_password<\/span>\u00a0BY &#8216;123456&#8217; PASSWORD EXPIRE NEVER;\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u4f7f\u7528WITH mysql_native_password\u52a0\u5bc6<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\"><span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#MySQL 8.0\u52a0\u5bc6\u65b9\u5f0f\u4ecemysql_native_password \u66f4\u6539\u4e3a caching_sha2_password\uff0cmysql8.x\u4e4b\u524d\u7684\u5ba2\u6237\u7aef\u8fdc\u7a0b\u8fde\u63a5\u53ef\u80fd\u62a5\u9519\uff1a<span style=\"background: transparent; color: #ff0000; border: 0px initial initial;\">authentication plugin caching_sha2<\/span><\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">flush privileges;\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">\u00a0#\u5237\u65b0\u7cfb\u7edf\u6388\u6743\u8868<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">exit\u00a0\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u9000\u51famysql\u63a7\u5236\u53f0<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">\u4e8c\u3001<span style=\"background: transparent; text-indent: 2em; border: 0px initial initial;\">\u521b\u5efaMySQL\u6570\u636e\u5e93\u3001\u6dfb\u52a0\u7528\u6237\u5e76\u6388\u6743<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\"><span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">\u6570\u636e\u5e93\u540d\u79f0\uff1awww.osyunwei.com<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\"><span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">\u6570\u636e\u5e93\u7528\u6237\u540d\uff1aosyunwei.com<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\"><span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">\u6570\u636e\u5e93\u5bc6\u7801\uff1aosyunwei<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\"><span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">\u6388\u6743osyunwei.com\u7528\u6237\u5bf9www.osyunwei.com\u5177\u6709\u5168\u90e8\u64cd\u4f5c\u6743\u9650<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">\u7ee7\u7eed\u5728mysql\u63a7\u5236\u53f0\u64cd\u4f5c<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">mysql -u root -p\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u8f93\u5165\u521a\u521a\u4fee\u6539\u8fc7\u7684\u5bc6\u7801123456\uff0c\u56de\u8f66<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">2.1\u3001Create DATABASE IF NOT EXISTS\u00a0<span style=\"background: transparent; color: #ff0000; border: 0px initial initial;\">www.osyunwei.com<\/span>\u00a0default charset utf8 COLLATE utf8_general_ci;\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u521b\u5efa\u6570\u636e\u5e93<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">2.2\u3001CREATE USER &#8216;<span style=\"background: transparent; color: #ff0000; border: 0px initial initial;\">osyunwei.com<\/span>&#8216;@&#8217;localhost&#8217; IDENTIFIED BY &#8216;<span style=\"background: transparent; color: #ff0000; border: 0px initial initial;\">osyunwei<\/span>&#8216;;\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u521b\u5efa\u7528\u6237<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">CREATE USER &#8216;<span style=\"background: transparent; color: #ff0000; border: 0px initial initial;\">osyunwei.com<\/span>&#8216;@&#8217;127.0.0.1&#8217; IDENTIFIED WITH mysql_native_password BY &#8216;<span style=\"background: transparent; color: #ff0000; border: 0px initial initial;\">osyunwei<\/span>&#8216;;<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">\u00a0#\u52a0\u5bc6\u65b9\u5f0f\u4e3amysql_native_password<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">2.3\u3001grant all privileges on\u00a0<span style=\"background: transparent; color: #ff0000; border: 0px initial initial;\">www.osyunwei.com<\/span>.* to &#8216;<span style=\"background: transparent; color: #ff0000; border: 0px initial initial;\">osyunwei.com<\/span>&#8216;@&#8217;localhost&#8217;;\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u6388\u6743\u7528\u6237osyunwei.com\u5bf9\u6570\u636e\u5e93www.osyunwei.com\u5177\u6709\u5168\u90e8\u64cd\u4f5c\u6743\u9650<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">grant all privileges on\u00a0<span style=\"background: transparent; color: #ff0000; border: 0px initial initial;\">www.osyunwei.com<\/span>.* to &#8216;<span style=\"background: transparent; color: #ff0000; border: 0px initial initial;\">osyunwei.com<\/span>&#8216;@&#8217;127.0.0.1&#8217;;\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u6388\u6743\u7528\u6237<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">GRANT ALL PRIVILEGES ON *.* TO &#8216;root&#8217;@&#8217;localhost&#8217; WITH GRANT OPTION;<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">\u00a0#\u6388\u6743root\u7528\u6237\u5177\u6709\u5168\u90e8\u6570\u636e\u5e93\u672c\u5730\u6743\u9650<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">2.4\u3001MySQL5.7\u7248\u672c\u540e\u8981\u6388\u6743\u7528\u6237\u5bf9\u6240\u6709\u6570\u636e\u5e93\u6709SUPER\u6743\u9650\uff0c\u5426\u5219\u4e0a\u4e00\u6b65\u5bf9\u7528\u6237\u7684\u6388\u6743\u53ea\u80fd\u8fde\u63a5\u4f46\u65e0\u4efb\u4f55\u64cd\u4f5c\u6743\u9650\u3002<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">grant SUPER on *.* to &#8216;<span style=\"background: transparent; color: #ff0000; border: 0px initial initial;\">osyunwei.com<\/span>&#8216;@&#8217;localhost&#8217; ;\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u6388\u4e88\u7528\u6237\u5bf9\u6240\u6709\u6570\u636e\u5e93\u6709SUPER\u6743\u9650\uff0c\u5426\u5219\u53ea\u80fd\u8fde\u63a5\u65e0\u4efb\u4f55\u64cd\u4f5c\u6743\u9650\u3002<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">grant SUPER on *.* to &#8216;<span style=\"background: transparent; color: #ff0000; border: 0px initial initial;\">osyunwei.com<\/span>&#8216;@&#8217;127.0.0.1&#8217; ;<\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">flush privileges;\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u5237\u65b0\u7cfb\u7edf\u6388\u6743\u8868<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">exit\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u9000\u51famysql\u63a7\u5236\u53f0<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">service mysqld restart\u00a0<span style=\"background: transparent; color: #0000ff; border: 0px initial initial;\">#\u91cd\u542fmysql\u6570\u636e\u5e93<\/span><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\"><strong><span style=\"background: transparent; color: #ff0000; border: 0px initial initial;\">\u81f3\u6b64\uff0cCentOS 8.x\u5b89\u88c5MySQL 8.x\u5e76\u521b\u5efa\u6570\u636e\u5e93\u6dfb\u52a0\u7528\u6237\u5bf9\u7528\u6237\u8fdb\u884c\u6388\u6743\u5b8c\u6210\u3002<\/span><\/strong><\/p>\n<p style=\"margin-bottom: 10px; font-size: 13px; background: #ffffff; text-indent: 2em; color: #000000; font-family: 'Microsoft YaHei', \u5fae\u8f6f\u96c5\u9ed1, Arial, 'Lucida Grande', Tahoma, sans-serif; text-align: start; white-space: normal; border: 0px initial initial;\">\n<p>&nbsp;<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u672c\u6587CentOS\u7248\u672c\uff1aCentOS 8.x MySQL\u7248\u672c\uff1amysql-8.0.x \u4e00\u3001\u9632\u706b\u5899\u914d\u7f6e CentO [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-3977","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/www.xh86.me\/index.php?rest_route=\/wp\/v2\/posts\/3977","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.xh86.me\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xh86.me\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xh86.me\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xh86.me\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3977"}],"version-history":[{"count":1,"href":"https:\/\/www.xh86.me\/index.php?rest_route=\/wp\/v2\/posts\/3977\/revisions"}],"predecessor-version":[{"id":4096,"href":"https:\/\/www.xh86.me\/index.php?rest_route=\/wp\/v2\/posts\/3977\/revisions\/4096"}],"wp:attachment":[{"href":"https:\/\/www.xh86.me\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3977"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xh86.me\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3977"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xh86.me\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3977"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}