Run MySQL in a Docker container
How to run MySQL commands in a Docker container.
<pre lang="bash">
#!/bin/bash
set -a; source /dev/null
- The first command loads the content of .env to environment variables.
- The MySQL password can then be used using the ${MYSQL_PASSWORD} variable.
- I’m using sed to get around the special characters in the password.
- The second command runs docker exec on wp_db container.
- The last 3 commands are the actual sql commands.
- We are selecting to use the db1 database.
- Then we run select statements from the wp_options table.
- Finally, 2>/dev/null suppresses errors and warning to null.