{"id":7396,"date":"2022-03-03T10:27:54","date_gmt":"2022-03-03T02:27:54","guid":{"rendered":"https:\/\/blog.ywdevops.cn\/?p=7396"},"modified":"2026-01-30T11:47:17","modified_gmt":"2026-01-30T03:47:17","slug":"mysql-6","status":"publish","type":"post","link":"https:\/\/blog.ywdevops.cn\/index.php\/2022\/03\/03\/mysql-6\/","title":{"rendered":"mysql\u4e00\u952e\u5b89\u88c5\u811a\u672c"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u9700\u8981\u5148\u5c06\u8f6f\u4ef6\u5305\u548c\u811a\u672c\u4ee5\u53ca\u914d\u7f6e\u6587\u4ef6(my.cnf)\u4e0a\u4f20\u5230\u670d\u52a1\u5668\u4e0a\uff0c\u8f6f\u4ef6\u5305\u4e0b\u8f7d\u5730\u5740\uff1a<a rel=\"noreferrer noopener\" href=\"https:\/\/dev.mysql.com\/downloads\/mysql\/\" target=\"_blank\">https:\/\/dev.mysql.com\/downloads\/mysql\/<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u672c\u4f8b\u672c\u4f8b\u5b50\u4e2d\u7684mysql\u7248\u672c\u4e3a5.7.19\uff0c\u5176\u4f59\u7248\u672c\u540c\u6837\u9002\u7528\uff0c\u53ea\u9700\u8981\u4fee\u6539\u89e3\u538b\u6587\u4ef6\u540d\u4ee5\u53ca\u8f6f\u94fe\u63a5\u540d\u5373\u53ef<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u811a\u672c\u5185\u5bb9\u5982\u4e0b\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#!\/bin\/bash\n# @Author: GongGuan\n# @Date: 2021-10-26\nset -e\nexec 1&gt; output.txt\nexec 2&gt; errout.txt\necho \"**********************Install MySQL*********************\"\nworkdir=\/usr\/local\/\necho \"************tar xf file*************\"\nFileName=mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz\n#\u89e3\u538b\u6587\u4ef6\u5e76\u521b\u5efa\u8f6f\u94fe\u63a5\nif &#91; -f $FileName ];then\n    tar zxvf $FileName -C ${workdir}\n    if &#91; $? -eq 0 ];then\n       echo \"********File decompression Success********\"\n       echo \"********Copy my.cnf to \/etc\/********\"\n       \\cp  my.cnf \/etc\/     #\u6ce8\u610f: \u9700\u8981\u63d0\u524d\u5c06my.cnf\u6587\u4ef6\u653e\u5728\u811a\u672c\u540c\u7ea7\u76ee\u5f55\u4f4d\u7f6e\n       echo \"********Create Soft Link********\"\n       cd ${workdir}\n       ln -s mysql-5.7.19-linux-glibc2.12-x86_64\/   mysql\n       echo \"********Soft Link Create Success********\"\n    else\n       echo \"File Decompression Faild,Please Check!!!\"\n       exit 1\n    fi\nelse\n   echo \"No Found File,Please Check!!!\"\nfi\n#\u521b\u5efa\u666e\u901a\u7528\u6237\u548c\u7ec4\necho \"********create mysql user and group********\"\n&#91; -z \"$(grep 'mysql' \/etc\/group | awk -F ':' '{print $1}')\" ] &amp;&amp; groupadd -g 1008 mysql\n&#91; -z \"$(grep 'mysql' \/etc\/passwd | awk -F ':' '{print $1}')\" ] &amp;&amp; useradd -g mysql -u 1008 -s \/sbin\/nologin mysql\n#\u7ed9mysql\u76ee\u5f55\u548c\u914d\u7f6e\u6587\u4ef6\u8bbe\u7f6e\u5c5e\u4e3b\u548c\u5c5e\u7ec4\necho \"********Set permissions********\"\nchown -R mysql:mysql mysql\/*\nchown mysql:mysql \/etc\/my.cnf\n#\u5c06mysql\u53ef\u6267\u884c\u6587\u4ef6\u6dfb\u52a0\u5230\u73af\u5883\u53d8\u91cf\u4e2d\necho \"********Add mysql Binary file  to env********\"\necho \"export PATH=$PATH:\/usr\/local\/mysql\/bin\" &gt;&gt; \/etc\/profile\nsource \/etc\/profile\n#c\u521b\u5efa\u6570\u636e\u76ee\u5f55\u548cbinlog\u76ee\u5f55\uff0c\u6267\u884c\u521d\u59cb\u5316\necho \"********create data directory or binlog directory********\"\n&#91; ! -d \"\/data\/mysql\/data\" -o ! -d \"\/data\/mysql\/binlog\" ] &amp;&amp; mkdir -p \/data\/mysql\/{data,binlog}\nchown -R mysql:mysql \/data\/mysql\necho \"********mysql initialization********\"\nmysqld --initialize --user=mysql --basedir=\/usr\/local\/mysql --datadir=\/data\/mysql\/data\npasswd_root=$(grep 'temporary password' \/data\/mysql\/error.log | awk '{print $11}')\n&#91; -n \"${passwd_root}\" ] &amp;&amp; echo \"&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;mysql\u521d\u59cb\u5316\u6210\u529f&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;\"\necho \"root\u5bc6\u7801\u4e3a:${passwd_root}\" &gt; \/data\/mysql\/mysql_root_passwd.txt\n#copy\u53ef\u6267\u884c\u6587\u4ef6\u5230\/etc\/init.d\/\u76ee\u5f55\u4e0b,\u5e76\u91cd\u547d\u540d\u4e3amysqld\n\\cp -a \/usr\/local\/mysql\/support-files\/mysql.server  \/etc\/init.d\/mysqld\necho \"********\u5c06mysql\u8bbe\u7f6e\u4e3a\u5f00\u673a\u81ea\u542f\u52a8********\"\necho \"\/etc\/init.d\/mysqld start\" &gt;&gt; \/etc\/rc.d\/rc.local\nchmod +x \/etc\/rc.d\/rc.local\n#\u6dfb\u52a0\u8f6f\u8fde\u63a5\nln -s  \/usr\/local\/mysql\/bin\/mysql \/usr\/bin\/mysql\n#\u542f\u52a8Mysql\u5e76\u6267\u884c\u767b\u9646\u6d4b\u8bd5\necho \"********start mysqld**********\"\n\/etc\/init.d\/mysqld start\n\/etc\/init.d\/mysqld status\necho \"&lt;&lt;&lt;&lt;&lt;&lt;&lt;mysql root\u521d\u59cb\u5bc6\u7801\u5b58\u50a8\u4f4d\u7f6e: \/data\/mysql\/mysql_root_password.txt&gt;&gt;&gt;&gt;&gt;&gt;\"\n#\u767b\u9646mysql\u5e76\u8bbe\u7f6e\u5bc6\u7801<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">my.cnf\u7684\u5185\u5bb9\u5982\u4e0b\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;client]\nport=3306\nsocket=\/data\/mysql\/data\/mysql.sock\n&#91;mysqldump]\nquick\nmax_allowed_packet = 16M\n\n&#91;mysqld]\nuser = mysql\nbasedir = \/usr\/local\/mysql\ndatadir = \/data\/mysql\/data\nport = 3306\nserver-id = 1\nsocket = \/data\/mysql\/data\/mysql.sock\nskip_name_resolve = 1                            #\u7981\u6b62\u89e3\u6790\u4e3b\u673a\u540d\uff0c\u53ea\u80fd\u7528IP\u68c0\u67e5\u5ba2\u6237\u7aef\u767b\u9646\ncharacter-set-server = utf8mb4                   #\u8bbe\u7f6e\u9ed8\u8ba4\u5b57\u7b26\u96c6\ncollation-server = utf8mb4_general_ci            #\u5b57\u7b26\u96c6\u6392\u5e8f\u89c4\u5219\ninit_connect='SET NAMES utf8mb4'                 #\u8bbe\u7f6eclient\u8fde\u63a5mysql\u65f6\u7684\u5b57\u7b26\u96c6\uff0c\u9632\u6b62\u4e71\u7801\nlower_case_table_names = 1                       #\u662f\u5426\u5bf9sql\u8bed\u53e5\u5927\u5c0f\u5199\u4e0d\u654f\u611f\uff0c1\u8868\u793a\u4e0d\u654f\u611f\nkey_buffer_size = 16M\nmax_allowed_packet = 8M\ndefault-storage-engine=INNODB           #\u9ed8\u8ba4\u5b58\u50a8\u5f15\u64ce\npid-file = \/data\/mysql\/mysqld.pid  #pid\u6587\u4ef6\nlog-bin =\/data\/mysql\/binlog\/mysql-bin\nexpire-logs-days=15                              #\u6e05\u7406binlog\u65e5\u5fd7\nmax_binlog_size = 1073741824\nmax_connections = 6000                           #\u6700\u5927\u8fdb\u7a0b\u8fde\u63a5\u6570\nmax_connect_errors = 6000                        #\u6700\u5927\u9519\u8bef\u8fde\u63a5\u6570\ntable_open_cache = 2048                          #\u8868\u63cf\u8ff0\u7b26\u7f13\u5b58\u5927\u5c0f\uff0c\u53ef\u4ee5\u51cf\u5c11\u6587\u4ef6\u6253\u5f00\u5173\u95ed\u6b21\u6570\nmax_allowed_packet = 64M                         #\u6d88\u606f\u4f20\u8f93\u91cf\u7684\u6700\u5927\u503c\nlog-error=\/data\/mysql\/error.log\nbinlog_format = mixed                            #binlog\u65e5\u5fd7\u7c7b\u578b\nslow_query_log = ON                              #\u5f00\u542f\u6162\u67e5\u8be2\nslow_query_log_file=\/data\/mysql\/data\/slow_query.log\nlong_query_time=1                                #\u6162\u67e5\u8be2\u65f6\u95f4\uff0c\u8bbe\u7f6e\u4e3a1s\nwait_timeout=84600\nssl = 0                                          #\u5173\u95edssl\nexplicit_defaults_for_timestamp=true                           \ninteractive_timeout=84600\nsql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'\n&#91;mysqld_safe]\nopen-file-limit = 28192                         #\n#\n# include all files from the config directory\n#<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"> \u5982\u679c\u662fubuntu24.04LTS\uff0c\u9700\u8981\u4fee\u6539\u4e00\u4e0b\u8f6f\u94fe\u63a5\uff0c\u5426\u5219mysql\u521d\u59cb\u5316\u4f1a\u62a5\u9519\uff0c\u5982\u4e0b\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ln -s \/usr\/lib\/x86_64-linux-gnu\/libaio.so.1t64 \/usr\/lib\/x86_64-linux-gnu\/libaio.so.1\nln -s \/usr\/lib\/x86_64-linux-gnu\/libtinfo.so.6 \/usr\/lib\/x86_64-linux-gnu\/libtinfo.so.5\nln -s \/usr\/lib\/x86_64-linux-gnu\/libncurses.so.6 \/usr\/lib\/x86_64-linux-gnu\/libncurses.so.5<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u901a\u8fc7systemctl\u7ba1\u7406\uff0c\u5185\u5bb9\u5982\u4e0b\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;Unit]\nDescription=MySQL Server (binary install)\nAfter=network.target\n\n&#91;Service]\nType=forking\nUser=mysql\nGroup=mysql\n# \u5982\u679c my.cnf \u4e0d\u5728 \/etc\/my.cnf\uff0c\u628a --defaults-file= \u5199\u5168\nExecStart=\/etc\/init.d\/mysqld start\nExecStop=\/etc\/init.d\/mysqld stop\nPrivateTmp=false\nRestart=on-failure\n\n&#91;Install]\nWantedBy=multi-user.target<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u9700\u8981\u5148\u5c06\u8f6f\u4ef6\u5305\u548c\u811a\u672c\u4ee5\u53ca\u914d\u7f6e\u6587\u4ef6(my.cnf)\u4e0a\u4f20\u5230\u670d\u52a1\u5668\u4e0a\uff0c\u8f6f\u4ef6\u5305\u4e0b\u8f7d\u5730\u5740\uff1ahttps:\/\/dev.mys [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":7397,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[35,107],"tags":[],"class_list":["post-7396","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","category-script"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":8}},"_links":{"self":[{"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/posts\/7396","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/comments?post=7396"}],"version-history":[{"count":10,"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/posts\/7396\/revisions"}],"predecessor-version":[{"id":19604,"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/posts\/7396\/revisions\/19604"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/media\/7397"}],"wp:attachment":[{"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/media?parent=7396"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/categories?post=7396"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/tags?post=7396"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}