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
