I couldn't upload my data into MySQL using Command line

Question

When I use LOCAL it's showing " LOAD DATA LOCAL INFILE file request rejected due to restrictions on access " & when I try to remove the LOCAL it show's " The MySQL server is running with the --secure-file-priv option so it cannot execute this statement " I don't know how to deal with this error I tried many different methods but couldn't figure this out ! It'd Really appreciable if someone could help me with this error !

Answer 1

The reason is you need administrator right to execute what you are up to. You have first to connect to your DB using the username and password you registered your DB with.