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
