I'm running a local MySQL 8 on my iMac and can access it via command line but not from within meteobridge. Anyone had this issue and found how to get it to work?
Search found 3 matches
- Wed Jun 22, 2022 3:04 am
- Forum: Meteobridge Discussion
- Topic: MySQL Can't connect to local MySQL server through socket '/tmp' **solved**
- Replies: 1
- Views: 729
- Sat Nov 16, 2013 6:30 pm
- Forum: Meteobridge Discussion
- Topic: Help with MySQL
- Replies: 1
- Views: 1908
Re: Help with MySQL
Never mind, I found a solution for inserting datetime (use now(), ...duh). For others setting up a MySQL push with MeteoBridge here's the working query I've created:
insert into data (datetime, temp, hum,dew,heat_index, in_temp,in_hum,in_dew,press,sea_press,wind,avgwind,winddir,windchill,rainrate ...
insert into data (datetime, temp, hum,dew,heat_index, in_temp,in_hum,in_dew,press,sea_press,wind,avgwind,winddir,windchill,rainrate ...
- Sat Nov 16, 2013 5:32 pm
- Forum: Meteobridge Discussion
- Topic: Help with MySQL
- Replies: 1
- Views: 1908
Help with MySQL
I am new to this system and am trying to set up MySQL. Doe anyone have an example MySQL query that illustrates how to store a timestamp as well as the data? I am trying
"insert into data (datetime,temp) values ([YYYY]-[MM]-[DD] [hh]:[mm]:[ss],[th0temp-act.1:-9999])"
but this doesn't work and ...
"insert into data (datetime,temp) values ([YYYY]-[MM]-[DD] [hh]:[mm]:[ss],[th0temp-act.1:-9999])"
but this doesn't work and ...