データベースの権限設定

GRANT SELECT ON navi.* TO read001@localhost;
GRANT INSERT ON navi.* TO read001@localhost;
GRANT CREATE TEMPORARY TABLES ON navi.* TO read001@localhost;
GRANT SHOW VIEW ON navi.* TO read001@localhost;
flush privileges;