Copier: I’ve learned over the years that tuning it prevents the peaks/valleys.but I’ve never understood why some variables peak/valley and others stabilize.

Zaibel: Mac_ified: got the server at home I’m using my internal IP to get connected

Yegge: Bind-address = 127.0.0.1

Castles: Maybe this is the line in /etc/mysql/my.cnf

Brittman: Gcosmin: does java run on some other server than mysqld?

Kutzer: I’m using Eclipse to code on my laptop, the server has another internal IP

Genovesi: Brittman: would it be more secure to add only my laptop IP ?

Brittman: Gcosmin: while your question is ambiguous, the answer is probably “yes, but an ssh tunnel is even more secure”

Baranovic: Brittman: really apreciate your help, I’m trying to learn Java but it gets complicated when tutorials don’t really work as it should

Imbrock: I find my self asking stupid questions and wasteing people time just to make sure I’m doing the right thing and to see if there are any other options

Deanes: Apart of that english is not my first language and everythig gets a bit frustrating sometimes

Brittman: Gcosmin: you are learning a lot more than java, then

Dyson: Brittman: at least I am hoping to :

Littau: One more question if I may . if I am changing that IP with 192.168.0.* do you reckon ? Would that solve my issue for my internal connections ?

Lapping: Sorry I had to reboot my server

Bergara: Didn’t seen your last message

Rom: Do you mind to copy/paste it pls ?

Brittman: But better to not do any of this, instead using an ssh tunnel

Whitlatch: Brittman: I understand that there are security issues, once my program will run on the server then I’ll go back to usual setings. Anyway, even so . still the same issue :

Brittman: Gcosmin: on the server: netstat -plant grep mysqld

Brittman: If it says 127.0.0.1, your problem continues to be bind-address

Danfield: The woildcard for host is %, not *

Brittman: Danfield: even so, that would not manifest in connection refused

Brittman: Perhaps i trust “still the same issue” too much

Danfield: Tcp listening ‘see if mysql server listening for tcp connections ‘netstat -lt grep mysql’

Brittman: Danfield: boo dns lookups

Brittman: Danfield: which is why i use the easy to remember -plant

Maresco: Brittman: I’ve commented the bind-address and now I get an error as Danfield is correct . should be % not *

Danfield: Brittman: we need to write up a better remote connection troubleshooting HOWTO.

Danfield: Brittman: a bit more procedural, starting from the network to the firewall to the mysql interface listening to grants

Brittman: Check netstat, nc locally, nc remotely refused vs “not allowed”

Brittman: First good, might be firewall. last one tells you for sure if firewall or grant

Brittman: Nat is the monkey wrench i guess

Vanderlee: I’ve managed : I’m really happy

Mcbratney: I’m going to seep. Good night !

Delancey: Weekday wich value return? weekday22/08/2015 = 5 dayofweek22/08/2015 = 7 dont understand

Atchison: Jak2000: iso8601 there is only one date format :-

Danfield: Jak2000: the index starts at 0 for one function, 1 for the other

Danfield: Select weekday’2015-08-22′, dayofweek’2015-08-22′; — also returns 5 and 7 :-

Danfield: I don’t see how that’s related to system time

Danfield: Oy. select dayname’2015-08-22′, dayname’2015-08-22′, weekday’2015-08-22′, dayofweek’2015-08-22′

Danfield: Oy. select dayname’2015-08-22′, dayname’2015-08-22′, weekday’2015-08-22′, dayofweek’2015-08-22’G

Danfield: Jak2000: dayofweek starts at index 1 for Sunday, weekday starts at index 0 for Monday