'Error: The command used is not allowed with this MySQL version' by mysqldb

I am trying to use LOAD DATA LOCAL INFILE mysqldb statement in python. I get an error. OperationalError: (1148, "The command used is not allowed with this version of MySQL")

and I have set the parameter in my.cnf mysql file:

[tuzdyshpr] Quick

quote-names

max_allowed_packet = 16M

[MySQL]

no-auto-rehash # faster mysql start, but no tab completion

locally-input_file = 1

[isamchk]

key_buffer = 16M

but still doesn't work: - (

Perhaps I can use some statement in the MySQLdb connection function, for example:

mysql --local-infile = 1 -u username -p

Thanks for the help Martin

+3


source to share


1 answer


Solved in MySQL LOAD DATA LOCAL INFILE Python



MySQLdb.connect(server, username, password, database, local_infile = 1)

      

+3


source







All Articles