Skip to content

Instantly share code, notes, and snippets.

@allvee

allvee/secure-file-priv server option (File Load in DB)

Created February 5, 2019 09:57
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save allvee/9000cb0c08f19a07c34e92767fcb8855 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save allvee/9000cb0c08f19a07c34e92767fcb8855 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
secure-file-priv server option (File Load in DB)
1. Edit the (/etc/my.cnf file for CentOS) or (my.ini file for Windows)
2. Add secure-file-priv = "" line at the end
3. Stop mysql service using systemctl stop mysqld
4. Restart it using systemctl start mysqld
It will now allow you to import and export the data.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment