MySQL - Gary' Blog

A script to test MySQL port is running

2023-05-03 110 Technical MySQL Leave a Comment

#!/bin/bash ip="<MySQL HOST>" port="<MySQL PORT>" output_file="<Log File Path>" while : do nc -zv "$ip" "$port" > /dev/null datetime=$(date +"%Y-%m-%d %H:%M:%S") if [ $? -eq 0 ]; then echo "$datetime: Port $port is open on $ip…

MySQL REGEXP_REPLACE() function

2022-05-15 676 Uncategorized MySQL Leave a Comment

Notice: Corrently, REGEXP_REPLACE() do not support \s. Here is an example of using MySQL 8+ regexp_replace(): > select regexp_replace('<div>Hello <b>world</b></div>', '<b>.*?</b>', 'MySQL', 1, 0, 'in') as result; +---------------------…

Quick start docker containers in one command

2022-05-10 663 Technical Docker, Kafka, MySQL, RabbitMQ, Redis Leave a Comment

If you want start container as daemon, just add argument -d to the command If you want the container has a name, add argument --name <Container Name> MySQL Quick start MySQL from Docker, ~ docker run --rm -p 3306:3306 -e MYSQL_ROOT_PASSWORD=12345678 mysql The login info will be username: root password: 1…