Part-1:The MySQL server is running with the secure-file-priv opt so it cannot execute this statement

ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
The error 1290 message you're encountering, "The MySQL server is running with the secure file priv option so it cannot execute this statement," typically occurs when you're trying to use the LOAD DATA INFILE statement in MySQL to load data from a file into a table.
MySQL's --secure-file-priv option is a security feature that restricts the directories from which you can load data using the LOAD DATA INFILE statement. This is done to prevent potential security vulnerabilities by limiting the places from which MySQL can read files.

To resolve this issue, you have a few options:
Change Secure File Privilege Location: You can modify the --secure-file-priv option in your MySQL configuration to point to a directory where you have the necessary files. This directory should be secure and only accessible to authorized users.
Place Files in Allowed Directory: Move the file you're trying to load with LOAD DATA INFILE into the directory specified by the --secure-file-priv option. This will allow MySQL to read the file from that location.
Use a Different Approach: If you're unable to change the configuration or move the files, consider using alternative methods to import data into your MySQL table. For example, you could use MySQL's LOAD DATA LOCAL INFILE if the file is located on the client machine.

Beside that , MySQL server does not have the necessary privileges to perform file-related operations, such as using the LOAD DATA INFILE statement or other file-related operations in MySQL.
Grant the FILE Privilege: You need to grant the FILE privilege to the MySQL user account that you are using to execute the LOAD DATA INFILE statement or other file-related operations. You can do this using the GRANT statement:
Mysql @GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
Mysql @FLUSH PRIVILEGES;
[mysqld]
secure-file-priv="C:/path/to/your/directory"
Replace "C:/path/to/your/directory" with the actual path to the directory from which you want MySQL to be able to read files. Make sure to use forward slashes even on Windows.