ERROR: "SUPER privilege" required to create view in MySQL

[gadders]

Hi,

I'm trying to create a view in my database, and I receive the following error.

CREATE ALGORITHM = UNDEFINED DEFINER = `root`@`localhost` SQL SECURITY DEFINER VIEW `fishmap_v1`.`fishery_list` AS SELECT `fishmap_v1`.`fishery_details`.`name` AS `name` , `fishmap_v1`.`fishery_details`.`add1` AS `add1` , `fishmap_v1`.`fishery_details`.`add2` AS `add2` , `fishmap_v1`.`fishery_details`.`add3` AS `add3` , `fishmap_v1`.`fishery_details`.`county` AS `county` , `fishmap_v1`.`fishery_details`.`postcode` AS `postcode` , `fishmap_v1`.`fishery_details`.`latitude` AS `latitude` , `fishmap_v1`.`fishery_details`.`longitude` AS `longitude` , `fishmap_v1`.`contact`.`name` AS `person` , `fishmap_v1`.`contact`.`phone` AS `phone` , `fishmap_v1`.`contact`.`email` AS `email` , `fishmap_v1`.`fishing_method`.`method` AS `method` , `fishmap_v1`.`fishing_type`.`fishing_type` AS `fishing_type` 
FROM (
(
(
`fishmap_v1`.`fishery_details` 
JOIN `fishmap_v1`.`contact` 
)
JOIN `fishmap_v1`.`fishing_type` 
)
JOIN `fishmap_v1`.`fishing_method` 
)
WHERE (
(
`fishmap_v1`.`fishery_details`.`contact_id` = `fishmap_v1`.`contact`.`id` 
)
AND (
`fishmap_v1`.`fishery_details`.`type_id` = `fishmap_v1`.`fishing_type`.`id` 
)
AND (
`fishmap_v1`.`fishery_details`.`method_id` = `fishmap_v1`.`fishing_method`.`id` 
)
);



MySQL said:  
#1227 - Access denied; you need the SUPER privilege for this operation

I've searched the forums and also the MySQL control panel to see how to grant myself those privileges but can't find any suggestions.

Many thanks in advance for your help.

Mark

 

[Alejandro]

You cannot create a database from a script. Only root can. You need to go to cPanel, then to MySQL Databases and create a database from there.