Bennett:
Regardless of the login username / password, you have to GRANT user rights
to create, alter, etc. in MySQL. By default, the root user has those rights,
but not other users.
Gerald Jensen
----- Original Message -----
From: "Bennett Haselton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 4:50 PM
Subject: local MySQL server authenticating users by machine username
> 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
>
---------------------------------------------------------------------
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
