Article ID: 604, created on Oct 6, 2008, last review on Apr 18, 2012

  • Applies to:
  • Plesk for Linux/Unix


Log into Mysql with root privileges and perform the following:

mysql> use mysql;

mysql> update user set Create_tmp_table_priv = 'N', Lock_tables_priv = 'N'
where user is like 'web%';

mysql> alter table user modify Create_tmp_table_priv enum('N','Y') default 'N',
modify Lock_tables_priv enum ('N','Y') default 'N';

mysql> flush privileges;

mysql> exit;

29d1e90fd304f01e6420fbe60f66f838 a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF