mysql timezone info

You are here: Index > AMPPS > General Support > Topic : mysql timezone info

Threaded Mode | Print

mysql timezone info (2 Replies, Read 4021 times)

wilco83	# March 15, 2014, 8:49 pm
Group: Member Post Group: Newbie Posts: 2 Status:	How do I go about setting up the timezone tables? When I look in phpmyadmin there are no mysql tables to speak of, which is where I believe the timezone settings would normally go.
IP: --

mysql timezone info

wilco83	# March 16, 2014, 3:05 am \| Post: 1
Group: Member Post Group: Newbie Posts: 2 Status:	I've spent more time on this, but am now going crazy. After reading the MySQL manual for the umpteenth time, I have concluded that what I am doing must be right... I have run the following command in terminal: PHP Code `./mysql_tzinfo_to_sql /usr/share/zoneinfo \| ./mysql -u root -p {password} mysql` Terminal doesn't throw out any errors at this time, but still, using the convert_tz or related functions all result in a null result. Thoughts?
IP: --

mysql timezone info

tidus	# March 19, 2014, 9:14 am \| Post: 2
Group: Member Post Group: Super Member Posts: 1121 Status:	Hi, "mysql" is table is just hidden, so that users who are new don't delete it unknowingly. You can change the config.inc.php of phpmyadmin from Code $cfg['Servers'][$i]['hide_db'] = '(mysql\|information_schema\|performance_schema)'; to Code $cfg['Servers'][$i]['hide_db'] = '(information_schema\|performance_schema)'; You can set default timezone in AMPPS Application -> MySQL Tab -> Configuration. In [mysqld] section add Code default_time_zone='+00:00' ----------------------- Follow AMPPS on, Twitter : https://twitter.com/AMPPS_Stack Facebook : http://www.facebook.com/softaculousampps Google+ : https://plus.google.com/+AmppsStack
IP: --

« Previous Next »

Threaded Mode | Print

Jump To :

Users viewing this topic
	1 guests, 0 users.

All times are GMT. The time now is April 29, 2024, 7:14 pm.

Powered By AEF 1.0.8 © 2007-2008 Electron Inc.

Queries: 10 | Page Created In:0.027