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

Translate to de es fr it pt ja