::1 root entry in mysql.user

Hi, I installed mysql for mac os x. Now I am inspecting mysql.user and I see entries for root which I am not to confident with. On a debian installation there is no host=::1 entry Can you explain this entry? (Could I have inadvertantly made it myself?) Here: mysql select user, host, password

Re: ::1 root entry in mysql.user

Am 18.12.2011 18:17, schrieb lourenstcc: Hi, I installed mysql for mac os x. Now I am inspecting mysql.user and I see entries for root which I am not to confident with. On a debian installation there is no host=::1 entry man network-basics ::1 = IPv6 for localhost (127.0.0.1)

Re: ::1 root entry in mysql.user

::1 is the IPv6 address for localhost. On 18 Dec 2011, at 09:17, lourenstcc wrote: Hi, I installed mysql for mac os x. Now I am inspecting mysql.user and I see entries for root which I am not to confident with. On a debian installation there is no host=::1 entry Can you explain this entry?

Re: UPDATE triggers with REPLACE statements

Only if you can change the application you could use INSERTON DUPLICATE KEY UPDATE instead of REPLACE. Check Peter's post here: http://kae.li/iiigi Cheers Claudio 2011/12/17 Jim McNeely j...@newcenturydata.com Here is a fun one! I have a set of tables that get populated and changed a

mysql_secure_installation

Hi, Does anyone know why what's done in 'mysql_secure_installation' [0] isnot part of the default mysql installation? [0] http://dev.mysql.com/doc/refman/5.0/en/mysql-secure-installation.html Thank you,Ryan Dewhurst P.S. I also asked this question on the