{"id":57,"date":"2019-02-10T17:18:20","date_gmt":"2019-02-10T09:18:20","guid":{"rendered":"http:\/\/b.yesiyu.top\/?p=57"},"modified":"2019-02-10T17:18:20","modified_gmt":"2019-02-10T09:18:20","slug":"%e6%9c%80%e6%96%b0%e5%ae%98%e6%96%b9mysql5-7-19%e7%9a%84docker%e9%95%9c%e5%83%8f%e5%9c%a8%e5%88%9b%e5%bb%ba%e6%97%b6%e6%98%a0%e5%b0%84%e7%9a%84%e9%85%8d%e7%bd%ae%e6%96%87%e4%bb%b6%e7%9b%ae%e5%bd%95","status":"publish","type":"post","link":"https:\/\/b.yesiyu.top\/?p=57","title":{"rendered":"\u6700\u65b0\u5b98\u65b9MySQL(5.7.19)\u7684docker\u955c\u50cf\u5728\u521b\u5efa\u65f6\u6620\u5c04\u7684\u914d\u7f6e\u6587\u4ef6\u76ee\u5f55\u6709\u6240\u4e0d\u540c"},"content":{"rendered":"
    \n
  1. \n
    \n

    \u6700\u65b0\u5b98\u65b9MySQL(5.7.19)\u7684docker\u955c\u50cf\u5728\u521b\u5efa\u65f6\u6620\u5c04\u7684\u914d\u7f6e\u6587\u4ef6\u76ee\u5f55\u6709\u6240\u4e0d\u540c\uff0c\u5728\u6b64\u8bb0\u5f55\u5e76\u5206\u4eab\u7ed9\u5927\u5bb6\uff1a<\/p>\n

    \u5b98\u65b9\u539f\u6587\uff1a<\/p>\n

    The MySQL startup configuration is specified in the file\u00a0\/etc\/mysql\/my.cnf<\/code>, and that file in turn includes any files found in the\u00a0\/etc\/mysql\/conf.d<\/code>\u00a0directory that end with\u00a0.cnf<\/code>. Settings in files in this directory will augment and\/or override settings in\u00a0\/etc\/mysql\/my.cnf<\/code>. If you want to use a customized MySQL configuration, you can create your alternative configuration file in a directory on the host machine and then mount that directory location as\u00a0\/etc\/mysql\/conf.d<\/code>\u00a0inside the\u00a0mysql<\/code>\u00a0container.<\/p>\n

    \u5927\u6982\u610f\u601d\u662f\u8bf4\uff1a<\/p>\n

    MySQL(5.7.19)\u7684\u9ed8\u8ba4\u914d\u7f6e\u6587\u4ef6\u662f \/etc\/mysql\/my.cnf \u6587\u4ef6\u3002\u5982\u679c\u60f3\u8981\u81ea\u5b9a\u4e49\u914d\u7f6e\uff0c\u5efa\u8bae\u5411 \/etc\/mysql\/conf.d \u76ee\u5f55\u4e2d\u521b\u5efa .cnf \u6587\u4ef6\u3002\u65b0\u5efa\u7684\u6587\u4ef6\u53ef\u4ee5\u4efb\u610f\u8d77\u540d\uff0c\u53ea\u8981\u4fdd\u8bc1\u540e\u7f00\u540d\u662f cnf \u5373\u53ef\u3002\u65b0\u5efa\u7684\u6587\u4ef6\u4e2d\u7684\u914d\u7f6e\u9879\u53ef\u4ee5\u8986\u76d6 \/etc\/mysql\/my.cnf \u4e2d\u7684\u914d\u7f6e\u9879\u3002<\/p>\n

    \u5177\u4f53\u64cd\u4f5c\uff1a<\/p>\n

    \u9996\u5148\u9700\u8981\u521b\u5efa\u5c06\u8981\u6620\u5c04\u5230\u5bb9\u5668\u4e2d\u7684\u76ee\u5f55\u4ee5\u53ca.cnf\u6587\u4ef6\uff0c\u7136\u540e\u518d\u521b\u5efa\u5bb9\u5668<\/p>\n

    # pwd<\/span>\r\n\/<\/span>opt\r\n<\/span># mkdir -p docker_v\/mysql\/conf<\/span>\r\n# cd docker_v\/mysql\/conf<\/span>\r\n# touch my.cnf<\/span>\r\n# docker run -p 3306:3306 --name mysql -v \/opt\/docker_v\/mysql\/conf:\/etc\/mysql\/conf.d -e MYSQL_ROOT_PASSWORD=123456 -d imageID<\/span>\r\n4ec4f56455ea2d6d7251a05b7f308e314051fdad2c26bf3d0f27a9b0c0a71414<\/span><\/pre>\n
    \u547d\u4ee4\u8bf4\u660e\uff1a<\/p>\n