ReStart Weblog

May

24/05: XAMP の設定文字コード

Category: Restart

Posted by: fuku

php.ini の修正

default_charset = "utf8"
mbstring.internal_encoding = utf8
mbstring.http_input = utf8
mbstring.http_output = utf8
mbstring.language = Japanese

my.cnfの設定

[client]
default-character-set = utf8

[mysqld]
default-character-set = utf8
character-set-server = utf8

May

24/05: XAMP の設定

Category: Linux

Posted by: fuku

XAMPPのセキュリティホールの設定を行う

# /opt/lampp/lampp security
XAMPP: Quick security check...
XAMPP: Your XAMPP pages are NOT secured by a password.
XAMPP: Do you want to set a password? [yes] yes
XAMPP: Password:
XAMPP: Password (again):
XAMPP: Password protection active. Please use 'lampp' as user name!
XAMPP: MySQL is accessable via network.
XAMPP: Normaly that's not recommended. Do you want me to turn it off? [yes] yes
XAMPP: Turned off.
XAMPP: Stopping MySQL...
XAMPP: Starting MySQL...
XAMPP: The MySQL/phpMyAdmin user pma has no password set!!!
XAMPP: Do you want to set a password? [yes] yes
XAMPP: Password:
XAMPP: Password (again):
XAMPP: Setting new MySQL pma password.
XAMPP: Setting phpMyAdmin's pma password to the new one.
XAMPP: MySQL has no root passwort set!!!
XAMPP: Do you want to set a password? [yes]
XAMPP: Write the password somewhere down to make sure you won't forget it!!!
XAMPP: Password:
XAMPP: Password (again):
XAMPP: Setting new MySQL root password.
XAMPP: Change phpMyAdmin's authentication method.
XAMPP: The FTP password for user 'nobody' is still set to 'lampp'.
XAMPP: Do you want to change the password? [yes]
XAMPP: Password:
XAMPP: Password (again):
XAMPP: Reload ProFTPD...
XAMPP: Done.

http://XXXXX/xampp/index.php
ユーザー　lampp
パスワード　設定したパスワード

http://XXXXX/phpMyAdmin/index.php
ユーザーpma
パスワード　設定したパスワード

May

11/05: XAMPP Linux版　インストール

Category: Restart

Posted by: fuku

XAMPP for Linuxのサイトを参考にインストール

Linuxの環境は、さくらインターネットの専用サーバCentOS5

１．ダウンロード
xampp-linux-1.7.1.tar.gz

２．解凍
tar xvfz xampp-linux-1.7.1.tar.gz -C /opt

３．/opt/lampp/etc/extra/httpd-xampp.conf を編集

[Mon May 11 11:46:30 XXXX] [error] [client XXX.XXX.XXX.XXX] client denied by server configuration: /opt/lampp/htdocs/xampp/index.php

のエラーを回避する為、

#Deny from all　

をコメント

４．パーミッションの変更

Existing configuration file (./config.inc.php) is not readable.

のエラーを回避する為、

パーミッションの変更
chmod 705 config.inc.php

May

10/05: MYSQL スーパーユーザー作成

Category: MYSQL

Posted by: fuku

GRANT ALL PRIVILEGES ON *.* TO user@localhost IDENTIFIED BY 'pass' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO user@"%" IDENTIFIED BY 'pass' WITH GRANT OPTION;

May