At 20:23 -0400 6/14/02, Sergey wrote:
>OS Linux Red Hat 7.2
>That is my steps.
>With root privileges
>GRANT ALL ON mydb.* TO client@localhost identified by "pwd";
>With client privileges !!!
>mysql -u client -p
>CREATE DATABASE mydb;
>CREATE TABLE mytable ( col01 CHAR(2), col02 CHAR(2));
>Then I doing:
>LOAD DATA INFILE "/usr/data/myfile" INTO TABLE tab01;
>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"
>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?
You're asking the server to load a file on the server host, which requires
the FILE privilege. This is a global privilege, not a database-specific
If the file is on your client machine, use LOAD DATA LOCAL INFILE instead.