导出

mysql> show global variables like 'local_infile';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile  | OFF   |
+---------------+-------+
1 row in set, 1 warning (0.04 sec)
mysql> set global local_infile = true;
Query OK, 0 rows affected (0.00 sec)
mysql> show variables like '%secure%';
+--------------------------+-----------------------------+
| Variable_name            | Value                       |
+--------------------------+-----------------------------+
| require_secure_transport | OFF                         |
| secure_file_priv         | C:\WINDOWS\system32\''D:\"\ |
+--------------------------+-----------------------------+
2 rows in set, 1 warning (0.00 sec)
mysql>