The user specified as a definer does not exist
java.sql.SQLException: The user specified as a definer does not exist
Solusi :
CREATE USER 'your_user'@'localhost' IDENTIFIED BY '';
grant all privileges on *.* to 'your_user'@'localhost' with grant option;
Jika masih menemukan error ini :
java.sql.SQLException: references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Jalankan perintah ini
CREATE USER 'your_user'@'%' IDENTIFIED BY '';
dan
grant all privileges on *.* to 'your_user'@'%' with grant option;
No comments:
Post a Comment