You should paste the result of command show grants for 'filasPOS'@'localhost',not the message pasted here.
On Jan 8, 2008 12:04 PM, Mauricio Tellez <[EMAIL PROTECTED]> wrote: > Hi, I'm developing a PHP/MySQL app, and I use "load data infile" to feed > data to MySQL. At the develop server I haven't any error, the app works > great, but when I upload to the production server, all the "load data > infile" statements fails with an error like this: can't stat > path/to/my_cvs_file > The funny thing is that if I connect at production server to mysql as > mysql's super user I have not problem, the app work fine, but if I use > another user, then the app fails with the "can't stat" error. I know my > user > needs the File privilege so I told the mysql's admin that. First he used > phpmyadmin to create my user and set privileges, but when I told you about > the error, he use the mysql console with the command: grant all privileges > on mydatabase.* to [EMAIL PROTECTED] identified by 'mypasswd' with grant > option; > But I got the same error. This is what I get if I query my mysql's user: > *************************** 1. row *************************** > Host: localhost > User: filasPOS > Password: 7b47ae4b0907b267 > Select_priv: N > Insert_priv: N > Update_priv: N > Delete_priv: N > Create_priv: N > Drop_priv: N > Reload_priv: N > Shutdown_priv: N > Process_priv: N > File_priv: N > Grant_priv: N > References_priv: N > Index_priv: N > Alter_priv: N > Show_db_priv: N > Super_priv: N > Create_tmp_table_priv: N > Lock_tables_priv: N > Execute_priv: N > Repl_slave_priv: N > Repl_client_priv: N > Create_view_priv: N > Show_view_priv: N > Create_routine_priv: N > Alter_routine_priv: N > Create_user_priv: N > ssl_type: > ssl_cipher: > x509_issuer: > x509_subject: > max_questions: 0 > max_updates: 0 > max_connections: 0 > max_user_connections: 0 > *************************** 2. row *************************** > Host: % > User: filasPOS > Password: 7b47ae4b0907b267 > Select_priv: Y > Insert_priv: Y > Update_priv: Y > Delete_priv: Y > Create_priv: Y > Drop_priv: Y > Reload_priv: N > Shutdown_priv: N > Process_priv: N > File_priv: Y > Grant_priv: N > References_priv: N > Index_priv: N > Alter_priv: N > Show_db_priv: N > Super_priv: N > Create_tmp_table_priv: Y > Lock_tables_priv: N > Execute_priv: Y > Repl_slave_priv: N > Repl_client_priv: N > Create_view_priv: N > Show_view_priv: N > Create_routine_priv: Y > Alter_routine_priv: Y > Create_user_priv: N > ssl_type: > ssl_cipher: > x509_issuer: > x509_subject: > max_questions: 0 > max_updates: 0 > max_connections: 0 > > any clue? thanks in advance. > > > -- > Mauricio Tellez > -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
