XAMPP EC-CUBE3 Install Error - PDOException: SQLSTATE[HY000] [1045] Access denied fo r user 'root'@'localhost'

XAMPP EC-CUBE Install Error

- PDOException: SQLSTATE[HY000] [1045] Access denied fo

r user 'root'@'localhost'

 

EC-CUBE를 composer.phar를 사용해서 다운받고

 

# php eccube_install.php mysql를 실행해도 아래와 같이 PDOException가 발생한다.

C:\xampp\htdocs\eccube-3.0.16 # php eccube_install.php mysql EC-CUBE3 installer use database driver of pdo_mysql You are already using composer version 1.6.5 (stable channel). You are using the deprecated option "dev". Dev packages are installed by default  now. Loading composer repositories with package information Installing dependencies (including require-dev) from lock file Nothing to install or update Package guzzle/guzzle is abandoned, you should avoid using it. Use guzzlehttp/gu zzle instead. Generating autoload files update permissions... PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000] [1045] Access denied fo r user 'root'@'localhost' (using password: YES) in C:\xampp\htdocs\eccube-3.0.16 \vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:43

PHP Fatal error:  Uncaught PDOException: SQLSTATE[HY000] [1045] Access denied fo r user 'root'@'localhost' (using password: YES) in C:\xampp\htdocs\eccube-3.0.16

 

라고 나와서

http://localhost/phpmyadmin/ 를 root localhost 계정을 수정하거나

XAMPP의 MySQL등의 버젼이 문제라고 생각하고 삭제와 설치를 반복했지만,,

 

C:\xampp\htdocs\eccube-3.0.16\eccube_install.php

파일을 확인해보면

'DBSERVER' => '127.0.0.1'로 되어있고

173-195 line의 getExampleVariables()에

 

function getExampleVariables() {     return array(         'ADMIN_USER' => 'admin',         'ADMIN_MAIL' => 'admin@example.com',         'SHOP_NAME' => 'EC-CUBE SHOP',         'ADMIN_ROUTE' => 'admin',         'ROOT_URLPATH' => '<ec-cube install path>',         'DBSERVER' => '127.0.0.1',         'DBNAME' => 'cube3_dev',         'DBUSER' => 'cube3_dev_user',         'DBPASS' => 'password',         'DBPORT' => '<database port>',         'ROOTUSER' => 'root|postgres',         'ROOTPASS' => 'password',         'MAIL_BACKEND' => 'smtp',         'MAIL_HOST' => 'localhost',         'MAIL_PORT' => '25',         'MAIL_USER' => '<SMTP AUTH user>',         'MAIL_PASS' => '<SMTP AUTH password>',         'AUTH_MAGIC' => '<auth_magic>'     ); }

 

 

XAMPP를 설치하면 ROOT는 PASSWORD가 설정이 되어있지 않다.

 

에서

 

첫번째 root 127.0.0.1의 password를 설정해주면 문제없이 설치된다.

C:\xampp\htdocs\eccube-3.0.16 # php eccube_install.php mysql EC-CUBE3 installer use database driver of pdo_mysql You are already using composer version 1.6.5 (stable channel). You are using the deprecated option "dev". Dev packages are installed by default  now. Loading composer repositories with package information Installing dependencies (including require-dev) from lock file Nothing to install or update Package guzzle/guzzle is abandoned, you should avoid using it. Use guzzlehttp/gu zzle instead. Generating autoload files update permissions... Created database connection... database exists cube3_dev drop database to cube3_dev create database to cube3_dev Dropping database schema... Creating database schema... Database schema created successfully! Database migration successfully! Creating admin accounts... EC-CUBE3 install finished successfully! PHP built-in web server to run applications, `php -S localhost:8080 -t html` Open your browser and access the http://localhost:8080/

 

+ 7월 2일 추가

뭐가 문젠지 모르겠지만 다른 환경에서 새로 설치를 하는데

CommandPrompt로 데이터베이스를 설정하고,

그 다음Web install을 진행하니 정상적으로 index, admin 페이지가 나옴.

소스입력과 웹인스톨 둘 다 필요한 과정인 듯.