1

I am using DBVisualizer for the first time. I have made a stored procedure in mysql database. However I am unable to execute it from DBVisualizer.

This is how the procedure looks like. Here // is used as delimiter. I have four columns in the table namely slno int (autoincrement), time timestamp, price int, and prodid varchar.

*DROP PROCEDURE `spTest`//
CREATE DEFINER=`root`@`localhost` PROCEDURE `spTest`()
BEGIN
SELECT * FROM dummy1 where prodid=pr01;
END*

In DBVisualizer, I am executing @call spTest()

Where am I going wrong?

Matt
  • 14,353
  • 5
  • 53
  • 65
Piyush
  • 11
  • 1
  • 3

1 Answers1

0

As the definer of the stored procedure is root, your DBVizualizer connection to MySQL must be as the root user in order to execute it.

Mark Chorley
  • 2,087
  • 2
  • 22
  • 29