SQLSTATE[HY000]: General error: 1298 Unknown or incorrect time zone: 'UTC' windows

759
March 04, 2017, at 10:39 AM

I am getting this error while setting up a PHP source code in Windows Wamp server.

SQLSTATE[HY000]: General error: 1298 Unknown or incorrect time zone: 'UTC'

Please let me know how to solve.

Thanks.

Answer 1

You have two ways to solve this problem.

Install the timezone database

The mysql_tzinfo_to_sql program loads the time zone tables in the mysql database. It is used on systems that have a zoneinfo database (the set of files describing time zones). Examples of such systems are Linux, FreeBSD, Solaris, and OS X. One likely location for these files is the /usr/share/zoneinfo directory (/usr/share/lib/zoneinfo on Solaris). If your system does not have a zoneinfo database, you can use the downloadable package described in Section 11.6, “MySQL Server Time Zone Support”.

mysql_tzinfo_to_sql can be invoked several ways:

shell> mysql_tzinfo_to_sql tz_dir
shell> mysql_tzinfo_to_sql tz_file tz_name
shell> mysql_tzinfo_to_sql --leap tz_file

For the first invocation syntax, pass the zoneinfo directory path name to mysql_tzinfo_to_sql and send the output into the mysql program. For example:

shell> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql

mysql_tzinfo_to_sql reads your system's time zone files and generates SQL statements from them. mysql processes those statements to load the time zone tables.

The second syntax causes mysql_tzinfo_to_sql to load a single time zone file tz_file that corresponds to a time zone name tz_name:

shell> mysql_tzinfo_to_sql tz_file tz_name | mysql -u root mysql

If your time zone needs to account for leap seconds, invoke mysql_tzinfo_to_sql using the third syntax, which initializes the leap second information. tz_file is the name of your time zone file:

shell> mysql_tzinfo_to_sql --leap tz_file | mysql -u root mysql

After running mysql_tzinfo_to_sql, it is best to restart the server so that it does not continue to use any previously cached time zone data.

source: https://dev.mysql.com/doc/refman/5.7/en/mysql-tzinfo-to-sql.html

Remove or comment out offending statement from your my.cnf file

default-time-zone = UTC

This will cause it to inherit the timezone from the OS instead.

Rent Charter Buses Company
READ ALSO
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in

Warning: mysqli_query() expects parameter 1 to be mysqli, null given in

I am trying to build a simple custom CMS, but I'm getting an error:

702
Softon\Indipay is not instantiable while building

Softon\Indipay is not instantiable while building

I received this message when i try to instantiate Soften\Indipay on Laravel 54* github

591
codeigniter ajax image upload

codeigniter ajax image upload

I was following a tutorial that teaches how to to upload image with ajax and CodeIgniterBut i kind of run into INTERNAL SERVER ERROR each time i tried to run the code

441
How to concatenate in a SQL query to get variable from database?

How to concatenate in a SQL query to get variable from database?

As a beginner I'm not fan of concatenating but I think this is something that would be really useful for me to knowSo I have a while statement that gets data from a table in a database

372