Programming/Apache, PHP
Apache 2.4 : phpMyAdmin 설치
파란크리스마스
2020. 11. 11. 02:19
728x90
출처
- Elkha: phpMyAdmin 설치
- [PHP] 개발환경 구성하기 5 : 네이버 블로그
- 웹 기반 mysql 관리툴 – phpmyadmin 설치 및 설정 | | Hoing
- [Fix phpMyAdmin] 구성 file 이제 비밀 암호가 필요합니다 (blowfish_secret)-STEALTH SETTINGS
1. 다운로드
phpMyAdmin에서 phpMyAdmin-5.0.4-all-languages.zip 파일 다운로드
2. 압축풀기
phpMyAdmin-5.0.4-all-languages.zip 압축파일을 C:\usr\local\phpMyAdmin-5.0.4-all-languages 폴더에 압축 해제
3. config.inc.php 파일 생성
C:\usr\local\phpMyAdmin-5.0.4-all-languages\config.sample.inc.php 파일을 config.inc.php로 복사
4. 환경파일 수정(config.inc.php)
/** * This is needed for cookie based authentication to encrypt password in * cookie. Needs to be 32 chars long. */ $cfg['blowfish_secret'] = 'gNsWq$%#%$#%EDFSsffsegbVp6LCJw6w'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */ /** * Servers configuration */ $i = 0; /** * First server */ $i++; /* Authentication type */ $cfg['Servers'][$i]['auth_type'] = 'cookie'; /* Server parameters */ $cfg['Servers'][$i]['host'] = 'localhost'; $cfg['Servers'][$i]['port'] = '3306'; $cfg['Servers'][$i]['compress'] = false; $cfg['Servers'][$i]['AllowNoPassword'] = false; // $cfg['Servers'][$i]['user'] = 'root';
5. httpd.conf 가상폴더 추가
Tomcat 연동이 없는 경우
Alias /mysql "C:/usr/local/phpMyAdmin-5.0.4-all-languages" <Directory "C:/usr/local/phpMyAdmin-5.0.4-all-languages"> Options FollowSymLinks DirectoryIndex index.html index.htm index.php *.jsp *.php Order allow,deny Allow from all </Directory>
Tomcat 연동의 경우
# Tomcat 연동 <IfModule jk_module> JkWorkersFile conf/workers.properties JkLogFile logs/mod_jk.log JkLogLevel info JkMount /* load_balancer </IfModule> AddDefaultCharset Off # phpMyAdmin <VirtualHost *:80> ServerAdmin admin@phpmyadmin.abc.kr DocumentRoot "C:/usr/local/phpMyAdmin-5.0.4-all-languages" ServerName localhost # ServerAlias /mysql # DirectoryIndex index.php Alias /mysql "C:/usr/local/phpMyAdmin-5.0.4-all-languages" <Directory "C:/usr/local/phpMyAdmin-5.0.4-all-languages"> AllowOverride ALL Options FollowSymLinks MultiViews DirectoryIndex index.html index.htm index.php *.jsp *.php Require all granted </Directory> </VirtualHost>
6. php.ini 수정
; When the extension library to load is not located in the default extension ; directory, You may specify an absolute path to the library file: ; ; extension=/path/to/extension/mysqli.so extension=php_mysqli.dll ;extension=mbstring extension=php_mbstring.dll ;extension=pdo_mysql extension=php_pdo_mysql.dll
728x90