At 06:04 PM 8/8/2001 -0500, Paul DuBois wrote:
>At 2:50 PM -0700 8/8/01, Bennett Haselton wrote:
>>The first page of the MySQL tutorial at:
>>http://www.mysql.com/doc/C/o/Connecting-disconnecting.html
>>
>>says that when you connect to the MySQL server, it authenticates you
>>based on a username and password that you enter, unless the server is
>>also configured to allow "anonymous" access, in which case you can log in
>>with no username.
>>
>>Isn't it also true that if you connect to the MySQL server on your local
>>machine, the server authenticates you based on the username that you're
>>already logged in under?
>
>Not quite. The server has no idea who you're logged in as.
>The mysql client program uses your login name as the default MySQL user
>name
>if you don't specify any user name explicitly.
Oh OK. The behavior makes sense now.
However, the page at
http://www.mysql.com/doc/C/o/Connecting-disconnecting.html
says:
>>>
Some MySQL installations allow users to connect as the anonymous (unnamed)
user to the server running on the local host. If this is the case on your
machine, you
should be able to connect to that server by invoking mysql without any
options:
shell> mysql
>>>
which sounds like it's incorrect -- if you invoke mysql without specifying
a username, it actually uses your login name as the username. I added a
comment on that page.
-Bennett
[EMAIL PROTECTED] http://www.peacefire.org
(425) 649 9024
---------------------------------------------------------------------
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
