Hi,
I am trying to connect to a MySql database and I keep getting the following:
Cannot find (ping) database host Joseph-Kosinskis-MacBook on the network
Failed to connect to Unix socket '/var/run/lirc/lircd'
No such file or directory (2)
The database is located on a
Kosinski joj...@gmail.com
Hi Joe,
On 4/5/2013 1:58 PM, Joe Kosinski wrote:
The commands didn't work and the time zone tables are not loaded.
Whenever I ran the queries mysql SELECT * FROM time_zone;
mysql SELECT * FROM time_zone_name;
I got an error message stating no database was selected. I
I also triedmysql_tzinfo_to_sql /usr/share/zoneinfo sqlLines with the following Terminal output:
Terminal Saved Output 10
Description: Binary data
-bash: sqlLines: Permission deniedJoeBegin forwarded message:From: Joe Kosinski joj...@gmail.comSubject: Fwd: mysql_tzinfo_to_sqlDate
I was finally able to load the time zone tables using the following:
sh-3.2#
/usr/local/mysql-advanced-5.6.10-osx10.7-x86/bin/mysql_tzinfo_to_sql
/usr/share/zoneinfo | /usr/local/mysql-advanced-5.6.10-osx10.7-x86/bin/mysql -u
root mysql
My version of Mac OSX 10.8.3 did not have root
I tried the use mysql; for my session. Here is the result:
Terminal Saved Output 7
Description: Binary data
JoeBegin forwarded message:From: shawn green shawn.l.gr...@oracle.comSubject: Re: Fwd: mysql_tzinfo_to_sqlDate: April 5, 2013 1:58:01 PM EDTTo: Joe Kosinski joj...@gmail.comHi Joe,On 4/5
I cannot find the path where mysql_tzinfo_to_sql is installed.
I have these instructions:
This program is installed to the same .../bin folder as your mysqld
binary. Use a which command to clarify where that is on your system.
which mysql_tzinfo_to_sql
Then use the path it
nothing worked.
Terminal Saved Output 6
Description: Binary data
JoeBegin forwarded message:From: shawn green shawn.l.gr...@oracle.comSubject: Re: mysql_tzinfo_to_sqlDate: April 5, 2013 1:29:50 PM EDTTo: Joe Kosinski joj...@gmail.comHi Joe,On 4/5/2013 1:26 PM, Joe Kosinski wrote:I cannot find the path
message:From: "Wm Mussatto" mussa...@csz.comSubject: Re: Fwd: mysql_tzinfo_to_sqlDate: April 5, 2013 5:09:15 PM EDTTo: mysql@lists.mysql.comOn Fri, April 5, 2013 13:19, Joe Kosinski wrote:I also tried mysql_tzinfo_to_sql /usr/share/zoneinfo sqlLines with thefollowing Terminal output: