jeudi 26 mars 2015

Access denied to user@localhost


As a root user i did this: GRANT DELETE, SELECT, INSERT, UPDATE, EXECUTE ON dbName.* TO 'user'@'localhost' IDENTIFIED BY 'apassword';


In 'dbName' i created a procedure 'proc_name' with definer set to 'user'@'localhost'.


Similarly i create a function 'func_name' with definer set to 'user'@'localhost'.


Now the issue is, i able to do select func_name(); but i am not able to call the procedure proc_name() when i did :


call proc_name(), i get the error:


ERROR 1044 (42000): Access denied for user 'user'@'localhost' to database 'dbName'


Any pointers to the solution would be appreciated.





Aucun commentaire:

Enregistrer un commentaire