error mariadb The user specified as a definer does not exist | java php laravel linux mysql sql bootstrap html css query java php laravel linux mysql sql bootstrap html css query: error mariadb The user specified as a definer does not exist

Wednesday, February 6, 2019

error mariadb The user specified as a definer does not exist

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

saifiahmada.com adalah blog belajar programming Indonesia, membahas lengkap materi bahasa pemrograman: code HTML, CSS, Bootstrap, Desain, PHP, MySQL, coding Java, Query, SQL, dan dunia linux