Shost: Pedward: yea, I was having problems with it too

Eerkes: I followed one of this guides, and they seem to teach to change it

Shults: Jmss: that ubuntu doc is really naive

Amerman: Pedward: can I query from remote hosts with the default bind-address?

Farwell: It ***umes mysql works like bind

Smietana: Jmss: yes, by default it binds to everything

Bolognese: On RHEL or fedora, BIND and Sendmail default to localhost only

Rettke: MySQL has no such dumb notions ;

Lapointe: But then again, it’s not an open email relay :

Humphery: And you should firewall your servers from the greater internet

Kemplin: But with 192.168.1.13, I’m only .1% worried

Addesso: The .1% is whether you are using NAT to convert 192.168.1.13 to a world routable IP

Peasley: Pedward: yes, there is a router

Deason: And whether the firewall doing nat allows inbound 3306

Ekker: But do you have a persistent NAT rule or are you using the default masquerading?

Frankie: Pedward: yes, I am forwarding port from the router to .13, is this bad?

Bertschy: Masquerading has a very low risk

Soltani: Well, port redirect makes your MySQL server directly accessible from the interwebs

Gorri: Do I clear the destination mysql data dir priot to copying over the new?

Newell: Which is generally considered a “bad thing”

Payden: Scott0_: if there is *anything* in the datadir, yes

Jorgensen: Scott0_: a default RPM install will not have anything in the datadir

Schreffler: Well, that might invoke mysql_install_db

Tramble: Oracle official RPMs do that

Forrister: So im good to stop mysql, empty that dir, then copy old stuff over?

Harwood: Pedward: you mean I should access MySQL through SSH or something like that?

Deason: Scott0_: also copy /etc/mysql/debian.cnf

Farnum: Im gonna leave the debian flag file, not sure what that’s for

Lule: Jmss: at the least, you should restrict external access. I presume you aren’t intending for everyone in the world to connect?

Twitty: Just from a specific set of hosts?

Vandee: The new location should have one of those already

Deason: Scott0_: yeah. also /root/.my.cnf if it exists

Deason: Scott0_: you want the old /etc/mysql/debian.cnf

Reckard: Deason: I’ve never changed either of those

Freuden: Pedward: just with the correct user/p***

Sindorf: Deason: can you explain why?

Deason: Scott0_: it contains a user that debian uses to manage mysql

Oeder: Jmss: are you going to connect only from a specific server elsewhere, or will it always be some random IP?

Deason: Scott0_: your alternative is to update the p***word to match the new /etc/mysql/debian.cnf

Marples: Deason: Debian sends mysql daemon errors to syslog by default, links tcpwrappers, sets bind-address, and runs a /etc/mysql/debian-start. One or more of these non-standard options may cause you problems or confusion. Also an ancient Norwegian word for “can’t configure Gentoo”.

Roehrenbeck: How about the root my.cnf?

Lisby: Jmss: in that case, yes, I would recommend SSH tunneling

Addo: I found out some time ago that im norwegian

Deason: Scott0_: /root/.my.cnf contains your credentials, if it exists. your backup software might need it

Curington: I do everything via remote commands

Schlappi: Jmss: what application are you using to connect?

Buchs: What is maximum number of items in IN list that allows proper index dives?

Cosimini: That reminded me that I also have to get my rsa keys moved over