so I'm really new to docker and I may be using it incorrectly here but it makes spinning up a mysql database REALLY easy so thats why I wanted to give it a shot rather than installing an instance on my remote (on LAN) machine.
So I want to access the MariaDB database from a different/remote machine however everywhere I look it seems to be providing outdated information, (even the official mariaDB documentation) doesnt provide the correct information, I tried what they say and I believe that is only for accessing the container from the same machine it's running on. Any article or *exchange answer I see tells you to go into the bash terminal of the container then change /etc/msql/my.cnf
to have bind_address=0.0.0.0
and this is outdated as bind_address
isnt even in my.cnf anymore it's located in /etc/mysql/mariadb.conf.d/50-server.cnf
and in there there is a line that states
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
I also couldnt find any refrence to an enviroment variable I could set in order to allow me to access it remotely so I really don't know where to look anymore about how to change the configuration in order to allow me to access the data base from my network.
And yes I have a user setup to allow remote connections. Any and all help is appreciated.
On a side note, it seems to be really hard to change this so it makes me believe this is bad practice or to be avoided and then that makes me believe I'm understanding docker wrong, I thought docker was supposed to allow you to run small instances of software that dont interact with each other so if one instance gets screwed up the rest dont but why are they so intent on not allowing a remote connection?
docker run -p {IP}:{exposed port}:3306 .....