ÉèΪÊ×Ò³ ¼ÓÈëÊÕ²Ø

TOP

docker ѧϰ֮һ ×°MySQL ¹©Ô¶³ÌʹÓà Linux(Ò»)
2023-07-23 13:39:29 ¡¾´ó ÖРС¡¿ ä¯ÀÀ:48´Î
Tags£ºdocker Ï°Ö®Ò» MySQL ³ÌʹÓà Linux

ÒòΪLinux·¢Ðа汾µÄÎÊÌâÕÛÌÚÁ˺þ㬾¡Á¿Ê¹ÓÃLTSµÄ°æ±¾¡£ÆäËû°æ±¾ÓÐʱºòȱµÄ¶«Î÷Ì«¶àÁË£¬¶ÔÐÂÊÖÏ൱²»ÓѺá£

´ó¸Å»¨Á˼¸ÌìʵÔÚûÕÐÁË£¬ÏÂÁ˸öLTSµÄ°æ±¾£¬ÔÙװʱÕý³£ÁË¡£°´ÕÕ¹Ù·½Îĵµ¶¼¿ÉÒԸ㶨ÁË¡£

ʹÓÃÕâ¸ö°æ±¾µÄubuntu-22.04.2-desktop-amd64.isoµÄ£¬¹ÙÍøÉÏϵģ¬ÓÃÐéÄâ»úŪ¸öÉÏ×°ÁËÏÂ,¼ì²éÏÂÓÐûÓÐÁªÍø¡£

ping www.baidu.com
  • Ê×ÏÈÇÐrootÉÏ£¬²»ÖªµÀÇ°¼¸¸ö°æ±¾Ê±²»ÊÇÒ²ÊÇÕâ¸öÔ­Òò£¬·´Õýµ½´¦È±°ü±¨´í¡£×îºóÉÏÕâ¸öÖ±½ÓÇÐroot¡£
#Óû§½Ðxman ÔÚ xman-virtual-machineµÄ»ú×ÓÉϵǼ
xman@xman-virtual-machine:~$ su -
Password: 
root@xman-virtual-machine:~# 

ÊäÈë su - »áÈÃÄãÊäÈëÃÜÂ룬ÊäÈ뵱ǰÕ˺ŵĵǼÃÜÂë¡£ÇгÉrootÓû§¡£°²×°È¨ÏÞ×î´ó£¬µ«ÊÇdockerȺ×éÓÐЩ²Ù×÷²»ÁË£¬Îļþ¼ÐÒ²·ÃÎʲ»È«£¬

»¹ÒªÊÚȨÂÒÆß°ËÔã¡£

#Çå¿ÕÀúÊ·°æ±¾
sudo apt-get remove docker docker-engine docker.io containerd runc
#¸üÐÂÏ°ü¹ÜÀíÆ÷
sudo apt-get update
#ÔÊÐíhttpsÀàÐ͵Äͨ¹ý
sudo apt-get install \
    ca-certificates \
    curl \
    gnupg \
    lsb-release
#Docker¡¯s official GPG key
sudo mkdir -m 0755 -p /etc/apt/keyrings
curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo gpg --dearmor -o /etc/apt/keyrings/docker.gpg
#É趨´æ´¢¿â
echo \
  "deb [arch=$(dpkg --print-architecture) signed-by=/etc/apt/keyrings/docker.gpg] https://download.docker.com/linux/ubuntu \
  $(lsb_release -cs) stable" | sudo tee /etc/apt/sources.list.d/docker.list > /dev/null
#¸üаü¹ÜÀíÆ÷
sudo apt-get update
#Èç¹û¸üгö´íGPGkeyÓÐÎó 
sudo chmod a+r /etc/apt/keyrings/docker.gpg
sudo apt-get update
#°²×°docker
sudo apt-get install docker-ce docker-ce-cli containerd.io docker-buildx-plugin docker-compose-plugin
#ÓÃĬÈϵÄÈÝÆ÷¼ì²éÏÂÊÇ·ñ°²×°³É¹¦
sudo docker run hello-world

