Resolved errors DB need help

[justin3ryu]

java.sql.SQLException: The user specified as a definer ('master'@'localhost') does not exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:113)
at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1286)
at com.mysql.cj.jdbc.StatementWrapper.executeQuery(StatementWrapper.java:557)
at services.pawnshop.PawnShop$PawnShopItem.loadItems(Unknown Source)
at services.pawnshop.PawnShop.cz(Unknown Source)
at services.pawnshop.PawnShop.onLoad(Unknown Source)
at l2.gameserver.scripts.Scripts.init(Unknown Source)
at l2.gameserver.GameServer.<init>(Unknown Source)
at l2.gameserver.GameServer.main(Unknown Source)



I changed database master to root in auth&gameserver and new navicat (navicat 9 to latest one)

but this error log shows

 

[Deazer]

java.sql.SQLException: The user specified as a definer ('master'@'localhost') does not exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:113)
at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1286)
at com.mysql.cj.jdbc.StatementWrapper.executeQuery(StatementWrapper.java:557)
at services.pawnshop.PawnShop$PawnShopItem.loadItems(Unknown Source)
at services.pawnshop.PawnShop.cz(Unknown Source)
at services.pawnshop.PawnShop.onLoad(Unknown Source)
at l2.gameserver.scripts.Scripts.init(Unknown Source)
at l2.gameserver.GameServer.<init>(Unknown Source)
at l2.gameserver.GameServer.main(Unknown Source)



I changed database master to root in auth&gameserver and new navicat (navicat 9 to latest one)

but this error log shows

There is no such user for the procedures. When you installed the database, you had such a user, then you migrated the database to another server where this user does not exist. But the procedures already declared the user. Delete these rows at server_variables columne and restart the server.