Error: 1449, "The user specified as a definer ('root'@'localhost') does not exist"
<p>I get the above error when I try to retrieve data or insert data via my app to my database. The proc code is as follows</p>

<pre><code>CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_createUser`(
    IN p_name VARCHAR(20),
    IN p_username VARCHAR(20),
    IN p_password VARCHAR(20)
)
BEGIN
    if ( select exists (select 1 from tbl_user where user_username = p_username) ) THEN

        select 'Username Exists !!';

    ELSE

        insert into tbl_user
        (
            user_name,
            user_username,
            user_password
        )
        values
        (
            p_name,
            p_username,
            p_password
        );

    END IF;
END $$
DELIMITER ;
</code></pre>

<p>However, when I run the following query in my sqlyog it returns a 1:
<code>SELECT EXISTS(SELECT 1 FROM mysql.user WHERE USER = 'root');</code></p>

<p>I am using XAMPP and Python to make my app.
Thanks in advance.</p>