MySQL Server 8.0.11
Starting Server 에서 에러 발생
Retry 8: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 1130: Host 'ymkim' is not allowed to connect to this MySQL server
Waiting 3 seconds before the next connection attempt...
Retry 9: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 1130: Host 'ymkim' is not allowed to connect to this MySQL server
Waiting 3 seconds before the next connection attempt...
Retry 10: Attempting to connect to Mysql@localhost:3306 with user root with no password...
MySQL error 1130: Host 'ymkim' is not allowed to connect to this MySQL server
Failed to connect to MySQL Server 8.0.11 after 10 attempts.
Ended configuration step: Starting Server
Host 를 ymkim 으로 설정한 적이 없는데, not allowd to connect to this MySQL server 에러가 발생했습니다.
실제 설치한 경로에는 정상적으로 mysql 이 설치되었으며,
C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -u root -p -h localhost -P 3306
Enter password: ****
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
로그인하려면 실패를 합니다.
C:\Program Files\MySQL\MySQL Server 8.0\bin>netstat -na
활성 연결
프로토콜 로컬 주소 외부 주소 상태
TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
TCP 0.0.0.0:445 0.0.0.0:0 LISTENING
TCP 0.0.0.0:3306 0.0.0.0:0 LISTENING
TCP 0.0.0.0:12025 0.0.0.0:0 LISTENING
~~~~~~~~~~~~~ 중략 ~~~~~~~~~~~~~~~~~~~~~~~~~
netstat 로 확인해보면 설치후 3306이 잘 떠있는것도 확인할 수 있습니다.
C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -uroot -p -h 0.0.0.0 -ptest 3306
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2003 (HY000): Can't connect to MySQL server on '0.0.0.0' (10049)
C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -uroot -p -h ymkim -ptest 3306
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1130 (HY000): Host 'ymkim' is not allowed to connect to this MySQL server
C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -uroot -p -h localhost -ptest 3306
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -uroot -p -h 192.168.100.11 -ptest 3306
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1130 (HY000): Host 'ymkim' is not allowed to connect to this MySQL server
C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -uroot -p -h 127.0.0.1 -ptest 3306
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -uroot -p -h localhost -ptest 3306
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)
C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -uroot
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 31
Server version: 8.0.11 MySQL Community Server - GPL
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
… 그냥 mysql -uroot 로 접속하면 설치된 서버라 바로 접속이 되는 데 뻘짓을 했던 거 같습니다.
그리고 가장 큰 문제는!!!!
C:\Windows\System32\drivers\etc\hosts
해당 파일의 내용에,
# localhost name resolution is handled within DNS itself.
192.168.100.11 localhost
localhost 를 Internet Protocol Version 4(TCP/IPv4) 속성에 설정한 IP주소를 사용하고 있었던 부분에서 Mysql 이 제대로 인식을 못했던 부분으로,
해당 부분을
127.0.0.1 localhost
해당 host 값을 localhost 를 127.0.0.1 로 변경 하면 정상적으로 서버 설치가 되는 걸 확인할 수 있었습니다.
로 인해 발생한 문제로 확인이 되었습니다.