• Please be aware: Kaspersky Anti-Virus has been deprecated
    With the upgrade to Plesk Obsidian 18.0.64, "Kaspersky Anti-Virus for Servers" will be automatically removed from the servers it is installed on. We recommend that you migrate to Sophos Anti-Virus for Servers.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.

MySQL problem with my.cnf and "LOAD DATA LOCAL INFILE"

CriTrip

New Pleskian
Goodmorning,

I'm using on virtual machine the last version of PLESK 11.5.3 update #42 and UBUNTU 12.04.4 LTS provide by a main Italian ISP, the MySQL version is 5.5.35-0ubuntu0.12.04.2.
I'm trying to enable the local-infile option in the /etc/mysql/my.cnf file:

[client]
local-infile = 1

[mysqld]
local-infile = 1

When I'm restarting mysql service (with command "service mysql restart") the PHP script works correctly and "SHOW GLOBAL VARIABLES" results "ON", but when server reboot or some hours by the restart the PHP script return to not work correctly and appear the standard messagge:

"The used command is not allowed with this MySQL version"

Maybe the problem is the start of mysql on boot? I haven't any errors in the mysql or system log!!

Do you have any hints to solve this? Thanks in advance!
 
[UPDATE]

I had individuated a possible issue, every few second or minutes one service calls "/usr/bin/mysql_upgrade" that process ignores the settings defined in "/etc/mysql/my.cnf" and reset on the fly mysql to default value.

I think that a PSA procedure that create, update or delete the mysql databases.

I appreciated every possible solution, thank you.

Regards
 
Back
Top