Article ID: 115749, created on Mar 19, 2013, last review on Jun 17, 2016

  • Applies to:
  • Plesk 12.5 for Linux
  • Plesk 12.0 for Windows
  • Plesk 11.0 for Windows
  • Plesk 11.5 for Windows
  • Plesk 10.4 for Windows

Fixed since

The problem described in this KB article has been completely fixed since Plesk 11.5 (see release notes).


  1. Database users cannot create views. This error appears in the DB WebAdmin:

    #1142 - CREATE VIEW command denied to user 'db1user'@'localhost' for table 'users_active'
  2. Unable to create routine. The following message is displayed

    You do not have the necessary privileges to create a routine


MySQL database users on Parallels Plesk for Windows are not granted the privilege to create and manage views (routines) by default.


To grant permissions to create and manage views (routines) to a database user, follow these steps:

  1. Log in to Parallels Plesk. Go to Tools & Settings → Database Servers → MySQL Server and open Webadmin.
  2. Select the mysql database, open the db table, and click on Edit in the row of corresponding database users:

  3. In case of required view privileges switch permissions Create_view_priv and Show_view_priv to Y and click Go. In case of required routine privileges switch permission Create_routine_priv and Alter_routine_priv to Y and click Go.
  4. Switch to the SQL tab of Webadmin, type


    and click Go.

    After that, the user will be able to create views inside the database.

Search Words

MySQL Create Routine Access

MySQL users cannot create routines

database user permissions

database user access permissions

database permissions


56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 85a92ca67f2200d36506862eaa6ed6b8 c796c01d6951fa24ed54c7f1111667c6 514af229ae32522202a910a2649c80fb bd7fc88cf1b01f097749ae6f87272128 ff5a00b8ead2e480367b019417a04207 29d1e90fd304f01e6420fbe60f66f838 742559b1631652fadd74764ae8be475e e335d9adf7edffca6a8af8039031a4c7 ed7be2b984f9c27de1d2dc349dc19c6d a766cea0c28e23e978fa78ef81918ab8 46a8e394d6fa13134808921036a34da8

Email subscription for changes to this article
Save as PDF