version: '3.1' services: db: image: mysql:5.7.44 command: --default-authentication-plugin=mysql_native_password restart: always ports: - "3306:3306" environment: MYSQL_DATABASE: example MYSQL_USER: example MYSQL_PASSWORD: exampleUSER MYSQL_ROOT_PASSWORD: exampleROOT TZ: "UTC" volumes: - db_data:/var/lib/mysql - ./custom.cnf:/etc/mysql/conf.d/custom.cnf
[mysqld] performance_schema = 0
mysql> SHOW VARIABLES LIKE "performance_schema"; +--------------------+-------+ | Variable_name | VALUE | +--------------------+-------+ | performance_schema | OFF | +--------------------+-------+ 1 ROW IN SET (0.00 sec)
sudo docker compose up -d --build # rootで接続 mysql -h 127.0.0.1 -P 3306 -u root -p # example userで接続 sudo -u zabbix mysql -h 127.0.0.1 -u example -p example
記事:
PukiWiki 1.5.3 © 2001-2020 PukiWiki Development Team. Powered by PHP 7.4.33. HTML convert time: 0.053 sec.