However, you are running WIN2K, not unix as i assumed in my previous post.
There still must be some default user which apparently has full privileges.
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
