{"id":5227,"date":"2021-10-22T13:18:35","date_gmt":"2021-10-22T05:18:35","guid":{"rendered":"http:\/\/blog.ywdevops.cn\/?p=5227"},"modified":"2021-12-27T15:51:30","modified_gmt":"2021-12-27T07:51:30","slug":"mysql-4","status":"publish","type":"post","link":"https:\/\/blog.ywdevops.cn\/index.php\/2021\/10\/22\/mysql-4\/","title":{"rendered":"mysql5.7\u4e8c\u8fdb\u5236\u5b89\u88c5"},"content":{"rendered":"\n

1\u3001\u9996\u5148\u767b\u9646mysql\u5b98\u7f51\uff0c\u4e0b\u8f7d\u793e\u533a\u7248\u5b89\u88c5\u5305\uff0c\u5982\u56fe\uff1a<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

2\u3001\u89e3\u538b\u5b89\u88c5\u5305\u5230\u6307\u5b9a\u76ee\u5f55\uff0c\u6267\u884c\u547d\u4ee4\u5982\u4e0b\uff1a<\/p>\n\n\n\n

tar -xf mysql-5.7.35-linux-glibc2.12-x86_64.tar.gz -C \/usr\/local\/<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

3\u3001\u5728\u5f53\u524d\u76ee\u5f55\u521b\u5efa\u8f6f\u8fde\u63a5\uff0c\u6267\u884c\u547d\u4ee4\u5982\u4e0b\uff1a<\/p>\n\n\n\n

ln -sv mysql-5.7.35-linux-glibc2.12-x86_64\/ mysql<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

4\u3001\u521b\u5efa\u666e\u901a\u7528\u6237\u548c\u7ec4\uff0c\u6267\u884c\u547d\u4ee4\u5982\u4e0b\uff1a<\/p>\n\n\n\n

#\u521b\u5efa\u7528\u6237\u7ec4\uff0c\u5e76\u8bbe\u7f6egid\u4e3a1000\ngroupadd -g 1000 mysql\n\n#\u521b\u5efa\u7528\u6237mysql\u5e76\u8bbe\u7f6euid\u4e3a1000\uff0c\u52a0\u5165\u5230\u7ec4\u4e2d\uff0c\u5e76\u8bbe\u7f6e\u4e3a\u4e0d\u53ef\u767b\u9646\nuseradd -g mysql -u 1000 -s \/sbin\/nologin mysql<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
5\u3001\u7ed9mysql\u76ee\u5f55\u548c\u914d\u7f6e\u6587\u4ef6\u8bbe\u7f6e\u5c5e\u4e3b\u548c\u5c5e\u7ec4\uff0c\u5982\u4e0b\uff1a<\/p>\n\n\n\n
#\u8fdb\u5165\u76ee\u5f55\ncd \/usr\/local\/mysql\n#\u8bbe\u7f6emysql\u7684\u5c5e\u4e3b\u548c\u5c5e\u7ec4\nchown -R mysql:mysql mysql\/*\nchown -R mysql:mysql mysql-5.7.35-linux-glibc2.12-x86_64\n#\u8bbe\u7f6emy.cnf\u7684\u5c5e\u4e3b\u548c\u5c5e\u7ec4\nchown mysql:mysql \/etc\/my.cnf<\/code><\/pre>\n\n\n\n
my.cnf\u6587\u4ef6\u5185\u5bb9\u5982\u4e0b\uff1a<\/p>\n\n\n\n
[client]\nport=3306\nsocket=\/data\/mysql\/data\/mysql.sock\n[mysqldump]\nquick\nmax_allowed_packet = 16M\n\n[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\nsql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'\ndefault-storage-engine=INNODB                    #\u9ed8\u8ba4\u5b58\u50a8\u5f15\u64ce\npid-file = \/usr\/local\/mysql\/mysqld.pid           #pid\u6587\u4ef6\ndefault-time_zone = '+8:00'                      #\u6570\u636e\u5e93\u65f6\u95f4\u8bbe\u7f6e\u4e3a\u5317\u4eac\u65f6\u95f4\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\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                               \ninteractive_timeout=84600\n\n[mysqld_safe]\nopen-file-limit = 28192                         #\n#\n# include all files from the config directory\n#\n!includedir \/etc\/my.cnf.d\n<\/code><\/pre>\n\n\n\n
6\u3001\u5c06Mysql\u53ef\u6267\u884c\u6587\u4ef6\u6dfb\u52a0\u5230\u73af\u5883\u53d8\u91cf\u4e2d\uff0c\u6267\u884c\u547d\u4ee4\u5982\u4e0b\uff1a<\/p>\n\n\n\n
#\u6dfb\u52a0\u5230\u73af\u5883\u53d8\u91cf\u4e2d\necho \"export PATH=$PATH:\/usr\/local\/mysql\/bin\" >> \/etc\/profile\n#\u6267\u884c\u547d\u4ee4\u751f\u6548\nsource \/etc\/profile<\/code><\/pre>\n\n\n\n
7\u3001\u521b\u5efa\u6570\u636e\u76ee\u5f55\u548cbinlog\u76ee\u5f55\uff0c\u5e76\u521d\u59cb\u5316\uff0c\u6267\u884c\u547d\u4ee4\u5982\u4e0b\uff1a<\/p>\n\n\n\n
#\u521b\u5efa\u76ee\u5f55\nmkdir -p \/data\/mysql\/{data,binlog}\n#\u7ed9\u6570\u636e\u76ee\u5f55\u8bbe\u7f6e\u5c5e\u4e3b\u548c\u5c5e\u7ec4\nchown -R mysql:mysql  \/data\/mysql\n#\u6267\u884c\u547d\u4ee4\u521d\u59cb\u5316\nmysqld --initialize --user=mysql --basedir=\/usr\/local\/mysql --datadir=\/data\/mysql\/data<\/code><\/pre>\n\n\n\n
\u521d\u59cb\u5316\u6210\u529f\u540e\u53ef\u4ee5data\u76ee\u5f55\u770b\u5230\u5982\u4e0b\u5185\u5bb9\uff1a<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u5728\u754c\u9762\u4e5f\u53ef\u4ee5\u770b\u5230root\u521d\u59cb\u5bc6\u7801\uff0c\u5982\u56fe\uff1a<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
8\u3001copy\u53ef\u6267\u884c\u6587\u4ef6\u5230\/etc\/init.d\/\u76ee\u5f55\u4e0b\uff0c\u6267\u884c\u547d\u4ee4\u5982\u4e0b\uff1a<\/p>\n\n\n\n
#\u5c06\/usr\/local\/mysql\/support-files\/mysql.server\u62f7\u8d1d\u5230\/etc\/init.d\u5e76\u91cd\u547d\u540d\ncp -a \/usr\/local\/mysql\/support-files\/mysql.server  \/etc\/init.d\/mysqld<\/code><\/pre>\n\n\n\n
9\\\u3001\u542f\u52a8mysql\uff0c\u5e76\u767b\u9646\uff0c\u6267\u884c\u547d\u4ee4\u5982\u4e0b\uff1a<\/p>\n\n\n\n
#\u542f\u52a8mysql\n\/etc\/init.d\/mysqld start\n#\u901a\u8fc7\u521d\u59cb\u5bc6\u7801\u767b\u9646mysql\nmysql -uroot -pKglgqd7aaL*w <\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
10\u3001\u767b\u9646\u540e\u4fee\u6539\u9ed8\u8ba4\u5bc6\u7801\u4e3a\u81ea\u5b9a\u4e49\u5bc6\u7801\uff0c\u5982\u4e0b\uff1a<\/p>\n\n\n\n
alter user root@'%' identified by \"\u65b0\u5bc6\u7801\"\nflush privileges<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u5b89\u88c5\u811a\u672c\u5982\u4e0b\uff1a<\/p>\n\n\n\n
#!\/bin\/bash\n# @Author: GongGuan\n# @Date: 2021-10-26\nset -e\necho \"**********************Install MySQL*********************\"\nworkdir=\/usr\/local\/\necho \"************tar xf file*************\"\nFileName=mysql-5.7.35-linux-glibc2.12-x86_64.tgz\n#\u89e3\u538b\u6587\u4ef6\u5e76\u521b\u5efa\u8f6f\u94fe\u63a5\nif [ -f $FileName ];then\n    tar zxvf $FileName -C ${workdir}\n    if [ $? -eq 0 ];then\n       echo \"********File decompression Success********\"\n       echo \"********Create Soft Link********\"\n       cd ${workdir}\n       ln -s mysql-5.7.35-linux-glibc2.12-x86_64\/   mysql\n       echo \"********Soft Link Create Success********\"\n       echo \"********Copy my.cnf to \/etc\/********\"\n       \\cp -a mysql\/support-files\/my.cnf \/etc\/\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[ -z \"$(grep 'mysql' \/etc\/group | awk -F ':' '{print $1}')\" ] && groupadd -g 1000 mysql\n[ -z \"$(grep 'mysql' \/etc\/passwd | awk -F ':' '{print $1}')\" ] && useradd -g mysql -u 1000 -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\" >> \/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[ ! -d \"\/data\/mysql\/data\" -o ! -d \"\/data\/mysql\/binlog\" ] && 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\/data\/mysql_error.log | awk '{print $11}')\n[ -n \"${passwd_root}\" ] && echo \"<<<<<<<<<<mysql\u521d\u59cb\u5316\u6210\u529f>>>>>>>>>>>>\"\necho \"root\u5bc6\u7801\u4e3a:${passwd_root}\" > \/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\" >> \/etc\/rc.d\/rc.local\nchmod +x \/etc\/rc.d\/rc.local\n#\u542f\u52a8Mysql\u5e76\u6267\u884c\u767b\u9646\u6d4b\u8bd5\necho \"********start mysqld**********\"\n\/etc\/init.d\/mysqld start\n<\/code><\/pre>\n\n\n\n
\u6ce8\u610f\uff1a\u4e0a\u9762\u811a\u672c\u4e2d\u6267\u884c\u540e\u83b7\u53d6\u7684\u53ea\u662f\u521d\u59cb\u5bc6\u7801\uff0c\u8fd8\u9700\u8981\u767b\u9646\u8fdb\u53bb\u4fee\u6539\u5bc6\u7801<\/p>\n","protected":false},"excerpt":{"rendered":"
1\u3001\u9996\u5148\u767b\u9646mysql\u5b98\u7f51\uff0c\u4e0b\u8f7d\u793e\u533a\u7248\u5b89\u88c5\u5305\uff0c\u5982\u56fe\uff1a 2\u3001\u89e3\u538b\u5b89\u88c5\u5305\u5230\u6307\u5b9a\u76ee\u5f55\uff0c\u6267\u884c\u547d\u4ee4\u5982\u4e0b\uff1a tar -xf […]<\/p>\n","protected":false},"author":3,"featured_media":5245,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[35,25],"tags":[],"class_list":["post-5227","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","category-database"],"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\/5227","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=5227"}],"version-history":[{"count":15,"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/posts\/5227\/revisions"}],"predecessor-version":[{"id":6139,"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/posts\/5227\/revisions\/6139"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/media\/5245"}],"wp:attachment":[{"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/media?parent=5227"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/categories?post=5227"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/tags?post=5227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}