MySQL: Creating views and functions

Make sure thet the database user has SUPER Privilege, CREATE VIEWS and CREATE ROUTINE. In SQL Query type the following:

mysql> SET GLOBAL log_bin_trust_routine_creators = 1;

* Using MySQL 5.0.18