docker-compose & Exposed Ports

Hi there,
I'm trying to change the variable MYSQL_ROOT_PASSWORD
MYSQL_ROOT_PASSWORD: password
Unfortunately i can't access the database when i set to another value.
I have create the docker-compose.yml via <blockquote>bin/console make:docker:database</blockquote>
here is my docker-compose.yml

version: "3.8"
services:

  database:
    image: 'mysql:latest'
    container_name: '${DATABASE_NAME}'
    command: --default-authentication-plugin=mysql_native_password
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: '${DATABASE_ROOT_USER_PWD}'
      MYSQL_DATABASE: '${DATABASE_NAME}'
    ports:
      # To allow the host machine to access the ports below, modify the lines below.
      # For example, to allow the host to connect to port 3306 on the container, you would change
      # "3306" to "3306:3306". Where the first port is exposed to the host and the second is the container port.
      # See https://docs.docker.com/compose/compose-file/#ports for more information.
      - '3306'

and my .env

#  ...

###> doctrine/doctrine-bundle ###
# Format described at https://www.doctrine-project.org/projects/doctrine-dbal/en/latest/reference/configuration.html#connecting-using-a-url
# IMPORTANT: You MUST configure your server version, either here or in config/packages/doctrine.yaml
#
# DATABASE_URL="sqlite:///%kernel.project_dir%/var/data.db"
DATABASE_URL="mysql://db_user:db_password@127.0.0.1:3306/db_name?serverVersion=5.7&charset=utf8mb4"
#DATABASE_URL="mysql://root:R2OAR2I@127.0.0.1:3306/animals?serverVersion=5.7&charset=utf8mb4"
#DATABASE_URL="postgresql://symfony:ChangeMe@127.0.0.1:5432/app?serverVersion=13&charset=utf8"
###< doctrine/doctrine-bundle ###

DATABASE_NAME=test
DATABASE_ROOT_USER_PWD=test

Any ideas why setting a new root password doesn't work?

so docker deletes the image each time? This doesn't sound ideal. Is there a way to keep the docker database image so we can continue working on the data? Introducing volumes would have been a good idea as it's not great to rebuild the DB everytime - you'd probably need to use a bash command right to load fixtures and build the DB?

Hello,

I'm working on a mac, using Docker Desktop.

I downloaded the "finish" project.

I run :

$ docker-compose up -d

The composer image build correctly. I can see the logs on my terminal, and even the containers buing built on the Docker Desktop.

I can even do $ docker-compose ps and see my container running :

NAME                COMMAND                  SERVICE             STATUS              PORTS
finish-database-1   "docker-entrypoint.s…"   database            running             33060/tcp, 0.0.0.0:58553->3306/tcp

I start the symfony server $ symfony server:start -d without any issue.

Now let's run $ symfony var:export --multiline --vv (I add the "vv" to have see any issue), and then ... surprise :

30/10 09:45:07 WARNING   symfony  Cannot connect to the Docker daemon at unix:///var/run/docker.sock. Is the docker daemon running?
export SYMFONY_APPLICATION_DEFAULT_ROUTE_HOST=127.0.0.1:8001
export SYMFONY_APPLICATION_DEFAULT_ROUTE_PATH=/
export SYMFONY_APPLICATION_DEFAULT_ROUTE_PORT=8001
export SYMFONY_APPLICATION_DEFAULT_ROUTE_SCHEME=https
export SYMFONY_APPLICATION_DEFAULT_ROUTE_URL=https://127.0.0.1:8001/
export SYMFONY_DEFAULT_ROUTE_HOST=127.0.0.1:8001
export SYMFONY_DEFAULT_ROUTE_PATH=/
export SYMFONY_DEFAULT_ROUTE_PORT=8001
export SYMFONY_DEFAULT_ROUTE_SCHEME=https
export SYMFONY_DEFAULT_ROUTE_URL=https://127.0.0.1:8001/
export SYMFONY_DOCKER_ENV=
export SYMFONY_PROJECT_DEFAULT_ROUTE_HOST=127.0.0.1:8001
export SYMFONY_PROJECT_DEFAULT_ROUTE_PATH=/
export SYMFONY_PROJECT_DEFAULT_ROUTE_PORT=8001
export SYMFONY_PROJECT_DEFAULT_ROUTE_SCHEME=https
export SYMFONY_PROJECT_DEFAULT_ROUTE_URL=https://127.0.0.1:8001/
export SYMFONY_TUNNEL=
export SYMFONY_TUNNEL_ENV=

Symfony CLI seems to not to be able to get the Docker API & extract the VARS as it supposed to do ... So can't run the project.

Can you help me find a solution ?

Thank you.

Hello, my cli generates hashtags instead of asterisks in annotations, is there a way to change/configure that somewhere?

Hi, I'm having issues connecting to mysql :

<br />mysql -u symfony --password=ChangeMe --host=127.0.0.1 --port=52883<br />mysql: [Warning] Using a password on the command line interface can be insecure.<br />ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0<br />

docker-compose ps
start_database_1 docker-entrypoint.sh postgres Up 0.0.0.0:52883->5432/tcp<br />

my .env
DATABASE_URL="postgresql://db_user:db_password@127.0.0.1:5432/db_name?serverVersion=13&charset=utf8"<br />

docker-compose.yml von recipes
`version: '3'

services:
###> doctrine/doctrine-bundle ###
database:

image: postgres:${POSTGRES_VERSION:-13}-alpine
environment:
  POSTGRES_DB: ${POSTGRES_DB:-app}
  # You should definitely change the password in production
  POSTGRES_PASSWORD: ${POSTGRES_PASSWORD:-ChangeMe}
  POSTGRES_USER: ${POSTGRES_USER:-symfony}
volumes:
  - db-data:/var/lib/postgresql/data:rw
  # You may use a bind-mounted host directory instead, so that it is harder to accidentally remove the volume and lose all your data!
  # - ./docker/db/data:/var/lib/postgresql/data:rw

###< doctrine/doctrine-bundle ###

volumes:
###> doctrine/doctrine-bundle ###
db-data:
###< doctrine/doctrine-bundle ###
`

how can i fix them

For those not using Docker
In terminal set your mysql path to your installation of mysql
set path=%PATH%;C:\xampp\mysql\bin;
And then you can continue with the course
The standard port for xampp or mamp = 3306
mysql -u root --password=root--host=127.0.0.1 --port=3306

Is it possible to skip docker or docktrine completely using Symfony? I like the Symfony structure and Twig, but for now I'd like to just connect with my MySQL Database and use PDO.

Hi everybody, I have problem. I dont get name of database after I wrote:SHOW DATABASES. I get just arrows..... Do you have idea where is problem?

bruch@bruch-Latitude-E6520:~/Stažené/code-symfony-doctrine/start$ sudo docker-compose ps
Name Command State Ports
-------------------------------------------------------------------------------------------
start_database_1 docker-entrypoint.sh mysqld Up 0.0.0.0:32768->3306/tcp, 33060/tcp
bruch@bruch-Latitude-E6520:~/Stažené/code-symfony-doctrine/start$ sudo mysql -u root --password=password --host=127.0.0.1 --port=32768
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.22 MySQL Community Server - GPL
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SHOW DATABASES
->
->

Hi

I'm having issues connecting to mysql

any help ?

macbookpro@Leonardo cauldron_overflow % docker-compose exec database mysql -u root -password=password
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Hi,
I can't talk with mysql, where I have installed mysql locally. But app shows error I have added below:-

$ mysql -u root --password=123456 --host=127.0.0.1 --port=32768
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (10061)

I have changed mysql root password to 123456 because of my #mysql root password is 123456.