You probably want to GRANT ALL ON oneDatabase.* TO login@%. I can't
image a situation where letting everyone see everything (including
the mysql database with all the permissions) would ever be a good
idea.
Walter
At 7:44 PM +0200 7/25/01, Stefan Hinz wrote:
>Dear KJ,
>
>> How can
>> I set up users so that they do not need to supply a password to use
>> mysql?
>
>Use MySQL Monitor (the command line tool, mysql) and type:
>
> GRANT ALL ON *.* TO ""@%
>
>This will grant all rights on all databases and tables to anyone ("")
>from anywhere (%) without password.
>
>Regards,
>
>--
> Stefan Hinz
> Geschäftsführer / CEO iConnect e-commerce solutions GmbH
> # www.js-webShop.com www.iConnect.de
> # Gustav-Meyer-Allee 25, 13355 Berlin
> # Tel: +49-30-46307-382 Fax: +49-30-46307-388
>
>----- Original Message -----
>From: <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Wednesday, July 25, 2001 5:59 PM
>Subject: Setting up "no password" users?
>
>
>>
>>
>>
>> I recently did my first mySQL installation (the OS is Linux). How can
>> I set up users so that they do not need to supply a password to use
>> mysql?
>>
>> I want to be able to issue commands like
>>
>> mysql -e "select host,db,user from db" mysql
>>
>> instead of having to do something like
>>
>> mysql -e "select host,db,user from db" -u johndoe -pmypwd mysql
>>
>> Thanks!
>>
>> KJ
>>
>> ---------------------------------------------------------------------
>> 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
---------------------------------------------------------------------
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