Score:0

How to circumvent secure_file_priv in mysql?

fr flag

I have been given the job of setting up a mysql database (it is not on a local server but a remote one that I ssh into). I have created the database schema and tables and was trying to load the data in, when I encountered the obstacle of secure_file_priv. I checked the value of secure file priv and it was the traditional var/lib/mysq. However I have neither permission(access rights) to change the value of secure file priv to "" or to put files in the given folders. Nobody knows who set up the database, how to manage it or change rights and I have been given the task of figuring something out under these conditions. Is there any way to circumvent this secure file priv problem to load data into tables or some alternative way to do it?

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.