Timeline for Host Name Resolution in mysql.db and mysql.user tables

9 events

when toggle format	what		by	license	comment
Jun 15, 2020 at 9:05	history	edited	CommunityBot		Commonmark migration
Jan 28, 2015 at 12:48	comment	added	Michael - sqlbot		You probably don't want to update the mysql.user table like this, as a matter of practice, since it will invalidate the permissions on any stored programs where the affected user is the `DEFINER`.
Oct 30, 2011 at 0:19	vote	accept	KM.
Oct 26, 2011 at 22:05	history	edited	RolandoMySQLDBA	CC BY-SA 3.0	added 496 characters in body
Oct 26, 2011 at 16:44	comment	added	RolandoMySQLDBA		@KM01 : No. MySQL can only report on the IP/DNS-Name it sees in the processlist. I updated my answer to use a masked domain.
Oct 26, 2011 at 16:43	history	edited	RolandoMySQLDBA	CC BY-SA 3.0	added 568 characters in body
Oct 25, 2011 at 22:40	comment	added	KM.		Ah. Thanks @Rolando. I'm aware of the `update` option. We're using an application to manage the above applications, app1, app2, app3, etc., and would like to avoid using `update` if possible. We enter `db.domain.com` in the manager application, but the MySQL picks up `lb.domain.com`. Looks like we have to revisit the manager application, but is there anything on MySQL side that would cause it to go from `db.domain.com` to `lb.domain.com` ... ?
Oct 25, 2011 at 14:29	history	edited	RolandoMySQLDBA	CC BY-SA 3.0	added 80 characters in body
Oct 25, 2011 at 14:23	history	answered	RolandoMySQLDBA	CC BY-SA 3.0