Time zone - Revision history

Qljca at 16:10, 20 June 2024

2024-06-20T16:10:38Z

← Older revision		Revision as of 16:10, 20 June 2024
Line 1:		Line 1:
			==Change Server Time Zone==

	On cPanel Server, we can change Server Time Zone from WHM.		On cPanel Server, we can change Server Time Zone from WHM.

Line 10:		Line 12:

	It is recommended to reboot the server.		It is recommended to reboot the server.

			==MySQL time zone==

			By default, this will match server time. If you change the time zone for the server, mysql needs to be restarted before the new time will be seen. If you needed to set the mysql timezone directly for some reason, you can use:

			Import timezone tables into mysql (IF NEEDED)
			<pre>mysql_tzinfo_to_sql /usr/share/zoneinfo/\|mysql -u root mysql</pre>

			Set timezone in /etc/my.cnf
			<pre>
			default_time_zone='Australia/Melbourne'
			</pre>
			<pre>
			service mysql restart
			</pre>


			==PostgreSQL timezone==

			Check Current time:
			<pre>
			show timezone;
			</pre>

			Change
			<pre>
			ALTER DATABASE DBNAME SET timezone to 'America/New_York';
			</pre>

			Exit, re-login, and verify.

			==Crontab/shell timezone==

			Login as user via SSH:
			<pre>
			echo 'export TZ="/usr/share/zoneinfo/America/Detroit"' >> ~/.bashrc
			source ~/.bashrc
			</pre>

Qljca at 11:58, 20 June 2024

2024-06-20T11:58:18Z

← Older revision		Revision as of 11:58, 20 June 2024
Line 1:		Line 1:
			On cPanel Server, we can change Server Time Zone from WHM.

	Step 1: Log into WHM		Step 1: Log into WHM

Qljca: Created page with "Step 1: Log into WHM Step 2: Navigate to Server Time. Step 3: Select the new TimeZone from the drodown. Step 4: Click Save. It is recommended to reboot the server."

2024-06-20T11:57:41Z

Created page with "Step 1: Log into WHM Step 2: Navigate to Server Time. Step 3: Select the new TimeZone from the drodown. Step 4: Click Save. It is recommended to reboot the server."

New page

Step 1: Log into WHM

Step 2: Navigate to Server Time.

Step 3: Select the new TimeZone from the drodown.

Step 4: Click Save.

It is recommended to reboot the server.