• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

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