'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 to share