{"id":294,"date":"2017-06-26T11:25:58","date_gmt":"2017-06-26T03:25:58","guid":{"rendered":"https:\/\/blog.jsjs.org\/?p=294"},"modified":"2017-06-26T11:25:58","modified_gmt":"2017-06-26T03:25:58","slug":"docker%e5%b0%8f%e7%bb%93%ef%bc%88%e4%ba%8c%ef%bc%89%e9%85%8d%e7%bd%aemysql%e6%95%b0%e6%8d%ae%e5%ba%93","status":"publish","type":"post","link":"https:\/\/blog.jsjs.org\/?p=294","title":{"rendered":"Docker\u5c0f\u7ed3\uff08\u4e8c\uff09\u914d\u7f6emysql\u6570\u636e\u5e93"},"content":{"rendered":"<h3>\u4e00\u3001Dockerfile<\/h3>\n<ol class=\"linenums\">\n<li class=\"L0\"><span class=\"com\"># Dockerizing Mariadb: Dockerfile for building Mariadb images<\/span><\/li>\n<li class=\"L1\"><span class=\"com\">#<\/span><\/li>\n<li class=\"L2\"><span class=\"pln\">FROM hub<\/span><span class=\"pun\">.<\/span><span class=\"pln\">c<\/span><span class=\"pun\">.<\/span><span class=\"lit\">163.com<\/span><span class=\"pun\">\/<\/span><span class=\"pln\">public<\/span><span class=\"pun\">\/<\/span><span class=\"pln\">centos<\/span><span class=\"pun\">:<\/span><span class=\"lit\">7.2<\/span><span class=\"pun\">.<\/span><span class=\"lit\">1511<\/span><\/li>\n<li class=\"L3\"><span class=\"pln\">MAINTAINER yangbk <\/span><span class=\"pun\">&lt;<\/span><span class=\"pln\">www<\/span><span class=\"pun\">.<\/span><span class=\"lit\">361way<\/span><span class=\"pun\">.<\/span><span class=\"pln\">com<\/span><span class=\"pun\">&gt;<\/span><\/li>\n<li class=\"L4\"><span class=\"pln\">ENV DATA_DIR <\/span><span class=\"pun\">\/<\/span><span class=\"pln\">var<\/span><span class=\"pun\">\/<\/span><span class=\"pln\">lib<\/span><span class=\"pun\">\/<\/span><span class=\"pln\">mysql<\/span><\/li>\n<li class=\"L5\"><span class=\"pln\">ENV http_proxy <\/span><span class=\"lit\">10.212<\/span><span class=\"pun\">.<\/span><span class=\"lit\">186.250<\/span><span class=\"pun\">:<\/span><span class=\"lit\">3128<\/span><\/li>\n<li class=\"L6\"><span class=\"com\"># Install Mariadb<\/span><\/li>\n<li class=\"L7\"><span class=\"pln\">RUN yum install <\/span><span class=\"pun\">&#8211;<\/span><span class=\"pln\">y mariadb mariadb<\/span><span class=\"pun\">&#8211;<\/span><span class=\"pln\">server <\/span><span class=\"pun\">&amp;&amp;<\/span><span class=\"pln\"> \\<\/span><\/li>\n<li class=\"L8\"><span class=\"pln\"> yum clean all<\/span><\/li>\n<li class=\"L9\"><span class=\"pln\">ADD mysqld_charset<\/span><span class=\"pun\">.<\/span><span class=\"pln\">cnf <\/span><span class=\"pun\">\/<\/span><span class=\"pln\">etc<\/span><span class=\"pun\">\/<\/span><span class=\"pln\">my<\/span><span class=\"pun\">.<\/span><span class=\"pln\">cnf<\/span><span class=\"pun\">.<\/span><span class=\"pln\">d<\/span><span class=\"pun\">\/<\/span><\/li>\n<li class=\"L0\"><span class=\"pln\">COPY scripts <\/span><span class=\"pun\">\/<\/span><span class=\"pln\">scripts<\/span><\/li>\n<li class=\"L1\"><span class=\"pln\">RUN chmod <\/span><span class=\"pun\">+<\/span><span class=\"pln\">x <\/span><span class=\"pun\">\/<\/span><span class=\"pln\">scripts<\/span><span class=\"pun\">\/<\/span><span class=\"pln\">start<\/span><\/li>\n<li class=\"L2\"><span class=\"pln\">EXPOSE <\/span><span class=\"lit\">3306<\/span><\/li>\n<li class=\"L3\"><span class=\"pln\">VOLUME <\/span><span class=\"pun\">[<\/span><span class=\"str\">&#8220;\/var\/lib\/mysql&#8221;<\/span><span class=\"pun\">]<\/span><\/li>\n<li class=\"L4\"><span class=\"pln\">ENTRYPOINT <\/span><span class=\"pun\">[<\/span><span class=\"str\">&#8220;\/scripts\/start&#8221;<\/span><span class=\"pun\">]<\/span><\/li>\n<\/ol>\n<p>\u8be5\u4ee3\u7801\u4f7f\u7528\u6587\u4ef6\u5df2\u4e0a\u4f20\u5230\uff1a<a href=\"https:\/\/github.com\/361way\/docker\/tree\/master\/mysql\" target=\"_blank\" rel=\"noopener\">https:\/\/github.com\/361way\/docker\/tree\/master\/mysql<\/a> \uff0c\u8fd9\u91cc\u6709\u6ce8\u610f\u4e0bVOLUME\u547d\u4ee4\uff0c\u8be5\u547d\u4ee4\u7684\u4f5c\u7528\u662f\u6620\u5c04\u5bb9\u5668\u7684\/var\/lib\/mysql \u76ee\u5f55\u5230\u672c\u5730\u7684\u67d0\u4e2a\u8def\u5f84\uff08\u5373\u4f7f\u8be5\u5bb9\u5668\u5220\u9664\uff0c\u76f8\u5173\u6570\u636e\u6587\u4ef6\u4f9d\u7136\u5b58\u5728\uff09\uff0c\u8fd9\u4e2a\u53c2\u6570\u540e\u9762\u8fd8\u4f1a\u63d0\u5230\uff0c\u8be5\u53c2\u6570\u4e5f\u662f\u672c\u7bc7\u7740\u91cd\u8981\u4ecb\u7ecd\u7684\u4e1c\u897f\u3002<\/p>\n<h3>\u4e8c\u3001\u7f16\u8bd1\u4f7f\u7528<\/h3>\n<p>\u4f7f\u7528\u5982\u4e0b\u547d\u4ee4\u7f16\u8bd1\u8be5\u955c\u50cf\u6587\u4ef6<\/p>\n<ol class=\"linenums\">\n<li class=\"L0\"><span class=\"pln\">docker build <\/span><span class=\"pun\">&#8211;<\/span><span class=\"pln\">t mysql<\/span><span class=\"pun\">:<\/span><span class=\"lit\">5.5<\/span> <span class=\"pun\">.<\/span><\/li>\n<\/ol>\n<p>\u7f16\u8bd1\u5b8c\u6210\u540e\uff0c\u53ef\u4ee5\u76f4\u63a5\u6309\u5982\u4e0b\u547d\u4ee4\u4f7f\u7528\uff1a<\/p>\n<ol class=\"linenums\">\n<li class=\"L0\"><span class=\"pln\">docker exec <\/span><span class=\"pun\">&#8211;<\/span><span class=\"pln\">it dockerid <\/span><span class=\"pun\">\/<\/span><span class=\"pln\">bin<\/span><span class=\"pun\">\/<\/span><span class=\"pln\">bash <\/span><span class=\"pun\">\u6216<\/span><\/li>\n<li class=\"L1\"><span class=\"pln\">docker run <\/span><span class=\"pun\">&#8211;<\/span><span class=\"pln\">d <\/span><span class=\"pun\">&#8211;<\/span><span class=\"pln\">p <\/span><span class=\"lit\">3306<\/span><span class=\"pun\">:<\/span><span class=\"lit\">3306<\/span> <span class=\"pun\">&#8211;<\/span><span class=\"pln\">v host_dir<\/span><span class=\"pun\">:<\/span><span class=\"pln\">container_dir <\/span><span class=\"pun\">&#8212;<\/span><span class=\"pln\">name mydb mysql<\/span><span class=\"pun\">:<\/span><span class=\"lit\">5.5<\/span><\/li>\n<\/ol>\n<p>\u547d\u4ee4\u5982\u4e0b\uff1a<\/p>\n<ol class=\"linenums\">\n<li class=\"L0\"><span class=\"pun\">[<\/span><span class=\"pln\">root@localhost <\/span><span class=\"pun\">~]<\/span><span class=\"com\"># docker images<\/span><\/li>\n<li class=\"L1\"><span class=\"pln\">REPOSITORY TAG IMAGE ID CREATED SIZE<\/span><\/li>\n<li class=\"L2\"><span class=\"pln\">mysql <\/span><span class=\"lit\">5.5<\/span><span class=\"pln\"> e94e56744fd2 <\/span><span class=\"lit\">42<\/span><span class=\"pln\"> hours ago <\/span><span class=\"lit\">488<\/span><span class=\"pln\"> MB<\/span><\/li>\n<li class=\"L3\"><span class=\"pln\">httpd <\/span><span class=\"lit\">2.4<\/span> <span class=\"lit\">982b038c1c62<\/span> <span class=\"lit\">7<\/span><span class=\"pln\"> days ago <\/span><span class=\"lit\">409.5<\/span><span class=\"pln\"> MB<\/span><\/li>\n<li class=\"L4\"><span class=\"pun\">[<\/span><span class=\"pln\">root@localhost <\/span><span class=\"pun\">~]<\/span><span class=\"com\"># docker run -d -p 3306:3306 &#8211;name mydb mysql:5.5<\/span><\/li>\n<li class=\"L5\"><span class=\"pln\">d81e47d2b9993c7549319cc15ab44703b7f4534e87f38f19e1c17f7eb8a6396a<\/span><\/li>\n<li class=\"L6\"><span class=\"pun\">[<\/span><span class=\"pln\">root@localhost <\/span><span class=\"pun\">~]<\/span><span class=\"com\"># docker ps<\/span><\/li>\n<li class=\"L7\"><span class=\"pln\">CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES<\/span><\/li>\n<li class=\"L8\"><span class=\"pln\">d81e47d2b999 mysql<\/span><span class=\"pun\">:<\/span><span class=\"lit\">5.5<\/span> <span class=\"str\">&#8220;\/scripts\/start&#8221;<\/span> <span class=\"lit\">8<\/span><span class=\"pln\"> seconds ago <\/span><span class=\"typ\">Up<\/span> <span class=\"lit\">6<\/span><span class=\"pln\"> seconds <\/span><span class=\"lit\">22<\/span><span class=\"pun\">\/<\/span><span class=\"pln\">tcp<\/span><span class=\"pun\">,<\/span> <span class=\"lit\">0.0<\/span><span class=\"pun\">.<\/span><span class=\"lit\">0.0<\/span><span class=\"pun\">:<\/span><span class=\"lit\">3306<\/span><span class=\"pun\">-&gt;<\/span><span class=\"lit\">3306<\/span><span class=\"pun\">\/<\/span><span class=\"pln\">tcp mydb<\/span><\/li>\n<li class=\"L9\"><span class=\"lit\">3e88f0ea84cf<\/span><span class=\"pln\"> httpd<\/span><span class=\"pun\">:<\/span><span class=\"lit\">2.4<\/span> <span class=\"str\">&#8220;\/usr\/bin\/supervisord&#8221;<\/span> <span class=\"lit\">7<\/span><span class=\"pln\"> days ago <\/span><span class=\"typ\">Up<\/span> <span class=\"lit\">7<\/span><span class=\"pln\"> days <\/span><span class=\"lit\">22<\/span><span class=\"pun\">\/<\/span><span class=\"pln\">tcp<\/span><span class=\"pun\">,<\/span> <span class=\"lit\">0.0<\/span><span class=\"pun\">.<\/span><span class=\"lit\">0.0<\/span><span class=\"pun\">:<\/span><span class=\"lit\">8082<\/span><span class=\"pun\">-&gt;<\/span><span class=\"lit\">80<\/span><span class=\"pun\">\/<\/span><span class=\"pln\">tcp web2<\/span><\/li>\n<\/ol>\n<p>\u4f7f\u7528docker inspect d81e47d2b999\u67e5\u770b\u7684\u65f6\u5019\uff0c\u53ef\u4ee5\u53d1\u73b0\u6709\u5982\u4e0b\u5185\u5bb9\uff1a<\/p>\n<p><a href=\"http:\/\/www.361way.com\/wp-content\/uploads\/2016\/09\/docker-volumes-inspect.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" title=\"\" src=\"http:\/\/www.361way.com\/wp-content\/uploads\/2016\/09\/docker-volumes-inspect.png\" alt=\"\" width=\"922\" height=\"154\" align=\"\" \/><\/a><\/p>\n<p>\u63a5\u4e0b\u6765\u6211\u4eec\u5728\u6b64\u5bb9\u5668\u91cc\u521b\u5efa\u4e00\u4e2a\u6d4b\u8bd5\u5e93\uff1a<\/p>\n<ol class=\"linenums\">\n<li class=\"L0\"><span class=\"pun\">[<\/span><span class=\"pln\">root@localhost <\/span><span class=\"pun\">~]<\/span><span class=\"com\"># docker exec -it d81e47d2b999 \/bin\/bash<\/span><\/li>\n<li class=\"L1\"><span class=\"pun\">[<\/span><span class=\"pln\">root@d81e47d2b999 <\/span><span class=\"pun\">\/]<\/span><span class=\"com\"># mysql -uroot -p<\/span><\/li>\n<li class=\"L2\"><span class=\"typ\">Enter<\/span><span class=\"pln\"> password<\/span><span class=\"pun\">:<\/span><\/li>\n<li class=\"L3\"><span class=\"typ\">Welcome<\/span><span class=\"pln\"> to the <\/span><span class=\"typ\">MariaDB<\/span><span class=\"pln\"> monitor<\/span><span class=\"pun\">.<\/span> <span class=\"typ\">Commands<\/span><span class=\"pln\"> end with <\/span><span class=\"pun\">;<\/span><span class=\"pln\"> or \\g<\/span><span class=\"pun\">.<\/span><\/li>\n<li class=\"L4\"><span class=\"typ\">Your<\/span> <span class=\"typ\">MariaDB<\/span><span class=\"pln\"> connection id is <\/span><span class=\"lit\">1<\/span><\/li>\n<li class=\"L5\"><span class=\"typ\">Server<\/span><span class=\"pln\"> version<\/span><span class=\"pun\">:<\/span> <span class=\"lit\">5.5<\/span><span class=\"pun\">.<\/span><span class=\"lit\">52<\/span><span class=\"pun\">&#8211;<\/span><span class=\"typ\">MariaDB<\/span> <span class=\"typ\">MariaDB<\/span> <span class=\"typ\">Server<\/span><\/li>\n<li class=\"L6\"><span class=\"typ\">Copyright<\/span> <span class=\"pun\">(<\/span><span class=\"pln\">c<\/span><span class=\"pun\">)<\/span> <span class=\"lit\">2000<\/span><span class=\"pun\">,<\/span> <span class=\"lit\">2016<\/span><span class=\"pun\">,<\/span> <span class=\"typ\">Oracle<\/span><span class=\"pun\">,<\/span> <span class=\"typ\">MariaDB<\/span> <span class=\"typ\">Corporation<\/span> <span class=\"typ\">Ab<\/span><span class=\"pln\"> and others<\/span><span class=\"pun\">.<\/span><\/li>\n<li class=\"L7\"><span class=\"typ\">Type<\/span> <span class=\"str\">&#8216;help;&#8217;<\/span><span class=\"pln\"> or <\/span><span class=\"str\">&#8216;\\h&#8217;<\/span> <span class=\"kwd\">for<\/span><span class=\"pln\"> help<\/span><span class=\"pun\">.<\/span> <span class=\"typ\">Type<\/span> <span class=\"str\">&#8216;\\c&#8217;<\/span><span class=\"pln\"> to clear the current input statement<\/span><span class=\"pun\">.<\/span><\/li>\n<li class=\"L8\"><span class=\"typ\">MariaDB<\/span> <span class=\"pun\">[(<\/span><span class=\"pln\">none<\/span><span class=\"pun\">)]&gt;<\/span><span class=\"pln\"> create database testdb<\/span><span class=\"pun\">;<\/span><\/li>\n<li class=\"L9\"><span class=\"typ\">Query<\/span><span class=\"pln\"> OK<\/span><span class=\"pun\">,<\/span> <span class=\"lit\">1<\/span><span class=\"pln\"> row affected <\/span><span class=\"pun\">(<\/span><span class=\"lit\">0.00<\/span><span class=\"pln\"> sec<\/span><span class=\"pun\">)<\/span><\/li>\n<li class=\"L0\"><span class=\"typ\">MariaDB<\/span> <span class=\"pun\">[(<\/span><span class=\"pln\">none<\/span><span class=\"pun\">)]&gt;<\/span><span class=\"pln\"> show databases<\/span><span class=\"pun\">;<\/span><\/li>\n<li class=\"L1\"><span class=\"pun\">+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;+<\/span><\/li>\n<li class=\"L2\"><span class=\"pun\">|<\/span> <span class=\"typ\">Database<\/span> <span class=\"pun\">|<\/span><\/li>\n<li class=\"L3\"><span class=\"pun\">+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;+<\/span><\/li>\n<li class=\"L4\"><span class=\"pun\">|<\/span><span class=\"pln\"> information_schema <\/span><span class=\"pun\">|<\/span><\/li>\n<li class=\"L5\"><span class=\"pun\">|<\/span><span class=\"pln\"> mysql <\/span><span class=\"pun\">|<\/span><\/li>\n<li class=\"L6\"><span class=\"pun\">|<\/span><span class=\"pln\"> performance_schema <\/span><span class=\"pun\">|<\/span><\/li>\n<li class=\"L7\"><span class=\"pun\">|<\/span><span class=\"pln\"> test <\/span><span class=\"pun\">|<\/span><\/li>\n<li class=\"L8\"><span class=\"pun\">|<\/span><span class=\"pln\"> testdb <\/span><span class=\"pun\">|<\/span><\/li>\n<li class=\"L9\"><span class=\"pun\">+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;+<\/span><\/li>\n<li class=\"L0\"><span class=\"lit\">5<\/span><span class=\"pln\"> rows <\/span><span class=\"kwd\">in<\/span> <span class=\"kwd\">set<\/span> <span class=\"pun\">(<\/span><span class=\"lit\">0.00<\/span><span class=\"pln\"> sec<\/span><span class=\"pun\">)<\/span><\/li>\n<li class=\"L1\"><span class=\"typ\">MariaDB<\/span> <span class=\"pun\">[(<\/span><span class=\"pln\">none<\/span><span class=\"pun\">)]&gt;<\/span> <span class=\"typ\">Bye<\/span><\/li>\n<li class=\"L2\"><span class=\"pun\">[<\/span><span class=\"pln\">root@d81e47d2b999 <\/span><span class=\"pun\">\/]<\/span><span class=\"com\"># exit<\/span><\/li>\n<li class=\"L3\"><span class=\"pun\">[<\/span><span class=\"pln\">root@localhost <\/span><span class=\"pun\">~]<\/span><span class=\"com\"># docker ps<\/span><\/li>\n<li class=\"L4\"><span class=\"pln\">CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES<\/span><\/li>\n<li class=\"L5\"><span class=\"pln\">d81e47d2b999 mysql<\/span><span class=\"pun\">:<\/span><span class=\"lit\">5.5<\/span> <span class=\"str\">&#8220;\/scripts\/start&#8221;<\/span> <span class=\"lit\">6<\/span><span class=\"pln\"> minutes ago <\/span><span class=\"typ\">Up<\/span> <span class=\"lit\">6<\/span><span class=\"pln\"> minutes <\/span><span class=\"lit\">22<\/span><span class=\"pun\">\/<\/span><span class=\"pln\">tcp<\/span><span class=\"pun\">,<\/span> <span class=\"lit\">0.0<\/span><span class=\"pun\">.<\/span><span class=\"lit\">0.0<\/span><span class=\"pun\">:<\/span><span class=\"lit\">3306<\/span><span class=\"pun\">-&gt;<\/span><span class=\"lit\">3306<\/span><span class=\"pun\">\/<\/span><span class=\"pln\">tcp mydb<\/span><\/li>\n<li class=\"L6\"><span class=\"lit\">3e88f0ea84cf<\/span><span class=\"pln\"> httpd<\/span><span class=\"pun\">:<\/span><span class=\"lit\">2.4<\/span> <span class=\"str\">&#8220;\/usr\/bin\/supervisord&#8221;<\/span> <span class=\"lit\">7<\/span><span class=\"pln\"> days ago <\/span><span class=\"typ\">Up<\/span> <span class=\"lit\">7<\/span><span class=\"pln\"> days <\/span><span class=\"lit\">22<\/span><span class=\"pun\">\/<\/span><span class=\"pln\">tcp<\/span><span class=\"pun\">,<\/span> <span class=\"lit\">0.0<\/span><span class=\"pun\">.<\/span><span class=\"lit\">0.0<\/span><span class=\"pun\">:<\/span><span class=\"lit\">8082<\/span><span class=\"pun\">-&gt;<\/span><span class=\"lit\">80<\/span><span class=\"pun\">\/<\/span><span class=\"pln\">tcp web2<\/span><\/li>\n<\/ol>\n<p>\u5220\u9664\u8be5\u5bb9\u5668\u540e\uff0c\u53d1\u73b0\u5728\u4e3b\u673a\u4e0a\u539f\u6587\u4ef6\u8fd8\u5728\uff1a<\/p>\n<p><a href=\"http:\/\/www.361way.com\/wp-content\/uploads\/2016\/09\/docker-mysql-volumes.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" title=\"docker-mysql-volumes\" src=\"http:\/\/www.361way.com\/wp-content\/uploads\/2016\/09\/docker-mysql-volumes.png\" alt=\"docker-mysql-volumes\" width=\"1137\" height=\"126\" \/><br \/>\n<\/a><\/p>\n<h3>\u4e09\u3001docker volume<\/h3>\n<p>\u4e0a\u9762\u6211\u4eec\u63d0\u5230\u7684volume\uff0c\u4e5f\u53ef\u4ee5\u4f7f\u7528\u5982\u4e0b\u65b9\u6cd5\u786e\u8ba4\u5176\u6240\u5728\u7684\u4f4d\u7f6e\uff1a<\/p>\n<ol class=\"linenums\">\n<li class=\"L0\"><span class=\"pun\">[<\/span><span class=\"pln\">root@localhost <\/span><span class=\"pun\">~]<\/span><span class=\"com\"># docker volume ls<\/span><\/li>\n<li class=\"L1\"><span class=\"pln\">DRIVER VOLUME NAME<\/span><\/li>\n<li class=\"L2\"><span class=\"kwd\">local<\/span> <span class=\"lit\">348d2be96514243eb407655d8e0c403b67346dce70be5d76c071df188487d42d<\/span><\/li>\n<li class=\"L3\"><span class=\"kwd\">local<\/span> <span class=\"lit\">5ef16b9692e69d65734bb4942f936954d1a75ba081b8b771b2889221f62ca259<\/span><\/li>\n<li class=\"L4\"><span class=\"kwd\">local<\/span> <span class=\"lit\">979b4df31dcabb6ab93955643076c83505c4c09342a57269f017fd5581a93941<\/span><\/li>\n<li class=\"L5\"><span class=\"pun\">[<\/span><span class=\"pln\">root@localhost <\/span><span class=\"pun\">~]<\/span><span class=\"com\">#<\/span><\/li>\n<li class=\"L6\"><span class=\"pun\">[<\/span><span class=\"pln\">root@localhost <\/span><span class=\"pun\">~]<\/span><span class=\"com\">#<\/span><\/li>\n<li class=\"L7\"><span class=\"pun\">[<\/span><span class=\"pln\">root@localhost <\/span><span class=\"pun\">~]<\/span><span class=\"com\"># docker volume inspect 348d2be96514243eb407655d8e0c403b67346dce70be5d76c071df188487d42d<\/span><\/li>\n<li class=\"L8\"><span class=\"pun\">[<\/span><\/li>\n<li class=\"L9\"><span class=\"pun\">{<\/span><\/li>\n<li class=\"L0\"><span class=\"str\">&#8220;Name&#8221;<\/span><span class=\"pun\">:<\/span> <span class=\"str\">&#8220;348d2be96514243eb407655d8e0c403b67346dce70be5d76c071df188487d42d&#8221;<\/span><span class=\"pun\">,<\/span><\/li>\n<li class=\"L1\"><span class=\"str\">&#8220;Driver&#8221;<\/span><span class=\"pun\">:<\/span> <span class=\"str\">&#8220;local&#8221;<\/span><span class=\"pun\">,<\/span><\/li>\n<li class=\"L2\"><span class=\"str\">&#8220;Mountpoint&#8221;<\/span><span class=\"pun\">:<\/span> <span class=\"str\">&#8220;\/var\/lib\/docker\/volumes\/348d2be96514243eb407655d8e0c403b67346dce70be5d76c071df188487d42d\/_data&#8221;<\/span><span class=\"pun\">,<\/span><\/li>\n<li class=\"L3\"><span class=\"str\">&#8220;Labels&#8221;<\/span><span class=\"pun\">:<\/span><span class=\"pln\"> null<\/span><span class=\"pun\">,<\/span><\/li>\n<li class=\"L4\"><span class=\"str\">&#8220;Scope&#8221;<\/span><span class=\"pun\">:<\/span> <span class=\"str\">&#8220;local&#8221;<\/span><\/li>\n<li class=\"L5\"><span class=\"pun\">}<\/span><\/li>\n<li class=\"L6\"><span class=\"pun\">]<\/span><\/li>\n<\/ol>\n<p>\u4e0a\u9762\u6211\u4eec\u5df2\u7ecf\u5c06\u521a\u521a\u7684\u5bb9\u5668\u5220\u9664\u4e86\uff0c\u63a5\u4e0b\u6765\u6211\u4eec\u4f7f\u7528-v\u53c2\u6570\u6307\u5b9a\u6e90\u548c\u76ee\u6807\u8def\u5f84\uff0c\u542f\u52a8\u4e00\u4e2a\u65b0\u7684\u5bb9\u5668\uff0c\u4f1a\u53d1\u73b0\u6570\u636e\u5e93\u4f9d\u7136\u5b58\u5728\uff1a<\/p>\n<ol class=\"linenums\">\n<li class=\"L0\"><span class=\"pun\">[<\/span><span class=\"pln\">root@localhost <\/span><span class=\"pun\">~]<\/span><span class=\"com\"># docker run -d -p 3306:3306 -v \/var\/lib\/docker\/volumes\/348d2be96514243eb407655d8e0c403b67346dce70be5d76c071df188487d42d\/_data:\/var\/lib\/mysql &#8211;name newdb mysql:5.5<\/span><\/li>\n<li class=\"L1\"><span class=\"pln\">dcebc507f7a6a459ef24dc8c3718543772f22f2f3ec33053c3870b07d3446c55<\/span><\/li>\n<li class=\"L2\"><span class=\"pun\">[<\/span><span class=\"pln\">root@localhost <\/span><span class=\"pun\">~]<\/span><span class=\"com\"># docker exec -it newdb \/bin\/bash<\/span><\/li>\n<li class=\"L3\"><span class=\"pun\">[<\/span><span class=\"pln\">root@dcebc507f7a6 <\/span><span class=\"pun\">\/]<\/span><span class=\"com\"># mysql -uroot -p<\/span><\/li>\n<li class=\"L4\"><span class=\"typ\">Enter<\/span><span class=\"pln\"> password<\/span><span class=\"pun\">:<\/span><\/li>\n<li class=\"L5\"><span class=\"typ\">Welcome<\/span><span class=\"pln\"> to the <\/span><span class=\"typ\">MariaDB<\/span><span class=\"pln\"> monitor<\/span><span class=\"pun\">.<\/span> <span class=\"typ\">Commands<\/span><span class=\"pln\"> end with <\/span><span class=\"pun\">;<\/span><span class=\"pln\"> or \\g<\/span><span class=\"pun\">.<\/span><\/li>\n<li class=\"L6\"><span class=\"typ\">Your<\/span> <span class=\"typ\">MariaDB<\/span><span class=\"pln\"> connection id is <\/span><span class=\"lit\">1<\/span><\/li>\n<li class=\"L7\"><span class=\"typ\">Server<\/span><span class=\"pln\"> version<\/span><span class=\"pun\">:<\/span> <span class=\"lit\">5.5<\/span><span class=\"pun\">.<\/span><span class=\"lit\">52<\/span><span class=\"pun\">&#8211;<\/span><span class=\"typ\">MariaDB<\/span> <span class=\"typ\">MariaDB<\/span> <span class=\"typ\">Server<\/span><\/li>\n<li class=\"L8\"><span class=\"typ\">Copyright<\/span> <span class=\"pun\">(<\/span><span class=\"pln\">c<\/span><span class=\"pun\">)<\/span> <span class=\"lit\">2000<\/span><span class=\"pun\">,<\/span> <span class=\"lit\">2016<\/span><span class=\"pun\">,<\/span> <span class=\"typ\">Oracle<\/span><span class=\"pun\">,<\/span> <span class=\"typ\">MariaDB<\/span> <span class=\"typ\">Corporation<\/span> <span class=\"typ\">Ab<\/span><span class=\"pln\"> and others<\/span><span class=\"pun\">.<\/span><\/li>\n<li class=\"L9\"><span class=\"typ\">Type<\/span> <span class=\"str\">&#8216;help;&#8217;<\/span><span class=\"pln\"> or <\/span><span class=\"str\">&#8216;\\h&#8217;<\/span> <span class=\"kwd\">for<\/span><span class=\"pln\"> help<\/span><span class=\"pun\">.<\/span> <span class=\"typ\">Type<\/span> <span class=\"str\">&#8216;\\c&#8217;<\/span><span class=\"pln\"> to clear the current input statement<\/span><span class=\"pun\">.<\/span><\/li>\n<li class=\"L0\"><span class=\"typ\">MariaDB<\/span> <span class=\"pun\">[(<\/span><span class=\"pln\">none<\/span><span class=\"pun\">)]&gt;<\/span><span class=\"pln\"> show databases<\/span><span class=\"pun\">;<\/span><\/li>\n<li class=\"L1\"><span class=\"pun\">+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;+<\/span><\/li>\n<li class=\"L2\"><span class=\"pun\">|<\/span> <span class=\"typ\">Database<\/span> <span class=\"pun\">|<\/span><\/li>\n<li class=\"L3\"><span class=\"pun\">+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;+<\/span><\/li>\n<li class=\"L4\"><span class=\"pun\">|<\/span><span class=\"pln\"> information_schema <\/span><span class=\"pun\">|<\/span><\/li>\n<li class=\"L5\"><span class=\"pun\">|<\/span><span class=\"pln\"> mysql <\/span><span class=\"pun\">|<\/span><\/li>\n<li class=\"L6\"><span class=\"pun\">|<\/span><span class=\"pln\"> performance_schema <\/span><span class=\"pun\">|<\/span><\/li>\n<li class=\"L7\"><span class=\"pun\">|<\/span><span class=\"pln\"> test <\/span><span class=\"pun\">|<\/span><\/li>\n<li class=\"L8\"><span class=\"pun\">|<\/span><span class=\"pln\"> testdb <\/span><span class=\"pun\">|<\/span><\/li>\n<li class=\"L9\"><span class=\"pun\">+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;+<\/span><\/li>\n<li class=\"L0\"><span class=\"lit\">5<\/span><span class=\"pln\"> rows <\/span><span class=\"kwd\">in<\/span> <span class=\"kwd\">set<\/span> <span class=\"pun\">(<\/span><span class=\"lit\">0.00<\/span><span class=\"pln\"> sec<\/span><span class=\"pun\">)<\/span><\/li>\n<li class=\"L1\"><span class=\"typ\">MariaDB<\/span> <span class=\"pun\">[(<\/span><span class=\"pln\">none<\/span><span class=\"pun\">)]&gt;<\/span><\/li>\n<\/ol>\n<p>\u5f53\u7136\uff0c\u8fd9\u91cc\u6211\u4eec\u4e5f\u53ef\u4ee5\u4f7f\u7528\u4e00\u4e2a\u6bd4\u8f83\u77ed\u4e00\u70b9\u7684\u8def\u5f84\uff0c\u8def\u5f84\u4e0d\u4e00\u5b9a\u975e\u5f97\u4f7f\u7528\/var\/lib\/docker\/volumes\u8fd9\u6837\u7684\u4f4d\u7f6e\u3002\u800c\u4e14\u53ef\u4ee5\u6307\u5b9a\u4e00\u4e2a\u4e0d\u5b58\u5728\u7684\u8def\u5f84\uff0c\u5f53\u8fd0\u884c\u7684\u65f6\u5019\u4f1a\u81ea\u52a8\u521b\u5efa\u8be5\u76ee\u5f55\uff0c\u5982\u4e0b\uff1a<\/p>\n<ol class=\"linenums\">\n<li class=\"L0\"><span class=\"pln\">docker run <\/span><span class=\"pun\">&#8211;<\/span><span class=\"pln\">d <\/span><span class=\"pun\">&#8211;<\/span><span class=\"pln\">p <\/span><span class=\"lit\">3306<\/span><span class=\"pun\">:<\/span><span class=\"lit\">3306<\/span> <span class=\"pun\">&#8211;<\/span><span class=\"pln\">v <\/span><span class=\"pun\">\/<\/span><span class=\"pln\">mysqldata<\/span><span class=\"pun\">:\/<\/span><span class=\"pln\">var<\/span><span class=\"pun\">\/<\/span><span class=\"pln\">lib<\/span><span class=\"pun\">\/<\/span><span class=\"pln\">mysql <\/span><span class=\"pun\">&#8212;<\/span><span class=\"pln\">name newdb mysql<\/span><span class=\"pun\">:<\/span><span class=\"lit\">5.5<\/span><\/li>\n<\/ol>\n<p>\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528\u4e0a\u9762\u7684\u547d\u4ee4\u542f\u52a8\u4e00\u4e2a\u5bb9\u5668\uff0c\u5982\u679c\u8be5\u5bb9\u5668\u5220\u9664\u4e86\u4ee5\u540e\uff0c\u518d\u4f7f\u7528\u4e0a\u9762\u7684\u547d\u4ee4\u91cd\u542f\u4e00\u4e2a\u5bb9\u5668\u5c31\u884c\u4e86\uff0c\u6570\u636e\u4f9d\u7136\u5b58\u5728\u3002<\/p>\n<h3>\u56db\u3001\u5c0f\u7ed3<\/h3>\n<p>\u7531\u4e8edocker\u5bb9\u5668\u7684\u6570\u636e\u662f\u975e\u6301\u4e45\u7684\uff0c\u5982\u679c\u60f3\u8981\u6301\u4e45\u7684\u4fdd\u5b58\u6570\u636e\uff0c\u53ef\u4ee5\u4f7f\u7528VOLUME\u53c2\u6570\u8fd0\u884c\u5bb9\u5668\uff0c\u5176\u4f1a\u5728\u672c\u5730\u78c1\u76d8\u4e0a\u4f7f\u7528\u4e00\u4e2a\u76ee\u5f55\u540c\u6b65\u5bb9\u5668\u91cc\u7684\u6570\u636e\uff0c\u4e00\u65e6\u5bb9\u5668\u51fa\u73b0\u610f\u5916\uff0c\u6211\u4eec\u53ef\u4ee5\u5728\u79d2\u7ea7\u5355\u4f4d\u91cc\u5c06\u8be5\u5e94\u7528\u91cd\u65b0\u542f\u8d77\u6765\uff0c\u800c\u4e14\u539f\u6570\u636e\u5b58\u5728\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e00\u3001Dockerfile # Dockerizing Mariadb: Dockerfile for building Mariadb images # FROM hub.c.163.com\/public\/centos:7.2.1511 MAINTAINER yangbk &lt;www.361way.com&gt; ENV DATA_DIR \/var\/lib\/mysql ENV http_proxy [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-294","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/blog.jsjs.org\/index.php?rest_route=\/wp\/v2\/posts\/294","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.jsjs.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.jsjs.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.jsjs.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.jsjs.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=294"}],"version-history":[{"count":0,"href":"https:\/\/blog.jsjs.org\/index.php?rest_route=\/wp\/v2\/posts\/294\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.jsjs.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.jsjs.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=294"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.jsjs.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}