locked
cannot create stored procedure in mysql database RRS feed

  • Question

  • User-282339866 posted

    database : Mysql

    i was able to create stored procedure in localhost, once i started using live database ,, i am not able to create any procedures,.

    please help

    thanku

    Sunday, January 29, 2012 3:07 AM

All replies

  • User337423781 posted

    Please paste your error/message that you are getting

     

    Sunday, January 29, 2012 3:38 AM
  • User197322208 posted

    There are both same version ?

    http://dev.mysql.com/doc/refman/5.0/en/installation-version.html

    What error do you have?

    Sunday, January 29, 2012 3:38 AM
  • User-282339866 posted

    ERROR 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PROCEDURE `sia_ivr`.`new_routine` ()
    BEGIN
    select * from mc_master;
    END' at line 1
    SQL Statement:
    CREATE DEFINER=`root`@`182.71.232.25` PROCEDURE `sia_ivr`.`new_routine` ()
    BEGIN
    select * from mc_master;
    END

     

     

    and when i was trying with below code its was throwing this error 

    ERROR 1044: Access denied for user 'root'@'%' to database 'sia_ivr'
    SQL Statement:
    CREATE PROCEDURE `sia_ivr`.`new_routine` ()
    BEGIN
    select * from mc_master;
    END

     

    Sunday, January 29, 2012 3:50 AM