Unable to exec mysql command and to use $MYSQL_ROOT_PASSWORD with mysql docker in Windows

Question

From powershell console, I manage to run mysql command inside my mysql docker:

docker exec mysql-container mysql -u root -psecret -e 'show databases;'

But if I want to replace my password by MYSQL_ROOT_PASSWORD, it doesn't work anymore:

docker exec mysql-container mysql -u root -p$MYSQL_ROOT_PASSWORD -e 'show databases;'
# ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

It seems powershell interprets $MYSQL_ROOT_PASSWORD and pass it as empty to the container.

Other commands I tried:

docker exec mysql-container sh -c "mysql -u root -p$MYSQL_ROOT_PASSWORD -e 'show databases;'"
# Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

docker exec mysql-container sh -c 'mysql -u root -p$MYSQL_ROOT_PASSWORD -e "show databases;"'
# ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

seems like you are in the window. you can use "`". serverfault.com/questions/47811/… — Adiii
– Adiii, Commented Nov 29, 2019 at 10:18

Adiii · Accepted Answer · 2019-11-29 10:11:18Z

1

Try with -it as it will exit because you are not allocating tty, also add escape character before password, otherwise, it will look for environment variables from the host, not inside the container.

docker exec -it mysql-container bash -c " mysql  -u root -p"\$MYSQL_ROOT_PASSWORD" -e 'show databases;'"

answered Nov 29, 2019 at 10:11

Adiii

61.1k10 gold badges180 silver badges174 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nicolas Over a year ago

With your command I get Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO). Escaping the dollar doesn't seem to work.

Nicolas · Accepted Answer · 2019-11-29 12:58:45Z

0

I finally manage to get the good amount of quotes to make the command run:

docker exec mysql-container sh -c 'mysql -u root -p$MYSQL_ROOT_PASSWORD -e ''show databases;'''

answered Nov 29, 2019 at 12:58

Nicolas

6,5545 gold badges40 silver badges54 bronze badges

Collectives™ on Stack Overflow

Unable to exec mysql command and to use $MYSQL_ROOT_PASSWORD with mysql docker in Windows

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related