How can I access the mysql from shell?

[ratul0]

Hi @tomsik68 can you please tell me how to access docker-xampp 's mysql from the shell? It would be a great help.

[tomsik68]

Hey, you should be able to use mysql cli utility on the guest machine to do so. The simplest way to get on the guest machine is to run docker exec -ti <container name> bash on your host.

If you want to access mysql from host machine, you can forward mysql's default port(I think 3306) from the container and use mysql to connect to it.

[ratul0]

@tomsik68 I followed your instruction, but it says bash: mysql: command not found

[tomsik68]

Hmm you can try installing mysql in the container then apt-get -y install mysql

Edit: future readers, see comment below for answer!

[tirjok]

@ratulcse27 Please run in your bash export PATH=/opt/lampp/bin:$PATH

Then you will get all of this service