Optionally expose non-ephemeral MySQL port

[westonruter]

I've finally sat down to try to get PhpStorm to connect to the MySQL database in the wordpress-develop Docker environment. To do so, I needed to supply the port number for the mysql container. As noted in #48281, this can be done via:

docker-compose port mysql 3306

But it is annoying to have to re-run this to update the port in the PhpStorm database properties each time I start the wordpress-develop environment. Therefore, as with the LOCAL_PORT environment variable in .env for the web server, I suggest there be a LOCAL_DB_PORTS environment variable supported which allows a persistent port mapping to be established for the database:

docker-compose.yml

@@ -70 +70 @@
       - wpdevnet
 
     ports:
-      - "3306"
+      - "${LOCAL_DB_PORTS-3306}"
 
     environment:
       MYSQL_ROOT_PASSWORD: password

With this change in place, I can update my .env to contain:

LOCAL_DB_PORTS="33060:3306"

And then my wordpress-develop mysql container is always accessible from the same 33060 port.

Trac ticket: https://core.trac.wordpress.org/ticket/64014

Given an .env updated to append:

LOCAL_DB_PORTS="33060:3306"

I'm able to configure PhpStorm as follows:

And I'm then able to access the database:

Nice, I've confirmed this works as intended. I had done a couple one-off database ops inside the container, and this makes it more pleasurable.

PhpStorm

VS Code

[wildworks]

This ticket was featured on today's 6.9 Bug Scrub. The PR has been reviewed, but can we move this ticket forward?

[westonruter]

I'll go ahead and commit.

[westonruter]

In 60926:

Build/Test Tools: Introduce LOCAL_DB_PORTS environment variable.

This change introduces a LOCAL_DB_PORTS environment variable to the wordpress-develop Docker environment. This allows users to establish a persistent port mapping for the MySQL database, making it easier to connect to with development tools like PhpStorm. Otherwise, the default database port is ephemeral.

For example, setting LOCAL_DB_PORTS="33060:3306" in the .env file will make the MySQL container consistently accessible on port 33060.

Developed in ​https://github.com/WordPress/wordpress-develop/pull/9968.

Props westonruter, mindctrl.
See #48281.
Fixes #64014.