DISABLE SECURE FILE PRIV MYSQL IN SEQUEL PRO MAC PASSWORD
Ensure that volume was freshly created when starting Docker because users and passwords are created only on initial startup (so changing passwords in docker-compose.yml doesn't actually change password in existing volume).For example, if the machine that's running the mysql container is using 192.168.1.25 on my network, that will be the IP entered to access my database. Using the compose file above, to connect to the database, you'll need to use the IP of the machine that the container is being hosted on, rather than the IP of the container so localhost won't work unless a user with host 172.20.0.1 is created - and localhost won't work on a different machine because 127.0.0.1 is loopback. Network: #will be prefixed with 'parent_dir_name_' so for me, it will be 'mysql_network'Ĭurrently looking into other ways and learning more about networking and docker. # Generally not recommended by some people to allow for root. # Use % to allow remote access to all addresses. After reading the error, it seems like you can only re-use user defined networks.Įnv_file: #Use environment variables from file. However, you do have the ability to specify the subnet for the new network ( this video does a good enough job to helping you understand subnetting assuming you already know a bit of binary math).ĭocumentation doesn't seem to be updated or at least I was unable to use "bridge", so what I did was create a new network. In docker-compose version 3, you lose the ability to specify your own gateway for a new network - I'm guessing the gateway will always be x.x.x.1. To view available networks, you can use docker network ls.Ī new root host needs to be specified to allow specified IPs to connect if you're going to use docker-compose the way you have it, but you will also need to know what your new subnet will be. By default, mysql will use 172.17.0.1 as a gateway for communication - which is normally the value on the 'bridge' network (you can view this using docker inspect bridge and docker inspect ). When using docker-compose, a new network is created with a different subnet, leading to a new gateway and ip address.
0 kommentar(er)
