<html><head><base href="x-msg://2/"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">First thing I do is change the MySQL default password on a new BO/BQ install but I noticed that I could log on to PHPMyAdmin with any user name and no password which is less than ideal :( ...<div><br></div><div>I wondered whether I should have hardened my default install.</div><div><br></div><div>Colin</div><div><br></div><div><br><div><div>On 2 Oct 2009, at 17:17, Gerald Waugh wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div bgcolor="#ffffff"><blockquote style="border-left-color: rgb(0, 0, 0); border-left-width: 2px; border-left-style: solid; padding-left: 5px; padding-right: 0px; margin-left: 5px; margin-right: 0px; "><div><font size="2" face="Tahoma, sans-serif">Apologies if this is a real newb question but MySQL in BO and BQ seems to be installed with some default users without passwords:</font></div><font size="2" face="Tahoma, sans-serif"><div><font face="Arial"></font> </div><div> User Host Password Global privileges </div><div> Any % -- USAGE No </div><div> Any localhost No USAGE No </div><div> Any localhost.localdomain No USAGE No </div><div><font face="Arial"></font> </div><div>This seems a bit alarming. Can I safely remove these?</div><div><font face="Arial"></font> </div><div><div><font size="2" face="Arial"><strong>mysql> select User,Host from mysql.user;<br>+------+-----------------------+<br>| User | Host |<br>+------+-----------------------+<br>| root | 127.0.0.1 |<br>| root | localhost |<br>| root | localhost.localdomain |<br>+------+-----------------------+<br>3 rows in set (0.00 sec)<br></strong></font></div><div><font size="2" face="Arial"><strong>the user is root, and that is because on a default install there is no password set.</strong></font></div><div><font size="2" face="Arial"><strong></strong></font> </div><div><font size="2" face="Arial">Gerald</font></div><font size="2" face="Arial"></font></div></font></blockquote>_______________________________________________<br>Blueonyx mailing list<br><a href="mailto:Blueonyx@blueonyx.it">Blueonyx@blueonyx.it</a><br><a href="http://www.blueonyx.it/mailman/listinfo/blueonyx">http://www.blueonyx.it/mailman/listinfo/blueonyx</a><br></div></span></blockquote></div><br></div></body></html>