ÒÔÉ϶¼ÍêÁËÒÔºó¾Í´ú±í°²×°³É¹¦£¬ÕæÕæµÄÃż÷°²×°¶¼³ÔÁ¦¡£

  • ²éһϱ¾»ú¶ÔÍâÌṩ·þÎñµÄIP£¬Ê¹ÓÃÕâ¸ö½¨Á¢¸öÍøÇÅ
ip address

Èç¹ûÁªÍøÁË£¬Äã´ó¸ÅÄÜ¿´µ½ÄãµÄIP£¬×÷Ϊ¶ÔÍâͨѶµÄIP

 

È»ºó½¨Á¢¸öÍøÇÅ£¬×÷ΪÈÝÆ÷ºÍ±¾»úµÄͨµÀ£¬ÕâÑùÈÝÆ÷ͨ¹ýÕâ¸öÇÅʹÓñ¾»ú¶«Î÷¶ÔÍâÌṩ·þÎñ

#²é¿´ÍøÇŵÄÄÚÈÝ£¬Ò»°ãÓм¸¸ö
docker network ls
#Çå¿ÕûÓõÄÍøÂç
docker network prune
#Èç¹ûÒ»¸öÍøÇű»Ê¹ÓÃÖÐÄãɾ²»µôÐèÒªÏȹصôÈÝÆ÷£¬É¾³ýÈÝÆ÷£¬È»ºóɾ³ý
docker stop mycontainer1
docker rm mycontainer1
docker network prune
# Çå³ý²»ÓõÄÍøÇźó´óÌå¸É¾»ÁË£¬¾Í×ö¸ö×Ô¼ºÓñ¾»ú¶ÔÍâÌṩ·þÎñµÄIP×ö
docker network create \
    -o "com.docker.network.bridge.host_binding_ipv4"="192.168.139.129" \
    br0
#¼ì²éÏÂ״̬ÓÐûÓÐÎÊÌâ
docker net ls

 

  • ÏÂÔØMySQL²¢°²×°
