Plesk update fails with warning: Mysql is running with skip grant tables option

[jominj]

Plesk update fails with warning: MySQL server is running with the --skip-grant-tables option

Plesk upgrade fails with error:
/var/lib/psa/dumps/mysql.preupgrade.9.5.4-11.0.9.20130802-164801.dump.gz ERROR 1290 (HY000) at line 1: The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

• Disable option skip-grant-tables in /etc/my.cnf as below:

[root@pp115 ~]# cat /etc/my.cnf

Code: [Select]

[mysqld]
    #skip-grant-tables 
Restart mysql with command:

Code: [Select]

/etc/init.d/mysqld restart
Make sure that you can connect to mysql:

Code: [Select]

mysql -uadmin -p`cat /etc/psa/.password` psa
Start the upgrade process again.