by 박성현장군님 [SQL Query] [2019.03.28 19:50:00]
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: DELETE command denied to user 'jspid'@'localhost' for table 'member'
요런 에러가 발생해서 DELETE문을 사용할 수 있는 권한을 주기 위해서
grant all privileges on 'member' to 'jspid'@'localhost' identified by 'jsppass';
GRANT ALL PRIVILEGES ON *.* to 'jspid'@'localhost' BY 'password' WITH GRANT OPTION;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON jsptest.* TO jspid'@'localhost;
요렇게 GRANT 문을 입력 했는데 전부 오류가 떠서 어케 해야 될지 도저히 모르겠습니다.;;
오류 메시지가
grant all privileges on 'member' to 'jspid'@'localhost' identified by 'jsppass'
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''member' to 'jspid'@'localhost' identified by 'jsppass'' at line 1
입니다