#²éÒ»ÏÂÏÖÓеľµÏñ
docker images
#Èç¹ûÏÂÀ´ÁËÖ±½Ó×°£¬Ã»ÓÐÏÂÀ´¾ÍÏÂÒ»ÏÂ,²»Ð´°æ±¾Ä¬ÈÏÊÇlastµÄ
docker pull mysql
#È»ºó°²×°
docker run -di --privileged=true -p 3306:3306 --network=br0 -v /home/mysql/log:/var/log/mysql -v /home/mysql/data:/var/lib/mysql -v /home/mysql/conf/my.cnf:/etc/mysql/my.cnf -v /home/mysql/mysql-files:/var/lib/mysql-files -e MYSQL_ROOT_PASSWORD=123456 --restart=always --name my mysql

 

  1. -di d ºǫ́ÔËÐУ¬ÓÐÊØ»¤½ø³Ì´¦Àí i ¿ÉÒÔ½»»¥ Õâ¸öŪÁËÒÔºó¾Í²»ÓÃÊÖ¶¯Æô¶¯ÁË
  2. --privileged=true ÌáÉýȨÏÞ£¬·ÀÖ¹MySQLµÄÓÐЩĿ¼ûȨÏÞ·ÃÎÊ
  3. -p 3306:3306 ¶Ë¿ÚÓ³Éä Ö÷¶Ë¿Ú£ºÈÝÆ÷¶Ë¿Ú ÈÝÆ÷µÄ¿Ú½Óµ½Ö÷»úÉ϶ÔÍâÌṩ·þÎñ
  4. --network=br0 ʹÓÃÍøÇÅ br0´´½¨´ËÈÝÆ÷£¬²¢¶ÔÍâÌṩ·þÎñ
  5. -v /home/mysql/log:/var/log/mysql 
  6. -v /home/mysql/data:/var/lib/mysql 
  7. -v /home/mysql/conf/my.cnf:/etc/mysql/my.cnf 
  8. -v /home/mysql/mysql-files:/var/lib/mysql-files 
  9. Ö÷»úĿ¼£ºÈÝÆ÷Ŀ¼£¬°ÑÈÝÆ÷µÄÊý¾ÝºÍÅäÖÃÎļþ¹ÒÔص½Ö÷»úÉÏ·ÀÖ¹¶ªÊ§ºÍÅäÖÃͬ²½£¬Õâ¸öÊÇÒÔÇ°µÄÈç¹ûÐèÒª¸ÄÔ¶³Ì·ÃÎÊµÄ¸Ä my.cnfÎļþ
  10. -e MYSQL_ROOT_PASSWORD=123456 ÅäÖõǼÊý¾Ý¿ârootÓû§µÄÃÜÂëÊÇ123456£¬µ½Ê±ºò½øÈÝÆ÷¿ÉÒÔÓÃÕâ¸ö½øÊý¾Ý¿â
  11. ¡¡--restart=always dockerÖØÆôºóÈÝÆ÷ÊÇ·ñ¸ú×Å×Ô¶¯Æô¶¯£¬Èç¹û²»¼ÓÐèÒªÊÖ¶¯¿ªÆô
  12. --name my mysql ÈÝÆ÷Ãû³Æ ÈÝÆ÷´´½¨ÒÀ¾ÝµÄ¾µÏñÃû³Æ
  • ¡¡¡¡ÏȽøÈ¥¿´¿´ÈÝÆ÷,²¢ÇÒÇе½MySQLÖп´¿´ÔÊÐíÔ¶³Ì·ÃÎʲ»
#½»»¥½øÈ¥myÈÝÆ÷ÖÐ
docker exec -it my /bin/bash
#½øÈëMySQL¿´¿´
mysql -uroot -p123456
#Çе½¹ÜÀíÊý¾Ý¿â
use mysql;
#²é¿´ÏÂÊÇ·ñÔÊÐíÔ¶³Ì·ÃÎÊ
select user,host from user;
#Èç¹û²»ÔÊÐí¸ÄÏÂ
update user set host ='%' where user ='root';
#Ë¢ÐÂȨÏÞ
flush privileges;
#Èç¹û²»ÏëÓÃÕâ¸ö×Ô¼º½¨¸öÓû§
CREATE USER 'user'@'%' IDENTIFIED BY '123';
#È»ºóÊÚȨ
grant all privileges on *.*  to 'user'@'%' ; 
#ͬÑùË¢ÐÂÒ»ÏÂ
flush privileges; #Í˳öMySQ
Ê×Ò³ ÉÏÒ»Ò³ 1 2 ÏÂÒ»Ò³ βҳ 1/2/2
¡¾´ó ÖРС¡¿¡¾´òÓ¡¡¿ ¡¾·±Ìå¡¿¡¾Í¶¸å¡¿¡¾Êղء¿ ¡¾ÍƼö¡¿¡¾¾Ù±¨¡¿¡¾ÆÀÂÛ¡¿ ¡¾¹Ø±Õ¡¿ ¡¾·µ»Ø¶¥²¿¡¿
ÉÏһƪ£ºUÅÌ°²×°¿ÉÒƶ¯Arch Linux£¨ÊÊÓÃÄÚ.. ÏÂһƪ£º·ÖÏí¼¸¸ö³£ÓõÄÔËά shell ½Å±¾

×îÐÂÎÄÕÂ

ÈÈÃÅÎÄÕÂ

Hot ÎÄÕÂ

Python

C ÓïÑÔ

C++»ù´¡

´óÊý¾Ý»ù´¡

linux±à³Ì»ù´¡

C/C++ÃæÊÔÌâÄ¿