MySQL on macOS via Homebrew: Security

๐Ÿ’ก MySQL on macOS via Homebrew: Security โ€” Executive Summary

Technical architectural analysis, practical configuration manifests, and deployment instructions for MySQL on macOS via Homebrew: Security.

Docker-based local setting

installation
bash
brew install colima docker mysql-client
exec
bash
colima start
docker run --name spring-mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=root -e MYSQL_DATABASE=spring_db -d mysql:8.0
mysql -uroot -proot -h127.0.0.1 -P3306
Rerun after colima stop
bash
colima restart
containerID=$(docker ps -a | grep mysql | awk '{print $1}')
docker start $containerID
sleep 1
mysql -uroot -proot -h127.0.0.1 -P3306
samples
fast_starter.sh
bash
port=3306
image="mysql:8.0"
container_name="spring-mysql"
MYSQL_ROOT_PASSWORD=root
MYSQL_DATABASE=spring_db

brew install colima docker
colima start
containerID=$(docker ps -a | grep $image | awk '{print $1}')
if [ -n "$containerID" ]; then
  docker start $containerID
else
  docker run --name $container_name \
  -p $port:$port \
  -e MYSQL_ROOT_PASSWORD=$MYSQL_ROOT_PASSWORD \
  -e MYSQL_DATABASE=$MYSQL_DATABASE \
  -d $image
fi

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *