Reznichenko,
Wed, 13 Feb 2002 15:02:01 PM, you wrote:
> TI> After the default mysql-3.23-47 installation,
> TI> there are two entries in the mysql.user table
> TI> where the User and Password fields are empty.
> TI> I'd like to know what is the purpose of these
> TI> records?
> TI> The first has a 'localhost' entry in the Host field
> TI> and the second one has the 'hostname'.
> TI> Can I delete them, or will this crash the database?
>
> These are default records in mysql.user and all priv_types are
> set to 'N'. These rows are corresponding to default user in mysql.
OK.
But who is that 'default user'?
As I know just the root and an anonymous user's created as
the initial MySQL accounts.
At least I've found it in the doc;
"An anonymous user is created that can do anything with databases that have
a name of 'test' or starting with 'test_'. Connections must be made from the
local host. This means any local user can connect without a password and be
treated as the anonymous user."
So it would be that default user what you wrote about?
Is it like scott/tiger in ORACLE?
We don't have any real database, named 'test' or 'test_*', just
what the MySQL installation set.
Can I delete that default user and 'test' database from our public DB,
just after the installation?
Whatsoever, what is the purpose of that default database named 'test'?
I think anyone can create a database if she/he wants to try mysql.
"This means any local user can connect without a password and be treated as
the anonymous user."
I'm afraid we don't need this feature.
Thanks in advance!
Regards;
Istvan
---------------------------------------------------------------------
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
