The user specified as a definer ('someuser'@localhost') does not exist
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.
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.