If you want to change the directory that the MySQL server uses to create and store temporary files (usually the default directory is /tmp), you must set the tmpdir option, either by by putting a…