Oracle/MySQL 관련 게시판

Oracle/MySQL 관련 게시판

2017/09/06(00:07) from 58.231.170.99
작성자 : 주인장	조회수 : 3829 , 줄수 : 97

[APM] Apache-2.4.27-Win32-VC15 + php-5.6.31-Win32-VC11-x86

1. 필요한 파일

httpd-2.4.27-Win32-VC15.zip (https://www.apachelounge.com/download/)
httpd-2.4.27-Win64-VC15.zip (https://www.apachelounge.com/download/)
php-5.6.31-Win32-VC11-x64.zip (http://windows.php.net/download/)
php-5.6.31-Win32-VC11-x86.zip (http://windows.php.net/download/)
vc_redist.x64.zip (https://www.apachelounge.com/download/)
vc_redist.x86.zip (https://www.apachelounge.com/download/)
phpMyAdmin-4.7.3-all-languages.zip (https://www.phpmyadmin.net/files/4.7.3/)

2. Apache-2.4.27-Win32-VC15 설치 디렉토리

D:\Apache-2.4.27-Win32-VC15

3. php-5.6.31-Win32-VC11-x86 설치 디렉토리

D:\Apache-2.4.27-Win32-VC15\lib\php-5.6.31-Win32-VC11-x86

4. phpMyAdmin-4.7.3-all-languages 설치 디렉토리

D:\Apache-2.4.27-Win32-VC15\htdocs\phpMyAdmin-4.7.3-all-languages

5. Apache's httpd.conf 설정

# If the AddEncoding directives above are commented-out, then you
# probably should define those extensions to indicate media types:
#
AddType application/x-compress .Z
AddType application/x-gzip .gz .tgz

#
# jkkang's add (2017. 09. 05)
#
AddType application/x-httpd-php .php .inc .bak .old .c

# Real-time info on requests and configuration
#Include conf/extra/httpd-info.conf

#
# jkkang's add (2017. 09. 05)
#
# PHP5
Include conf/extra/httpd-php5.conf

6. Apache's extra/httpd-php5.conf 설정

#
# jkkang's add (2017. 09. 05)
# mod_php5 설정
#
LoadModule php5_module "D:/Apache-2.4.27-Win32-VC15/lib/php-5.6.31-Win32-VC11-x86/php5apache2_4.dll"
AddType application/x-httpd-php .php .html
PHPIniDir "D:/Apache-2.4.27-Win32-VC15/lib/php-5.6.31-Win32-VC11-x86"

7. php-5.6.31's php.ini 설정

D:/Apache-2.4.27-Win32-VC15/lib/php-5.6.31-Win32-VC11-x86\php.ini

; Directory in which the loadable extensions (modules) reside.
; http://php.net/extension-dir
; extension_dir = "./"
; On windows:
; extension_dir = "ext"
;
; jkkang's add (2017. 09. 05)
;
extension_dir = "D:\Apache-2.4.27-Win32-VC15\lib\php-5.6.31-Win32-VC11-x86\ext"

8. phpMyAdmin 접속

http://localhost/phpMyAdmin-4.7.3-all-languages/

@ Error
Login without a password is forbidden by configuration (see AllowNoPassword)

@ 해결책
phpmyadmin에서 아래 파일을 편집
config.inc.php
에 아래라인 추가

/* 암호없이 root로 로긴하고자 할때 활성화 false -> true*/
$cfg['Servers'][$i]['AllowNoPassword'] = true;