Loading...

Docker Compose Install Mysql

Created2025-08-04|Updated2026-04-27|dockerdocker composemysql

|Word Count:49|Reading Time:1mins

Installing Mysql using Docker Compose

version: '3'
services:
  mysql:
    image: mysql:8.0.18
    container_name: mysql8
    environment:
      - MYSQL_ROOT_PASSWORD=root
#      - TZ=Asia/Shanghai
    volumes:
      - ./log:/var/log/mysql
      - ./data:/var/lib/mysql
      - ./conf/conf.d:/etc/mysql/conf.d
      # - /etc/localtime:/etc/localtime:ro
    ports:
      - 3306:3306
    restart: always

Author: Chris Wen

Link: https://wenyupeng.github.io/2025/08/04/container/docker/03-docker-mysql/

Copyright Notice: All articles on this blog are licensed under CC BY-NC-SA 4.0 unless otherwise stated.

Related Articles

MySQL Installation Guide

MySQL Basic InformationMySQL is an open-source relational database management system (RDBMS) that uses Structured Query Language (SQL) for managing and manipulating data. It is widely used for web applications, data warehousing, and various other applications due to its reliability, performance, and ease of use. MySQL ArchitectureMySQL follows a client-server architecture, where the MySQL server manages the database and handles client requests. The server consists of several components, inclu...

MySQL Data Types

MySQL Data TypesThis chapter provides a structured overview of MySQL data types, including numeric, string, temporal, and other specialized types. Understanding these types is essential for esigning efficient and reliable database schemas. Numeric TypesInteger TypesMySQL provides several integer types (e.g., TINYINT, INT, BIGINT) to store whole numbers. Historically, these types allowed an optional display width (M). Key points: The display width (M) defines the minimum display width, not t...

Join QueryA JOIN query is used to combine rows from two or more tables based on a related column between them. There are several types of JOINs in MySQL, including INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN. INNER JOINThe INNER JOIN returns only the rows that have matching values in both tables.1234SELECT columnsFROM table1INNER JOIN table2ON table1.common_column = table2.common_column; LEFT JOINThe LEFT JOIN returns all rows from the left table and the matched rows from the right...

MySQL Storage Engine

MySQL Storage EngineMySQL supports multiple storage engines, each with its own features and use cases. The most commonly used storage engines are InnoDB and MyISAM. InnoDB: This is the default storage engine in MySQL. It supports transactions, foreign keys, and row-level locking, making it suitable for high-concurrency applications. InnoDB is designed for reliability and performance, and it is the recommended storage engine for most applications. MyISAM: This storage engine is older and does...

MySQL Functions

MySQL FunctionsMySQL provides a wide range of built-in functions that can be used to perform various operations on data. These functions can be categorized into several types, including string functions, numeric functions, date and time functions, and aggregate functions. String FunctionsString functions are used to manipulate and analyze string data. Some common string functions include: CONCAT(): Concatenates two or more strings. COMPARE(): Compares two strings and returns 0 if they are eq...

MySQL IndexIndexes are data structures that improve the speed of data retrieval operations on a database table at the cost of additional storage space and maintenance overhead. In MySQL, indexes are used to quickly locate and access the data in a table without having to scan the entire table. There are several types of indexes in MySQL, including: B-Tree Indexes: This is the most common type of index in MySQL. It organizes the data in a balanced tree structure, allowing for efficient searchi...

Loading Database