Skip to content

"ERROR 1148 (42000) at line 1: The used command is not allowed with this MySQL version" after upgrade percona version 5.5.35-33.0 to 5.5.36-34.2

So the setup is the following, debian squeeze and percona version 5.5.35-33.0.
I had done an upgrade from 5.5.35-33.0 to 5.5.36-34.2-648.squeeze and the following error created an red monitor on my jenkins.

ERROR 1148 (42000) at line 1: The used command is not allowed with this MySQL version

After searching on the web, i found this entry on the web.
sudo vim /etc/mysql/my.cnf
# add follwing entry to fitting locations
[mysql]
local-infile=1
[mysqld]
local-infile=1 # /etc/init.d/mysql restart

Get your current used version?
# mysql --user=root --password=
SHOW VARIABLES LIKE "%version%";

Check if changes are working?
# mysql --user=root --password=
SHOW VARIABLES LIKE '%local%';