윈도우 XAMPP 서버 운영 방법!

xampp 윈도우 서버셋팅

명령어
mysql/bin/
mysql -u root
UPDATE mysql.user SET Password=PASSWORD('test1234') WHERE User='root';
FLUSH PRIVILEGES;
mysql 재부팅

D:\xampp\phpMyAdmin\config.inc.php 파일 수정
$cfg['Servers'][$i]['auth_type'] = 'cookie';
mysql 재부팅
테스트

디비 디렉토리 변경
datadir = "D:/db/data"
D:\xampp\mysql\data -> D:\db\data 복사
mysql 재부팅

버츄얼 호스트

C:/xampp/apache/conf/httpd.conf
# Virtual hosts
Include conf/extra/httpd-vhosts.conf
Include conf/extra/httpd-uhosts.conf

C:/xampp/apache/conf/extra/httpd-vhosts.conf

NameVirtualHost *:80
<VirtualHost *:80>
DocumentRoot "D:/web/ebiz"
ServerName localhost
ServerAlias localhost
<Directory "D:/web/ebiz">
AllowOverride All
Require all granted
</Directory>
</VirtualHost>

php.ini
[Date]
; Defines the default timezone used by the date functions
; http://php.net/date.timezone
date.timezone = Asia/Seoul

CREATE USER 'ebiz'@'localhost' IDENTIFIED BY '***';GRANT USAGE ON *.* TO 'ebiz'@'localhost' IDENTIFIED BY '***' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;CREATE DATABASE IF NOT EXISTS `ebiz`;GRANT ALL PRIVILEGES ON `ebiz`.* TO 'ebiz'@'localhost';