After upgrading from MySQL 5.7 to 8.0, I created a MySQL database and set it to only allow access from the local server (127.0.0.1). When Docker containers try to access the SQL server using 127.27.0.1, they receive the error: Error in connector: Error querying the database: Server error: ERROR HY000 (1130): Host '172.25.0.2' is not allowed to connect to this MySQL server.
Many containers are experiencing this issue. How can I resolve it? I only want the databases to be accessible from within the host machine.
In MySQL 5.7, everything worked fine. Both MySQL 5.7 and 8.0 are using the default configuration.
