MySQL Forums
Forum List  »  General

The user specified as a definer ('someuser'@localhost') does not exist
Posted by: Anandkumar Sagar
Date: March 18, 2019 08:33AM

Hi,

I have created user(testuser) to connect to db. after connecting to database using testuser , When I execute any prepared statement from application i get below error. Nowhere i mentioned user 'someuser' in my application. Note select/delete statement are working fine.

Note: for privacy privacy purpose I replaced actual user with someuser.

java.sql.SQLException: The user specified as a definer ('someuser'@'localhost') does not exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.12.jar:8.0.12]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.12.jar:8.0.12]



When I run select host, user from mysql.user; it does not give someuser which is expected as I have not defined this user.

Options: ReplyQuote


Subject
Written By
Posted
The user specified as a definer ('someuser'@localhost') does not exist
March 18, 2019 08:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.