Article ID: 6416, created on Jun 11, 2009, last review on Aug 4, 2014

  • Applies to:
  • Plesk 8.6 for Linux/Unix


Upgrade version 8.6 failed. The following error is shown in upgrade log:

ERROR while trying to execute SQL query, the query was: DELETE FROM mysql.user WHERE user = ''; FLUSH PRIVILEGES;


STOP psa-8.6.0-cos4.build86080722.02 upgrading AT Thu Jun 11 00:57:52 CDT 2009

What does the error mean and how to resolve the problem?


Execution of query "FLUSH PRIVILEGES" is not possible because table 'mysql.procs_priv' is missing in database 'mysql'.
To verify login to mysql and try the command:

mysql> flush privileges;
ERROR 1146 (42S02): Table 'mysql.procs_priv' doesn't exist



In MySQL 5.0 you may create the table with the following query:

mysql> CREATE TABLE `procs_priv` (
  `Host` char(60) collate utf8_bin NOT NULL default '',
  `Db` char(64) collate utf8_bin NOT NULL default '',
  `User` char(16) collate utf8_bin NOT NULL default '',
  `Routine_name` char(64) collate utf8_bin NOT NULL default '',
  `Routine_type` enum('FUNCTION','PROCEDURE') collate utf8_bin NOT NULL,
  `Grantor` char(77) collate utf8_bin NOT NULL default '',
  `Proc_priv` set('Execute','Alter Routine','Grant') character set utf8 NOT NULL default '',
  `Timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`Host`,`Db`,`User`,`Routine_name`,`Routine_type`),
  KEY `Grantor` (`Grantor`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Procedure privileges'

After the table was created you may continue upgrading.

It is recommended to download Plesk distributive from Parallels website, unpack it and install packages with "rpm -Uvh".

9fa0130c84cac4b292697ade62270a40 a914db3fdc7a53ddcfd1b2db8f5a1b9c 29d1e90fd304f01e6420fbe60f66f838 b8ef5052d936e902043e41759118114e 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF