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

Posted on 2010-01-01
Last Modified: 2012-08-14
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?

DROP 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 Active =1;

END $$

Open in new window

Question by:Daniel Wilson
    LVL 12

    Accepted Solution

    Hi there;

    Go to MySQL administrator, select schemata, views, select a view, edit SQL view SQL and look for the part that reads "DEFINER=`[username]`@`localhost`" and change the '[username]' reference to root, or another user that exists on the new server as appropriate


    Best regards.
    LVL 32

    Author Comment

    by:Daniel Wilson
    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?
    LVL 32

    Author Comment

    by:Daniel Wilson
    Hold on, you're at least partly right.

    the procedure queries a view ... and its Definer is set wrong.
    LVL 32

    Author Comment

    by:Daniel Wilson
    I re-ran the
    Create Or Replace VIEW
    script & all is well.


    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
    Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now