Skip to content
Notas

Install MySQL Server

Linux:

Install MySQL Server:

https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-20-04 https://dev.mysql.com/doc/refman/8.3/en/linux-installation-apt-repo.html

#!/bin/bash
sudo apt -y update
sudo apt -y install mysql-server
sudo systemctl start mysql.service
#!/bin/bash
sudo mysql
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
mysql> exit
sudo mysql_secure_installation
mysql -u root -p
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH auth_socket;

Docker:

Docker compose:

DB_PORT=3306
DB_DATABASE=mydatabase
DB_USERNAME=mydatabase
DB_PASSWORD=mydatabase
version: '3.9'


services:


  mysql:
    platform: linux/x86_64
    image: 'mysql:8.0.34'
    volumes:
      - '.mysql:/var/lib/mysql'
    ports:
      - "127.0.0.1:${DB_PORT_FORWARD:-}:${DB_PORT:-3306}"
    networks:
      - backend
    restart: unless-stopped
    environment:
      MYSQL_ROOT_PASSWORD: '${DB_PASSWORD}'
      MYSQL_DATABASE: '${DB_DATABASE}'
      MYSQL_USER: '${DB_USERNAME}'
      MYSQL_PASSWORD: '${DB_PASSWORD}'
      MYSQL_ALLOW_EMPTY_PASSWORD: 'yes'
    healthcheck:
      test: ['CMD', 'mysqladmin', 'ping']


networks:
  backend:
    driver: bridge


volumes:
  '.mysql':
    driver: local

Docker run:

  • —platform linux/x86_64 -> Compatible con procesadores de Apple.
  • -e MYSQL_ROOT_PASSWORD=root -> Variables de entorno.
  • -d -> “Detach mode”.
  • -P -> Expone los puertos al host en los que estén disponibles.
Terminal window
docker run --platform linux/x86_64 -e MYSQL_ROOT_PASSWORD=root -d -P mysql:8.0.34