beginner <[EMAIL PROTECTED]> wrote:
> Hi,
> i got mysql 4.0.13 on my machine. When i installed it,
> i did only basic stuff to get it running (bascilly hit
> setup).
> Now, i'm getting a little bit closer to mysql (the
> system starts to became more friendly), but i got the
> following problem:
> - if i log as shell>mysql
> this user seems to have access to modify all databases
> (i would want it to happen only when i log as shell>
> mysql -h localhost -u root -p )
On Windows user ''@'localhost' has all privileges.
> How can i configure mysql NOT to accept logins with
> only shell> mysql , i mean without beeing a specified user?
Remove entries for anonymous user:
DELETE FROM user WHERE user='';
FLUSH PRIVILEGES;
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
