On Fri, 14 Jun 2002, Sergey wrote:
<snip>
> With root privileges
> I doing:
> GRANT ALL ON mydb.* TO client@localhost identified by "pwd";
> I got:
> OK
>
<snip>
>
> Then I doing:
> LOAD DATA INFILE "/usr/data/myfile" INTO TABLE tab01;
> I got:
> ERROR 1045 Access denied fot user: 'client@localhost' (Using password: YES)
>
> Also I changed manualy for user(client) in database mysql in tables user & db from
>"N" to "Y"
> Doesn't help.
>
> What is wrong I am doing?
> Why whith my client's privileges I can create databases, tables but can't load any
>data
> in to the tables?
>
The user client@localhost also needs the global privilege File_priv in
MySQL.user. Section 4.2.5 "How the Privilege System Works" has the details.
I hope this fixes your problem.
---------------------------------------------------------------------
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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php