It depends on the variable. Can you give an example of the variable you are trying to set? As far as the load data infile, I believe it depends on how your database will be accessed. If you have a need for remote administration or are working with geographically separated databases then the ability to load data from a different may be useful. While if you are only working from the local machine and you want to further lock down the system then disabling this may be a good decision.
-----Original Message----- From: Ginger Cheng To: [EMAIL PROTECTED] Sent: 4/12/04 12:49 PM Subject: security reason for not using load data infile local? Hello, MySQL gurus, Sometimes the 'local' option of 'load data infile' is disabled for security reasons (that is what I got from web). What could be the security problem? I have another question, is there any way to change a variable of mysql server without shutting it down? Thank you for help ginger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]