When I setup SeaTable I used a MYSQL_ROOT_PASSWORD that contains special characters, thinking I was being smart making it extra secure. I’m trying to setup automated backups using the Admin Manual instructions and I’m running into issues with the special characters when I include them in the command. I’d like to change the MYSQL_ROOT_PASSWORD to alpha numeric but I’m not an SQL person and have no idea where to start. I assume it’s not as simple as just changing in the Docker Compose YAML? Can someone please point me to the best way to do this?
All the tutorials I’ve found on this topic start off with “systemctl stop mysql” but the seatable-mysql container doesn’t appear to use systemctl, so I’m a bit lost on this now.
I assume I then just need to update all the SeaTable configs with the new password and everything will work fine? No other tricks I should be aware of? Thanks in advance.