• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

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