MySql stored procedure call error

Question

I am getting the following error on calling a MySql stored procedure from phpMyAdmin

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

I am using

call get_ledger_name(2007);

to call the procedure

I have tried changing password for root, creating a new user, but the error still prevails.

You need to ensure that (a) the username/password is correct and (b) that user has the necessary access to the database and tables. But I would be VERY concerned at your network security if root and no password connects! — Andrew
– Andrew, Commented Dec 26, 2012 at 8:19
@NitinKabra are you sure that the username and password you have entered was correct? — John Woo
– John Woo, Commented Dec 26, 2012 at 8:21
OK, ta. Suggest you add (to the question) the EXACT command you're using — Andrew
– Andrew, Commented Dec 26, 2012 at 8:22

Saharsh Shah · Accepted Answer · 2012-12-26 08:46:24Z

2

Alter stored procedure with DEFINER=root@localhost and then call this SP. It will run.

Try this:

DELIMITER $$

DROP PROCEDURE IF EXISTS `sp_test`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_test`()
BEGIN
/* Your Code Snippet */
/* Your Code Snippet */
/* Your Code Snippet */
END$$

DELIMITER ;

answered Dec 26, 2012 at 8:46

Saharsh Shah

29.1k9 gold badges53 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Saharsh Shah Over a year ago

You have changed password is good but for this issue there is no need to reset the password.

John Woo · Accepted Answer · 2012-12-26 08:26:41Z

1

Actually you can reset the root password.

How to Reset the Root Password

But keep in mind that it is not advisable to use root account without password.

answered Dec 26, 2012 at 8:26

John Woo

265k70 gold badges509 silver badges500 bronze badges

Collectives™ on Stack Overflow

MySql stored procedure call error

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related