Folks;

1.with mysqlman 1.09, I am able to do all things except import (LOAD DATA INFILE) operations. I get an "permission denied" error. My isp has assured me I do have file operation privledges on the mysql server. I have noticed the comment that import won't work in "demo mode" but have been unable to find where to toggle "demo mode" or to confirm that I am not in "demo mode".

2.Also I can ONLY use direct login to connect to the database.

please help.

Many Thanks!

Hi,

I think your ISP is lying to you. To test, goto SQL Monitor and type:

SELECT * FROM table INTO OUTFILE '/tmp/test.txt'

where table is a table in your database, and /tmp/test.txt is a file that does not exist and is in a world writeable directory. What do you get as the results?

As for direct login, this is sometimes required due to permission setup in mysql.

Cheers,

Alex
--
Gossamer Threads Inc.

Alex;

Yes, I get the same error message;

Permission to perform action denied!

MySQL Said: Access denied for user: 'username' (Using password: YES).

Query: SELECT * FROM table_name INTO OUTFILE '/temp/test.txt'.

Does this confirm that I have not been granted file operation permissions in mySQL?

thanks for the help.

Yes, you don't have FILE permissions. =)

Cheers,

Alex
--
Gossamer Threads Inc.

See my posting under "Which Command is Not Allowed" for a work around to this permissions issue. This is not a MySQLMan problem but one created by all of the security checks now inherent within MySQL to keep people from trashing data.

Hope that helps...

Andrew C Lietzow - The ACL Group, Inc.