Richard Whitney <mailto:[EMAIL PROTECTED]> wrote on Tuesday, January 04, 2005 6:16 PM:
> I think I'm bringing this up again but with different errors. > > This: $sql = "LOAD DATA INFILE '$file' > REPLACE INTO TABLE `jobs` FIELDS > TERMINATED BY '\\t' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '\\\\' > LINES TERMINATED BY '\\r\\n'"; > > is getting the error "Access denied for user: '[EMAIL PROTECTED]' (Using > password: YES" > > I have no idea where the % sign is coming from. shouldn't it say > [EMAIL PROTECTED] like it's setup in the db connection script? MySQL treats connections to "localhost" differently to connections to the real hostname or IP address - the problem is likely in the mysql_connect or pconnect lines (if you're using php mysql module). Try adding a new user to the grant tables with duplicate permissions, but with host set to "%" (or localhost if the existing user has host set to % already). cheers, Tom -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
