"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%';