mysqlimport access denied errors

[Imran Khan]

Hi,
I'm working on SOlaris 8 with MySQL v3.23.54.

I'm trying to give a user 'user1' access to one of my databases 'db1', and specifically one table 'table1'.

As root I've run:
msql> grant all on db1 to user1@localhost

-and it appears to work fine.

However when as the solaris user 'user1', I run the following from the shell prompt:
$:/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

------

I want this user 'user1' to be able to run the mysqlimport command without prompting for a password.

Can you help?

thanks.






_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963


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