List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:December 20 2002 2:52pm
Subject:Re: mysqlimport access denied errors
View as plain text  
At 13:04 +0000 12/20/02, Imran Khan wrote:
>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.

Try this instead:

grant all on db1.* to user1@localhost

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

Thread
mysqlimport access denied errorsImran Khan20 Dec
  • Re: mysqlimport access denied errorsPaul DuBois20 Dec