Query MySql database in Docker

Question

I have a docker container with mariadb, and have created a database my_db in it (through an external script in a different container). How can I run SQL queries on my_db now from the command line? I just want to do

select * from my_table

from the terminal that is running the container.

Creek · Accepted Answer · 2017-03-31 20:38:23Z

3

Easiest way is to exec into the container and execute the query using the mysql client, given the clients installed.

docker exec -it CONTAINER_NAME mysql -p -e 'QUERY' DB_NAME

answered Mar 31, 2017 at 20:38

Creek

2122 silver badges10 bronze badges

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

Comments

Rick James · Accepted Answer · 2017-04-01 21:57:09Z

1

If you have the commandline tool installed in the app container,

mysql -h 192.168.1.7 -u admin -pxyz -P 10202

This allows for the docker instance to be on another machine (192...) and with a special port (-P ...), etc. (I have multiple docker containers; that one is for MariaDB 10.2.2.)

answered Apr 1, 2017 at 21:57

Rick James

144k15 gold badges144 silver badges255 bronze badges

2 Comments

Drake Over a year ago

What is -pxyz for?

Rick James Over a year ago

-p, no space, is how you can put the password on the commandline.

Collectives™ on Stack Overflow

Query MySql database in Docker

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related