Resolving Common Issues When Upgrading to MySQL 8.0
Encountered Problems During Installation
The steps below are based on MySQL 8.0.13, downloaded as a ZIP archive from the official MySQL website. For manual installation of the ZIP version, initialization is required after extraction. Use the following command:
mysqld --initialize --user=mysql --console
If the command fails, ensure you are runn ...
Posted on Mon, 21 Sep 2026 16:29:58 +0000 by texerasmo
Managing System Date, Time, and Timezone with timedatectl in Linux
Overview
The timedatectl command is a modern utility available in RHEL/CentOS 7 and Fedora 21+ systems. It serves as part of the systemd system and service manager, replacing the traditional date command used in sysvinit-based Linux distributions.
This command allows you to query and modify the system clock, configure time settings, set timezon ...
Posted on Wed, 16 Sep 2026 16:03:00 +0000 by whiteboikyle
Java Time Zone Handling and Date-Time Operations
Java provides robust time zone managemant through the java.time API. China historically used five distinct time zones:
Asia/Harbin: GMT+8:30 (Changbai Time Zone)
Asia/Shanghai: GMT+8 (Standard Time Zone)
Asia/Chongqing: GMT+7 (Longshu Time Zone)
Asia/Urumqi: GMT+6 (Tibetan Time Zone)
Asia/Kashgar: GMT+5:30 (Kunlun Time Zone)
Retrieving Time Z ...
Posted on Sat, 12 Sep 2026 16:30:34 +0000 by sdaniels
First Bug in December 2019
It is December 1, 2019, at 12:27 AM, and I'm still struggling to calm down. This month was the last of 2019, the final month of the 2010s, and the last month before the first group of 90s-born individuals turned 30. On the very first day of this month, at exactly midnight, the code I wrote contained a bug that left me completely frustrated.
Her ...
Posted on Thu, 03 Sep 2026 16:31:08 +0000 by lunas
Time Actually Rewinds 343 Seconds in Java: Understanding Historical Timezone Data Quirks
Look at this Java code:
public class MainTest {
public static void main(String[] args) throws Exception {
SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
Date date = simpleDateFormat.parse("1900-01-01 08:00:00");
System.out.println(simpleDateFormat.format(date));
...
Posted on Tue, 25 Aug 2026 16:17:42 +0000 by fabiuz
Python Time Module: Advanced Time Manipulation and Conversion
Overview The Python time module provides various functions for working with time. Related functionality can be found in the datetime and calendar modules.
While this module is available on all platforms, not all functions are supported across all platforms. Most functions in this module are implemented by calling the corresponding functions in ...
Posted on Wed, 01 Jul 2026 17:26:56 +0000 by Peter Anselmo