OS Linux Red Hat 7.2 MySql 3.23.41 Hi All! That is my steps.
With root privileges I doing: GRANT ALL ON mydb.* TO client@localhost identified by "pwd"; I got: OK With client privileges !!! I doing: mysql -u client -p passwd**** CREATE DATABASE mydb; I got: OK CREATE TABLE mytable ( col01 CHAR(2), col02 CHAR(2)); I got: OK 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? Thank you. Sergey. _____________________________________________________________ Cool Quiz - Websites That Keep You Guessing! http://www.coolquiz.com _____________________________________________________________ Promote your group and strengthen ties to your members with [EMAIL PROTECTED] by Everyone.net http://www.everyone.net/?btn=tag --------------------------------------------------------------------- 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