{"id":69,"date":"2022-09-01T18:25:40","date_gmt":"2022-09-01T10:25:40","guid":{"rendered":"https:\/\/qaqaq.top\/?p=69"},"modified":"2022-11-28T20:02:46","modified_gmt":"2022-11-28T12:02:46","slug":"docker%e6%89%8b%e5%8a%a8%e6%90%ad%e5%bb%bamysql","status":"publish","type":"post","link":"https:\/\/qaqaq.top\/?p=69","title":{"rendered":"Docker\u624b\u52a8\u642d\u5efaMysql"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/09\/image-1024x143.png'><img class=\"lazyload lazyload-style-1\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"143\" data-original=\"https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/09\/image-1024x143.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" class=\"wp-image-70\"  sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/div><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>docker run -itd --name mysql -p 3306:3306 --privileged=true centos:7.9.2009 \/usr\/sbin\/init<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/09\/image-1-1024x155.png'><img class=\"lazyload lazyload-style-1\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"155\" data-original=\"https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/09\/image-1-1024x155.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" class=\"wp-image-71\"  sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/div><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>docker exec -it 5b28125227d7 \/bin\/bash\nyum install -y vim wget<\/code><\/pre>\n\n\n\n<p>\u68c0\u67e5\u6709\u65e0\u5b89\u88c5\u8fc7mysql \u7528\u6237\u7ec4\uff0c\u6ca1\u6709\u7684\u8bdd\u521b\u5efa<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>groupadd mysql\nuseradd -r -g mysql mysql<\/code><\/pre>\n\n\n\n<p>\u4e0b\u8f7d\u5b89\u88c5,\u4ece\u5b98\u7f51\u5b89\u88c5\u4e0b\u8f7dmysql\u5305<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>cd \/usr\/local\/ \nwget https:\/\/cdn.mysql.com\/\/Downloads\/MySQL-5.7\/mysql-5.7.35-el7-x86_64.tar.gz<\/code><\/pre>\n\n\n\n<p>\u89e3\u538b\u5b89\u88c5mysql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>tar -zxvf mysql-5.7.35-el7-x86_64.tar.gz <\/code><\/pre>\n\n\n\n<p>\u5c06\u89e3\u538b\u7684\u6587\u4ef6\u505a\u6587\u4ef6\u6539\u540d<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mv mysql-5.7.35-el7-x86_64 mysql<\/code><\/pre>\n\n\n\n<p>\u66f4\u6539mysql&nbsp;\u76ee\u5f55\u4e0b\u6240\u6709\u6587\u4ef6\u5939\u6240\u5c5e\u7684\u7528\u6237\u7ec4\u548c\u7528\u6237\uff0c\u4ee5\u53ca\u6743\u9650<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>chown -R mysql:mysql \/usr\/local\/mysql\nchmod -R 755 \/usr\/local\/mysql<\/code><\/pre>\n\n\n\n<p>\u521b\u5efamysql\u76f8\u5173\u76ee\u5f55<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mkdir -p \/data\/mysql\/{data,logs,tmp}\n\u66f4\u6539\u6587\u4ef6\u5939\u5c5e\u6027\nchown -R mysql.mysql \/data\/mysql\/<\/code><\/pre>\n\n\n\n<p>\u521b\u5efamysql\u914d\u7f6e\u6587\u4ef6my.cnf<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>vim \/etc\/my.cnf<\/code><\/pre>\n\n\n\n<p># \u7b80\u5355\u6a21\u677f\u5982\u4e0b\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;client]\nport = 3306\nsocket = \/data\/mysql\/tmp\/mysql.sock\n&#91;mysqld]\nuser = mysql\nbasedir = \/usr\/local\/mysql\ndatadir = \/data\/mysql\/data\nport = 3306\nsocket = \/data\/mysql\/tmp\/mysql.sock\npid-file = \/data\/mysql\/tmp\/mysqld.pid\ntmpdir = \/data\/mysql\/tmp\nskip_name_resolve = 1\nsymbolic-links=0\nmax_connections = 2000\ngroup_concat_max_len = 1024000\nsql_mode = NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION\nlower_case_table_names = 1\nlog_timestamps=SYSTEM\ncharacter-set-server = utf8\ninteractive_timeout = 1800\nwait_timeout = 1800\nmax_allowed_packet = 32M\nbinlog_cache_size = 4M\nsort_buffer_size = 2M\nread_buffer_size = 4M\njoin_buffer_size = 4M\ntmp_table_size = 96M\nmax_heap_table_size = 96M\nmax_length_for_sort_data = 8096\n#logs\nserver-id = 1003306\nlog-error = \/data\/mysql\/logs\/error.log\nslow_query_log = 1\nslow_query_log_file = \/data\/mysql\/logs\/slow.log\nlong_query_time = 3\nlog-bin = \/data\/mysql\/logs\/binlog\nbinlog_format = row\nexpire_logs_days = 15\nlog_bin_trust_function_creators = 1\nrelay-log = \/data\/mysql\/logs\/relay-bin\nrelay-log-recovery = 1\nrelay_log_purge = 1\n#innodb\ninnodb_file_per_table = 1\ninnodb_log_buffer_size = 16M\ninnodb_log_file_size = 256M\ninnodb_log_files_in_group = 2\ninnodb_io_capacity = 2000\ninnodb_io_capacity_max = 4000\ninnodb_flush_neighbors = 0\ninnodb_flush_method = O_DIRECT\ninnodb_autoinc_lock_mode = 2\ninnodb_read_io_threads = 8\ninnodb_write_io_threads = 8\ninnodb_buffer_pool_size = 2G<\/code><\/pre>\n\n\n\n<p>\u914d\u7f6emysql.server<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>cd \/usr\/local\/mysql\/support-files\ncp mysql.server \/etc\/init.d\/mysql\nvim \/etc\/init.d\/mysql<\/code><\/pre>\n\n\n\n<p># \u4fee\u6539\u76ee\u5f55\u4f4d\u7f6e<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>basedir=\/usr\/local\/mysql\ndatadir=\/data\/mysql\/data<\/code><\/pre>\n\n\n\n<p># \u6ce8\u518c\u5f00\u673a\u542f\u52a8\u670d\u52a1<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>chkconfig --add mysql\nchkconfig --list<\/code><\/pre>\n\n\n\n<p>\u6dfb\u52a0\u73af\u5883\u53d8\u91cf<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>echo \"PATH=$PATH:\/usr\/local\/mysql\/bin \" &gt;&gt; \/etc\/profile \nsource \/etc\/profile<\/code><\/pre>\n\n\n\n<p>\u521d\u59cb\u5316mysql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/usr\/local\/mysql\/bin\/mysqld --initialize --user=mysql --basedir=\/usr\/local\/mysql --datadir=\/data\/mysql\/data\nyum install -y libaio numactl<\/code><\/pre>\n\n\n\n<p># \u4e34\u65f6\u5bc6\u7801\u4fdd\u5b58\u5728errlog\u4e2d \u83b7\u53d6\u4e34\u65f6\u5bc6\u7801<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>more \/data\/mysql\/logs\/error.log |grep password<\/code><\/pre>\n\n\n\n<p>\u542f\u52a8mysql\u670d\u52a1\uff0c\u5e76\u4fee\u6539\u5bc6\u7801<\/p>\n\n\n\n<p># \u542f\u52a8mysql\u670d\u52a1<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>service mysql start\nyum install initscripts<\/code><\/pre>\n\n\n\n<p># \u4f7f\u7528\u521d\u59cb\u5bc6\u7801\u767b\u5f55mysql\u670d\u52a1 \u5e76\u4fee\u6539\u5bc6\u7801<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -uroot -p \nmysql> alter user 'root'@'localhost' identified by '123456';\nmysql> flush privileges;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>\/usr\/local\/mysql\/support-files\/mysql.server start\nln -s \/usr\/local\/mysql\/bin\/mysql \/usr\/bin\/mysql\nservice mysql restart\nmysql -u root -p\nyum install libncurses*<\/code><\/pre>\n\n\n\n<p>\u5f00\u542f\u8fdc\u7a0b\u8fde\u63a5mysql\u6743\u9650<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -u root -p\nmysql&gt; use mysql;\nmysql&gt; select 'host' from user where user='root';\nmysql&gt; update user set host = '%' where user ='root';\nmysql&gt; flush privileges;\nmysql&gt; select 'host' from user where user='root';<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u68c0\u67e5\u6709\u65e0\u5b89\u88c5\u8fc7mysql \u7528\u6237\u7ec4\uff0c\u6ca1\u6709\u7684\u8bdd\u521b\u5efa \u4e0b\u8f7d\u5b89\u88c5,\u4ece\u5b98\u7f51\u5b89\u88c5\u4e0b\u8f7dmysql\u5305 \u89e3\u538b\u5b89\u88c5mysql \u5c06\u89e3 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[47],"class_list":["post-69","post","type-post","status-publish","format-standard","hentry","category-mysql-","tag-mysql"],"_links":{"self":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/69"}],"collection":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=69"}],"version-history":[{"count":2,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/69\/revisions"}],"predecessor-version":[{"id":1855,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/69\/revisions\/1855"}],"wp:attachment":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=69"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=69"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=69"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}