That seems like it should work as well. Just want to make sure that root doesn't have any privileges over and beyond what a regular added user with all privileges would have. I wouldn't think so, but sometimes this is something that's not specifically documented. Thanks!
Jeff > -----Original Message----- > From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 22, 2002 5:58 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: change default root user name? > > > Hi, > You should be able to do it with a tweak.. You can create a user and give > all the priviliges to that user in the user table of mysql database, and > then takeaway the privileges from the user root. Would that work for you? > > Gurhan > > -----Original Message----- > From: Jeff Field [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 22, 2002 5:27 PM > To: [EMAIL PROTECTED] > Subject: change default root user name? > > > I've had a question that I haven't really seen addressed anywhere... > > Is it okay to change the default "root" user name to a different > name? Any > issues involved by doing so? > > The reason I ask is that it seems to me that, because everyone knows that > MySQL installs with the root user, one simple extra security measure would > be to change the name; then someone pounding your server trying > all possible > password combos with root won't stand a chance. Am I missing anything? > > Jeff > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php