Link to home
Start Free TrialLog in
Avatar of Daniel Wilson
Daniel WilsonFlag for United States of America

asked on

MySQL error 1449 "There is no 'User'@'IP' registered" when executing a stored procedure

I had a stored procedure working on one MySQL Server.  I scripted out the DB and imported it to another server.

Now when I execute the procedure i get the error in the title.

I checked my script, and there is no "DEFINER" clause in my procedure.  

I dropped the procedure & added it again.

no better.

The Drop / Create for the procedure are attached. (using $$ as delimiter)

What am I doing wrong?

Thanks!
DROP PROCEDURE uspUserLogin $$

CREATE PROCEDURE uspUserLogin(
p_UserName varchar( 20 ) ,
PwdHash varchar( 255 )
) BEGIN SELECT users.ID, users.UserName, userTypes.UserTypeName, users.FirstName, users.LastName, users.Extension
FROM `wt_collectors` AS users
INNER JOIN `wt_usertyes` AS userTypes ON userTypes.UserTypeID = users.UserTypeID
WHERE UserName = p_UserName
AND PASSWORD = PwdHash
AND Active =1;

END $$

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of jazzIIIlove
jazzIIIlove
Flag of Sweden image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Daniel Wilson

ASKER

Thanks, but I already found that article.  As I said,

I checked my script, and there is no "DEFINER" clause in my procedure.  

I dropped the procedure & added it again.

no better.

Other ideas?
Hold on, you're at least partly right.

the procedure queries a view ... and its Definer is set wrong.
I re-ran the
Create Or Replace VIEW
script & all is well.

Thanks!