using --force didn't work for me.
Run this into ubuntu ternimal
apt-get update && apt-get install --no-install-recommends -y tzdata && apt-get clean && rm -r /var/lib/apt/lists/*
This command to update the tzdata. (if you have missing some timezone)
Need to clear the time_zone_name table. (won't cause anything)
delete from mysql.time_zone_name;
Run Jonathan query : Jonathan Query link
(Use mysql CLI)
Take a moment and appropriate Jonathan for this query:
Have a good day.