mysql문제

Question

Caused by: java.sql.SQLException: null, message from server: &#34;Host 'ㄴㄴㄴ' is not allowed to connect to this MySQL server&#34; at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130) ~[mysql-connector-j-8.1.0.jar!/:8.1.0] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-j-8.1.0.jar!/:8.1.0] at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:819) ~[mysql-connector-j-8.1.0.jar!/:8.1.0] at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:440) ~[mysql-connector-j-8.1.0.jar!/:8.1.0] at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239) ~[mysql-connector-j-8.1.0.jar!/:8.1.0] at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:188) ~[mysql-connector-j-8.1.0.jar!/:8.1.0] at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-5.0.1.jar!/:na] at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359) ~[HikariCP-5.0.1.jar!/:na] at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201) ~[HikariCP-5.0.1.jar!/:na] at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470) ~[HikariCP-5.0.1.jar!/:na] at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:733) ~[HikariCP-5.0.1.jar!/:na] at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:712) ~[HikariCP-5.0.1.jar!/:na] at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[na:na] at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1135) ~[na:na] at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[na:na] ... 1 common frames omitted 계속 이문제가 발생합니다. mysql 에서는GRANT ALL PRIVILEGES ON . TO 'root'&#64;'ㄴㄴ' IDENTIFIED BY '1234';FLUSH PRIVILEGES;이렇게 권한 문제라고 하는데 이렇게 일시적으로만 되고 다시 이 문제 발생해요ㅠㅠ

Dajw_hub · Answer

ㄴㄴ대신 영어로..

HJOW · Answer

호스트명, 도메인, 코딩 중에 변수명 등에는영어, 숫자, 언더바만 쓰세요. 숫자도 첫글자엔 쓰지 마세요.캐릭터셋마다 표현이 다른 문자는 쓰지 마세요. 이것 때문에 문제 생기면 원인 찾기 까다로운 경우가 되게 많습니다.

mysql문제

2개의 답변

#ec2 목록