CREATE VIEW command denied to user
hey there,
There is something wrong when I use SQL via phpMyAdmin:
Code:
-- --------------
CREATE ALGORITHM=UNDEFINED DEFINER=`my_spsoftware`@`localhost` SQL SECURITY DEFINER VIEW `vmp_vw_products` AS select `p1`.`id` AS `id`,`p1`.`parentid` AS `parentid`,`p1`.`name` AS `name`,`p1`.`snattrs` AS `snattrs`,`p1`.`active` AS `active`,if(isnull(`p1`.`parentid`),`p1`.`algorithm`,`p2`.`algorithm`) AS `algorithm`,if(isnull(`p1`.`parentid`),`p1`.`bits`,`p2`.`bits`) AS `bits`,if(isnull(`p1`.`parentid`),`p1`.`uses_act`,`p2`.`uses_act`) AS `uses_act`,if(isnull(`p1`.`parentid`),`p1`.`act_pattern`,`p2`.`act_pattern`) AS `act_pattern`,if(isnull(`p1`.`parentid`),`p1`.`act_extracount`,`p2`.`act_extracount`) AS `act_extracount`,if(isnull(`p1`.`parentid`),`p1`.`name`,concat(`p2`.`name`,' - ',`p1`.`name`)) AS `fullname`,if(isnull(`p1`.`parentid`),`p1`.`product_code`,`p2`.`product_code`) AS `product_code`,if(isnull(`p1`.`parentid`),`p1`.`public_exp`,`p2`.`public_exp`) AS `public_exp`,if(isnull(`p1`.`parentid`),`p1`.`private_exp`,`p2`.`private_exp`) AS `private_exp`,if(isnull(`p1`.`parentid`),`p1`.`modulus`,`p2`.`modulus`) AS `modulus` from (`vmp_products` `p1` left join `vmp_products` `p2` on((`p1`.`parentid` = `p2`.`id`))) ;
-- --------------
Here's some error messages:
-------------
MySQL said: Documentation
#1142 - CREATE VIEW command denied to user 'spsoftware'@'localhost' for table 'vmp_vw_products'
----------------
I've google it and google says "GRANT CREATE VIEW ON *.* TO 'username'@'host'; " can fix it.
but I used this SQL from phpMyAdmin, also Access denied.
any ideas?
