mysqli::real_connect(): (HY000/2002): Permission denied

잘 모르겠는데, 3개월째에 갑자기 로그인이 안되는 현상 발생

벌써 두번째인데 정확한 해결책을 확인하지 못했음

일단 현재 환경은 아래와 같음

zextor@thk-nas:/$ lsb_release -a

Distributor ID: Ubuntu
Description:    Ubuntu 22.04.2 LTS
Release:        22.04
Codename:       jammy

zextor@thk-nas:/$ uptime

07:39:40 up 96 days, 14:04,  1 user,  load average: 0.08, 0.08, 0.05

zextor@thk-nas:/$ apache2 -v

Server version: Apache/2.4.52 (Ubuntu)
Server built:   2023-03-08T17:32:01

zextor@thk-nas:/$ php -v

PHP 8.1.2-1ubuntu2.11 (cli) (built: Feb 22 2023 22:56:18) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.1.2, Copyright (c) Zend Technologies
    with Zend OPcache v8.1.2-1ubuntu2.11, Copyright (c), by Zend Technologies

zextor@thk-nas:/$ mysql -v

Server version: 8.0.33-0ubuntu0.22.04.2 (Ubuntu)
                8.0.33-0ubuntu0.22.04.2

 

• 아래와 같은 글이 발견됨, 근데 selinux 설치되어 있지 않으나 폴더는 있음
  • https://stackoverflow.com/questions/73502070/phpmyadmin-mysqli-real-connect-hy000-2002-permission-denied-connection-f
• 아파치와 mysql 재시작하면 증상은 사라짐