mysqladmin access denied error

[Imran Khan]

Hi,
I'm using solaris 8 with mysql v 3.23.54.

I want to enable a solaris user - 'user1', to use the mysqlimport command without using a password.

I've run, as root, the following sql command:
mysql>grant all on db1.* to user1@localhost

-this appears to work fine.

However as user1 in the solaris shell, when I run:
$:/usr/local/mysql/bin/mysqlimport db1 table1.txt

I get :
/usr/local/mysql/bin/mysqlimport: Error: Access denied for user: 'user1@localhost' (Using password: NO), when using table: table1

So how can I allow a user to run mysqlimport to my db1 database, and without a password?

thanks.




_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail&xAPID=42&PS=47575&PI=7324&DI=7474&SU= http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_addphotos_3mf


---------------------------------------------------------------------
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