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 forums:http://forums.mysql.com/read.php?30,506069,506069#msg-506069 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
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 > Here is a fun one! > > I have a set of tables that get populated and changed a lot from lots of > REPLACE statements. Now, I need an ON UPDATE trigger, but of course the > trigger never gets triggered because REPLACES are all deletes and inserts. > > The trigger is going to populate another table as a queue for a system to > do something whenever a particular field changes. > > SO, does anyone have some slick idea how to handle this little dilemma? I > have an idea but I have a feeling there is something better out there. > > Thanks! > > Jim McNeely > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql > > -- Claudio
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? (Could I have inadvertantly made it myself?) Here: mysql> select user, host, password from mysql.user; +---+ +---+ | user | host | password | +---+ +---+ | root | localhost | | | root | mbprebel.local | | | root | 127.0.0.1 || | root | ::1 | | Thanks, Lourens -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
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) signature.asc Description: OpenPGP digital signature
::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 from mysql.user; +---++---+ | user | host | password | +---++---+ | root | localhost | | | root | mbprebel.local | | | root | 127.0.0.1 || | root | ::1| | Thanks, Lourens -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql