Appserv安裝備忘

MYSQL
1.建帳號、新增使用者
mysql> grant all privileges on *.* to 'vega'@'localhost' identified by 'vega' with grant option;
mysql> grant all privileges on *.* to 'vega'@'%' identified by 'vega' with grant option;

mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON dbname.* to 'vega'@'%' identified by 'vega';


更新權限
mysql>flush privileges;

2.改密碼
mysql>update user set Password=PASSWORD('new_pass') where user='root';

MYSQL 5.7版已無Password欄位
update user set authentication_string=password('1111') where user='root';


web root:
C:\AppServ\www

modify C:\WINDOWS\php.ini
打開output_buffering
output_buffering = Off -> output_buffering = On
打開PDO for mysql
;extension=php_pdo_mysql.dll -> extension=php_pdo_mysql.dll

記憶體限制調大
memory_limit = 8M 改為 32M

設定時區
date.timezone = "Asia/Taipei"

關閉session warn
session.bug_compat_42 = 0

session.bug_compat_warn = 0