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]

Reply via email to