local-infile=0 in your /etc/my.cnf

Enter Your Query:
Use '%' for wildcards and quotes for "exact phrases"

Top Level » MySQL / MariaDB

local-infile=0 in your /etc/my.cnfLast Modified: May 21, 2008, 3:09 pm
For security reasons, it's often a good idea to have:


present in your /etc/my.cnf file.

If you want to set all users except da_admin and root to not have that privilege at the mysql level, then login to mysql with the login/pass from /usr/local/directadmin/conf/mysql.conf, and run the query:

use mysql;
UPDATE mysql.user SET File_priv='N' WHERE user!='da_admin' AND user!='root';

**NOTE** that that above command will remove file access from *all* accounts on your system, except da_admin and root.. so just be aware that it's a global change.

© 2018 JBMC Software, Suite 173  3-11 Bellerose Drive, St Albert, AB  T8N 1P7  Canada.  Mon-Fri 9AM-5PM MST