Why not using mysql in docker too? first, I just beginner in this container/docker thing, so I don’t know how reliable docker volumes. For safer/easier way, I use direct sql installation in host. But how if you container want to access your sql, here is how to do it
-
Check your container IP address using
docker inspect your-container-name |grep IPAdress
Check Container IP Address
-
Create sql user in your local sql
Create a New User for Your Container Only
-
Don’t forget to allow container IP Address in your firewall.
Allow IP in UFW
To check sql connection between container & host, you can install mysql-client at container & try connect to host mysql