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?
I'm just trying out the MySQL server on my machine, and when I'm logged to
the machine as "bhaselto" and I invoke mysql (with no username or password
on the command line), I get the mysql prompt, however I am not able to
create new databases. However, if I quit mysql, then "su" to become root,
and then invoke mysql again with no username/password arguments, when I get
the mysql prompt I am able to create new databases.
(If this is right, then should I send an update suggestion to the author of
the http://www.mysql.com/doc/C/o/Connecting-disconnecting.html page? Is he
or she on the list?)
-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
