Fix for logging issue
ERROR 1419 (HY000) at line 410: You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)
login into the mysql container
docker exec -it wow-mysql-cont /bin/bash
cd /etc/mysql/
cp my.cnf mycnfbk
After the backup of my.cnf and execute following commant to add it in the end of the file
echo 'log_bin_trust_function_creators = 1' >> my.cnf
cleaning dump database
sed -i 's/DEFINER=[^*]*\*/\*/g'
Posted by vasan to vasan's deck (2022-06-09 05:16)