artodeto's blog about coding, politics and the world

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

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

# mysql --user=root --password=
SHOW VARIABLES LIKE "%version%";

# mysql --user=root --password=
SHOW VARIABLES LIKE '%local%';