The LOAD DATA statement can load a file that is located on the server host, or it can load a file that is located on the client host when the LOCAL keyword is specified.
In a Web server environment where the clients are connecting from a Web server, a user could use LOAD DATA LOCAL to read any files that the Web server process has read access to (assuming that a user could run any command against the SQL server). In this environment, the client with respect to the MySQL server actually is the Web server, not the remote program being run by the user who connects to the Web server. Attacker can take advantage of this SQL injection via PHP/perl etc.
Open my.cnf file:
# vi my.cnf
Append following line [mysqld] section
local-infile=0
Save and restart MySQL server:
# /etc/init.d/mysql restart
🐧 0 comments... add one ↓
FreeBSD Enable Security Port Auditing to Avoid…
Linux display disk total statistics including time…
Linux: Iptables # 21 Allow MS-SQL server incoming request ?
Shell scripting: Reading a root password with…
QD#2: SQL Best Practices,Find the Celebrity in You,…
Ubuntu Linux Critical OpenSSL and Ruby…- How to protect buggy programs from security…
Linux Iptables Avoid IP Spoofing And Bad Addresses Attacks
| Category | List of Unix and Linux commands |
|---|---|
| Disk space analyzers | ncdu • pydf |
| File Management | cat |
| Firewall | Alpine Awall • CentOS 8 • OpenSUSE • RHEL 8 • Ubuntu 16.04 • Ubuntu 18.04 • Ubuntu 20.04 |
| Network Utilities | NetHogs • dig • host • ip • nmap |
| OpenVPN | CentOS 7 • CentOS 8 • Debian 10 • Debian 8/9 • Ubuntu 18.04 • Ubuntu 20.04 |
| Package Manager | apk • apt |
| Processes Management | bg • chroot • cron • disown • fg • jobs • killall • kill • pidof • pstree • pwdx • time |
| Searching | grep • whereis • which |
| User Information | groups • id • lastcomm • last • lid/libuser-lid • logname • members • users • whoami • who • w |
| WireGuard VPN | Alpine • CentOS 8 • Debian 10 • Firewall • Ubuntu 20.04 |
