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

Reply via email to