Last login: Thu Apr 4 18:13:16 on ttys000 Joseph-Kosinskis-MacBook:~ josephkosinski$ cd /uar/local/mysql/bin/ -bash: cd: /uar/local/mysql/bin/: No such file or directory Joseph-Kosinskis-MacBook:~ josephkosinski$ cd usr/local/msql/bin/ -bash: cd: usr/local/msql/bin/: No such file or directory Joseph-Kosinskis-MacBook:~ josephkosinski$ cd /usr/local/mysql/bin Joseph-Kosinskis-MacBook:bin josephkosinski$ Joseph-Kosinskis-MacBook:bin josephkosinski$ mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql -bash: mysql: command not found -bash: mysql_tzinfo_to_sql: command not found Joseph-Kosinskis-MacBook:bin josephkosinski$ ./mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 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 COUNT(*) FROM mysql.time_zone_name; +----------+ | COUNT(*) | +----------+ | 0 | +----------+ 1 row in set (0.00 sec) mysql> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql -> SELECT COUNT(*) FROM mysql.time_zone_name; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql SELECT COUNT(*) FR' at line 1 mysql> SELECT COUNT(*) FROM mysql.time_zone_name; +----------+ | COUNT(*) | +----------+ | 0 | +----------+ 1 row in set (0.00 sec) mysql> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -> SELECT COUNT(*) FROM mysql.time_zone_name; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root SELECT COUNT(*) FROM mys' at line 1 mysql> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql -> \c mysql> up2date tzdata -> mysql_tzinfo_to_sql /usr/share/zoneinfo/ > timezone.sql -> -> \c mysql> SET GLOBAL time_zone = timezone; ERROR 1298 (HY000): Unknown or incorrect time zone: 'timezone' mysql> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql -> \c mysql> mysqld --verbose --help -> -> -> -> -> -> \q Bye Joseph-Kosinskis-MacBook:bin josephkosinski$ mysqld --verbose --help -bash: mysqld: command not found Joseph-Kosinskis-MacBook:bin josephkosinski$ cd .. Joseph-Kosinskis-MacBook:mysql josephkosinski$ mysqld --verbose --help -bash: mysqld: command not found Joseph-Kosinskis-MacBook:mysql josephkosinski$ ./mysql -u root -bash: ./mysql: No such file or directory Joseph-Kosinskis-MacBook:mysql josephkosinski$ cd /usr/local/msql/bin -bash: cd: /usr/local/msql/bin: No such file or directory Joseph-Kosinskis-MacBook:mysql josephkosinski$ cd .. Joseph-Kosinskis-MacBook:local josephkosinski$ cd .. Joseph-Kosinskis-MacBook:usr josephkosinski$ cd /usr/local/msql/bin/ -bash: cd: /usr/local/msql/bin/: No such file or directory Joseph-Kosinskis-MacBook:usr 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 7 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> mysqld --verbose --help -> -> -> \c mysql> mysqld -> verbose -> help; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqld verbose help' at line 1 mysql> mysqld help; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqld help' at line 1 mysql> mysqld verbose help -> mysqld verbose help; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqld verbose help mysqld verbose help' at line 1 mysql> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root' at line 1 mysql> mysql_tzinfo_to_sql; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql_tzinfo_to_sql' at line 1 mysql> mysqld --verbose --help; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqld --verbose --help' at line 1 mysql> \h For information about MySQL products and services, visit: http://www.mysql.com/ For developer information, including the MySQL Reference Manual, visit: http://dev.mysql.com/ To buy MySQL Enterprise support, training, or other products, visit: https://shop.mysql.com/ List of all MySQL commands: Note that all text commands must be first on line and end with ';' ? (\?) Synonym for `help'. clear (\c) Clear the current input statement. connect (\r) Reconnect to the server. Optional arguments are db and host. delimiter (\d) Set statement delimiter. edit (\e) Edit command with $EDITOR. ego (\G) Send command to mysql server, display result vertically. exit (\q) Exit mysql. Same as quit. go (\g) Send command to mysql server. help (\h) Display this help. nopager (\n) Disable pager, print to stdout. notee (\t) Don't write into outfile. pager (\P) Set PAGER [to_pager]. Print the query results via PAGER. print (\p) Print current command. prompt (\R) Change your mysql prompt. quit (\q) Quit mysql. rehash (\#) Rebuild completion hash. source (\.) Execute an SQL script file. Takes a file name as an argument. status (\s) Get status information from the server. system (\!) Execute a system shell command. tee (\T) Set outfile [to_outfile]. Append everything into given outfile. use (\u) Use another database. Takes database name as argument. charset (\C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets. warnings (\W) Show warnings after every statement. nowarning (\w) Don't show warnings after every statement. For server side help, type 'help contents' mysql> mysql>