Daniel Wilson
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!
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 $$
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hold on, you're at least partly right.
the procedure queries a view ... and its Definer is set wrong.
the procedure queries a view ... and its Definer is set wrong.
ASKER
I re-ran the
Create Or Replace VIEW
script & all is well.
Thanks!
Create Or Replace VIEW
script & all is well.
Thanks!
ASKER
I dropped the procedure & added it again.
no better.