Last login: Fri Apr 5 14:47:09 on ttys001 Joseph-Kosinskis-MacBook:~ josephkosinski$ SELECT CONVERT_TZ('2012-06-07 12:00:00', 'GMT', 'America/New_York'); -bash: syntax error near unexpected token `(' Joseph-Kosinskis-MacBook:~ josephkosinski$ Joseph-Kosinskis-MacBook:~ josephkosinski$ Joseph-Kosinskis-MacBook:~ josephkosinski$ SELECT CONVERT_TZ('2012-06-07 12:00:00', 'GMT', 'America/New_York'); -bash: syntax error near unexpected token `(' Joseph-Kosinskis-MacBook:~ josephkosinski$ /usr/local/mysql/bin/ -bash: /usr/local/mysql/bin/: is a directory Joseph-Kosinskis-MacBook:~ josephkosinski$ ./mysql -u root -bash: ./mysql: No such file or directory Joseph-Kosinskis-MacBook:~ josephkosinski$ cd /usr/local/mysql/bin/ Joseph-Kosinskis-MacBook:bin josephkosinski$ ./mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.6.10-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial) Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> SELECT * FROM mysql time_zonename; ERROR 1046 (3D000): No database selected mysql> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql -> -> -> \c mysql> SELECT * FROM time_zone; Empty set (0.00 sec) mysql> SELECT * FROM time_zone_name; Empty set (0.00 sec) mysql> mysql_tzinfo_to_sql /usr/share/zoneinfo > sqlLines -> \q Bye Joseph-Kosinskis-MacBook:bin josephkosinski$ mysql_tzinfo_to_sql /usr/share/zoneinfo > sqlLines -bash: sqlLines: Permission denied Joseph-Kosinskis-MacBook:bin josephkosinski$