<p><br></p><p><br></p><p>docker version 2.1.0.3</p><p><br></p><p style="text-align: left;"><p style="text-align: left;"><p><a href='/api/file/11EB0D04E23329B297400242AC110002' target='_blank'><i class='far fa-file'></i> docker_maria_motolies.7z</a></p></p><p><br></p><p style="text-align: left;"><p><br></p><p>위의 첨부파일을 풀어서 압축을 푼 다음 cmd 창의 폴더를 변경한다.</p><p><br></p><p>아래는 사용된 cmd를 정리한 것이다.</p><div style="color: rgb(212, 212, 212); background-color: rgb(30, 30, 30); font-family: Consolas, &quot;Courier New&quot;, monospace; font-size: 14px; line-height: 19px; white-space: pre;"><div><span style="color: #6a9955;">#&nbsp;dockerfile&nbsp;build(create&nbsp;image)</span></div><div>docker&nbsp;build&nbsp;-t&nbsp;motolies/mariadb:base&nbsp;.</div><br><div><span style="color: #6a9955;">#&nbsp;check&nbsp;images</span></div><div>docker&nbsp;images</div><br><div><span style="color: #6a9955;">#&nbsp;docker&nbsp;run&nbsp;container</span></div><div>docker&nbsp;run&nbsp;-d&nbsp;-p&nbsp;13306:3306&nbsp;-e&nbsp;MYSQL_ROOT_PASSWORD=root&nbsp;--name&nbsp;mydb&nbsp;motolies/mariadb:base</div><div style="color: rgb(212, 212, 212); background-color: rgb(30, 30, 30); font-family: Consolas, &quot;Courier New&quot;, monospace; font-size: 14px; line-height: 19px; white-space: pre;"><br></div><div style="color: rgb(212, 212, 212); background-color: rgb(30, 30, 30); font-family: Consolas, &quot;Courier New&quot;, monospace; font-size: 14px; line-height: 19px; white-space: pre;"><div style="line-height: 19px;"><div><span style="color: #6a9955;">#&nbsp;docker&nbsp;container&nbsp;auto&nbsp;start&nbsp;on&nbsp;boot&nbsp;(add&nbsp;option&nbsp;'--restart&nbsp;unless-stopped')</span></div><div><span style="color: #6a9955;">#&nbsp;https://docs.docker.com/config/containers/start-containers-automatically/</span></div><div>docker&nbsp;run&nbsp;-d&nbsp;-p&nbsp;13306:3306&nbsp;-e&nbsp;MYSQL_ROOT_PASSWORD=root&nbsp;--restart&nbsp;unless-stopped&nbsp;--name&nbsp;mydb&nbsp;motolies/mariadb:base</div></div></div><br><div><span style="color: #6a9955;">#&nbsp;check&nbsp;container</span></div><div>docker&nbsp;ps</div><br><div><span style="color: #6a9955;">#&nbsp;into&nbsp;container</span></div><div>docker&nbsp;exec&nbsp;-it&nbsp;mydb&nbsp;bash</div><div><br></div><div><div style="line-height: 19px;"><div><span style="color: #6a9955;">#&nbsp;host&nbsp;file&nbsp;to&nbsp;container</span></div><div>docker&nbsp;cp&nbsp;[host&nbsp;파일경로]&nbsp;[container&nbsp;name]:[container&nbsp;내부&nbsp;경로]</div><div>docker&nbsp;cp&nbsp;"D:\save.sql"&nbsp;mydb:/</div><br><div><span style="color: #6a9955;">#&nbsp;container&nbsp;file&nbsp;to&nbsp;host</span></div><div>docker&nbsp;cp&nbsp;[container&nbsp;name]:[container&nbsp;내부&nbsp;경로]&nbsp;[host&nbsp;파일경로]</div><div>docker&nbsp;cp&nbsp;mydb:/save.sql&nbsp;D:\</div><div><br></div></div></div></div><p><br></p><p><br></p><p>dockerClear.bat (실행중인 것을 포함한 모든 container &amp; images 삭제)</p><div style="color: rgb(212, 212, 212); background-color: rgb(30, 30, 30); font-family: Consolas, &quot;Courier New&quot;, monospace; font-size: 14px; line-height: 19px; white-space: pre;"><div>@<span style="color: #569cd6;">echo</span>&nbsp;<span style="color: #569cd6;">off</span></div><div><span style="color: #c586c0;">FOR</span>&nbsp;/f&nbsp;<span style="color: #ce9178;">"tokens=*"</span>&nbsp;<span style="color: #d7ba7d;">%%</span>i&nbsp;IN&nbsp;('docker&nbsp;ps&nbsp;-q')&nbsp;DO&nbsp;docker&nbsp;stop&nbsp;<span style="color: #d7ba7d;">%%</span>i</div><div><span style="color: #c586c0;">FOR</span>&nbsp;/f&nbsp;<span style="color: #ce9178;">"tokens=*"</span>&nbsp;<span style="color: #d7ba7d;">%%</span>i&nbsp;IN&nbsp;('docker&nbsp;ps&nbsp;-aq')&nbsp;DO&nbsp;docker&nbsp;rm&nbsp;<span style="color: #d7ba7d;">%%</span>i</div><div><span style="color: #c586c0;">FOR</span>&nbsp;/f&nbsp;<span style="color: #ce9178;">"tokens=*"</span>&nbsp;<span style="color: #d7ba7d;">%%</span>i&nbsp;IN&nbsp;('docker&nbsp;images&nbsp;--format&nbsp;<span style="color: #ce9178;">"{{.ID}}"</span>')&nbsp;DO&nbsp;docker&nbsp;rmi&nbsp;<span style="color: #d7ba7d;">%%</span>i</div></div><p><br></p><p>Dockerfile</p><div style="color: rgb(212, 212, 212); background-color: rgb(30, 30, 30); font-family: Consolas, &quot;Courier New&quot;, monospace; font-size: 14px; line-height: 19px; white-space: pre;"><div><div style="line-height: 19px;"><div><span style="color: #569cd6;">FROM</span>&nbsp;mariadb:10.0.38</div><div><span style="color: #569cd6;">MAINTAINER</span>&nbsp;motolies&nbsp;&lt;knw1234@gmail.com&gt;</div><br><div><span style="color: #6a9955;">#&nbsp;환경설정</span></div><div><span style="color: #6a9955;">#&nbsp;TZ&nbsp;default&nbsp;=&nbsp;UTC</span></div><div><span style="color: #569cd6;">ENV</span>&nbsp;MYSQL_ROOT_PASSWORD=root&nbsp;\</div><div>&nbsp;&nbsp;&nbsp;&nbsp;MYSQL_DATABASE=myDB&nbsp;\</div><div>&nbsp;&nbsp;&nbsp;&nbsp;TZ=Asia/Seoul</div><br><div><span style="color: #6a9955;">#&nbsp;설정파일&nbsp;넣기</span></div><div><span style="color: #569cd6;">ADD</span>&nbsp;my.cnf&nbsp;/etc/mysql/my.cnf</div><br><div><span style="color: #6a9955;">#&nbsp;초기화&nbsp;쿼리</span></div><div><span style="color: #6a9955;">#&nbsp;/docker-entrypoint-initdb.d&nbsp;폴더에&nbsp;파일을&nbsp;넣어주면&nbsp;알파벳&nbsp;순으로&nbsp;실행</span></div><div><span style="color: #569cd6;">ADD</span>&nbsp;init.sql&nbsp;/docker-entrypoint-initdb.d/init.sql</div><br><div><span style="color: #6a9955;">#&nbsp;볼륨을&nbsp;사용하지&nbsp;않아서&nbsp;이미지에&nbsp;데이터를&nbsp;넣을&nbsp;수&nbsp;있음</span></div><div><span style="color: #569cd6;">RUN</span>&nbsp;cp&nbsp;-r&nbsp;/var/lib/mysql&nbsp;/var/lib/mysql-no-volume</div><div><span style="color: #569cd6;">CMD</span>&nbsp;[<span style="color: #ce9178;">"--datadir"</span>,&nbsp;<span style="color: #ce9178;">"/var/lib/mysql-no-volume"</span>]</div></div></div><br></div><p><br></p><p>my.cnf</p><div style="background-color: rgb(30, 30, 30); line-height: 19px;"><div style="color: rgb(212, 212, 212); font-family: Consolas, &quot;Courier New&quot;, monospace; font-size: 14px; line-height: 19px; white-space: pre;"><div>[mysqld]</div><div>character-set-server&nbsp;=&nbsp;utf8</div><div><span style="color: #6a9955;">#&nbsp;빼고&nbsp;해보자.&nbsp;</span></div><div><span style="color: #6a9955;">#&nbsp;현재&nbsp;개발환경상&nbsp;utf8_unicode_ci랑&nbsp;utf8_general_ci랑&nbsp;충돌나는&nbsp;거&nbsp;같다</span></div><div><span style="color: #6a9955;">#collation-server&nbsp;=&nbsp;utf8_unicode_ci</span></div><br><div><span style="color: #6a9955;">#&nbsp;테이블명&nbsp;대소문자&nbsp;구별없이</span></div><div>lower_case_table_names&nbsp;=&nbsp;1</div><div><span style="color: #6a9955;">#&nbsp;메모리&nbsp;설정</span></div><div>innodb_buffer_pool_size&nbsp;=&nbsp;1G</div><div><span style="color: #6a9955;">#&nbsp;커넥션&nbsp;설정</span></div><div>max_connections&nbsp;=&nbsp;1024</div><div>thread_pool_max_threads&nbsp;=&nbsp;1024</div><div>max_allowed_packet&nbsp;=&nbsp;1073741824</div><div>net_buffer_length&nbsp;=&nbsp;1048576</div><div><br></div></div></div><div><br></div><div><br></div><div>my.cnf 에서 캐릭터셋을 변경해보고 확인은 디비에 접속해서 아래 쿼리로 확인해보자</div><div><br></div><div><div style="color: rgb(212, 212, 212); background-color: rgb(30, 30, 30); font-family: Consolas, &quot;Courier New&quot;, monospace; font-size: 14px; line-height: 19px; white-space: pre;">SHOW&nbsp;VARIABLES&nbsp;<span style="color: #569cd6;">WHERE</span>&nbsp;Variable_name&nbsp;<span style="color: #569cd6;">LIKE</span>&nbsp;<span style="color: #ce9178;">'character\_set\_%'</span>&nbsp;<span style="color: #569cd6;">OR</span>&nbsp;Variable_name&nbsp;<span style="color: #569cd6;">LIKE</span>&nbsp;<span style="color: #ce9178;">'collation%'</span>;</div></div><div><br></div><div><br></div><p>init.sql</p><div style="color: rgb(212, 212, 212); background-color: rgb(30, 30, 30); font-family: Consolas, &quot;Courier New&quot;, monospace; font-size: 14px; line-height: 19px; white-space: pre;"><div><span style="color: #569cd6;">USE</span>&nbsp;mysql;</div><div><span style="color: #569cd6;">GRANT</span>&nbsp;ALL&nbsp;PRIVILEGES&nbsp;<span style="color: #569cd6;">ON</span>&nbsp;*.*&nbsp;<span style="color: #569cd6;">TO</span>&nbsp;<span style="color: #ce9178;">'motolies'</span>@<span style="color: #ce9178;">'localhost'</span>&nbsp;IDENTIFIED&nbsp;<span style="color: #569cd6;">BY</span>&nbsp;<span style="color: #ce9178;">'motolies'</span>&nbsp;<span style="color: #569cd6;">WITH</span>&nbsp;<span style="color: #569cd6;">GRANT</span>&nbsp;<span style="color: #569cd6;">OPTION</span>;</div><div><span style="color: #569cd6;">GRANT</span>&nbsp;ALL&nbsp;PRIVILEGES&nbsp;<span style="color: #569cd6;">ON</span>&nbsp;*.*&nbsp;<span style="color: #569cd6;">TO</span>&nbsp;<span style="color: #ce9178;">'motolies'</span>@<span style="color: #ce9178;">'%'</span>&nbsp;IDENTIFIED&nbsp;<span style="color: #569cd6;">BY</span>&nbsp;<span style="color: #ce9178;">'motolies'</span>&nbsp;<span style="color: #569cd6;">WITH</span>&nbsp;<span style="color: #569cd6;">GRANT</span>&nbsp;<span style="color: #569cd6;">OPTION</span>;</div><div>FLUSH&nbsp;PRIVILEGES;</div><br></div><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p>


[Docker] Dockerfile 로 이미지 만들어 보기 feat.mariadb