2023學(xué)年完整公開課版Dockerfile創(chuàng)建MySQL數(shù)據(jù)庫

實(shí)戰(zhàn)MySQL數(shù)據(jù)庫2目錄任務(wù)說明部署MySQL環(huán)境3任務(wù)說明利用Compose部署一個(gè)Mysql開發(fā)環(huán)境，并且可以自動(dòng)運(yùn)行Mysql的數(shù)據(jù)庫4創(chuàng)建工作目錄#mkdir8-19#cd8-19部署MySQL環(huán)境5編寫docker-compose文件#catdocker-compose.ymlversion:'3'services:db:image:mysql/mysql-server:5.7restart:alwayscontainer_name:mysql部署MySQL環(huán)境6volumes:-data:/var/lib/mysql-./f:/etc/f-./init:/docker-entrypoint-initdb.d/ports:-'3306:3306'volumes:data:driver:local部署MySQL環(huán)境7編輯f配置文件#f[mysqld]user=mysqldefault-storage-engine=INNODBcharacter-set-server=utf8[client]default-character-set=utf8[mysql]default-character-set=utf8部署MySQL環(huán)境8創(chuàng)建init.sql創(chuàng)建目錄init#mkdirinit#catinit/init.sqlCREATEUSER'user1'@'%'IDENTIFIEDBY'123456';GRANTAllprivilegesON*.*TO'user1'@'%';部署MySQL環(huán)境9啟動(dòng)compose容器#docker-composeup-dStartingmysql...Startingmysql...done部署MySQL環(huán)境10查看容器狀態(tài)#dockerps-aCONTAINERIDIMAGECOMMANDCREATEDSTATUSPORTSNAMES167c3032ea7bmysql/mysql-server:5.7"/entrypoint.shmy..."4minutesagoUp2minutes(healthy):3306->3306/tcp,33060/tcpmysql部署MySQL環(huán)境11遠(yuǎn)程連接測試#mysql-uuser1-p123456-h0WelcometotheMariaDBmonitor.Commandsendwith;or\g.YourMySQLconnectionidis9Serverversion:5.7.23MySQLCommunityServer(GPL)Copyright(c)2000,2018,Oracle,MariaDBCorporationAbandothers.Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement.部署MySQL環(huán)境12MySQL[(none)]>showdatabases;+--------------------+|Database|+--------------------+|information_schema||mysql||per