Gerald... He isn't on a Unix box, he is on a Win2k box
-----Original Message----- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 8:46 AM To: Bryan Capitano Cc: [EMAIL PROTECTED] Subject: Re: setting root psswd on Win2K ?? You can't login as plain old nobody. The default mysql user is your unix user, so if you are logged into unix as root , and entered "mysql" you were logged into mysql as root. You appear to have been logged in as "mysql". If the user "mysql" has full privileges, then there was nothing to prevent the deletion. Bryan Capitano wrote: >Having some problems setting root password on MySQL. Can anybody help >me? > >I've just installed MySQL 3.23.38 on a Windows 2000 server. >I'm following the directions in the documenation for setting the root >password: > >>mysql -u root mysql >> >mysql>UPDATE user >mysql>SET password=password('mynewpass') >mysql>WHERE user='root'; >mysql>FLUSH PRIVILEGES; > >okay, all seemed fine. now if I log out and log back as pain old nobody: > >>mysql >> >mysql>use mysql; >mysql>drop table user; >okay 1 table affected................. > >How come just anybody can log into my MySQL server and start dropping >tables >in the mysql database?? This shouldn't be right. What have I done wrong? > >Either I have a serious mis-understanding or something is seriously not >right here. > >Thanks for any help! > > > > > > >--------------------------------------------------------------------- >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
