MYSQL:
首次安裝后:
1蛉幸、初始化mysql
my.cnf文件包含數(shù)據(jù)存放目錄和臨時目錄:
datadir? ? ? ? = /mnt/data/mysql/
tmpdir? ? ? ? ? = /mnt/data/tmp/
首先創(chuàng)建上述兩個文件夾,然后進(jìn)入/usr/bin
設(shè)置初始密碼:mysqladmin -u root password 'new_password'
設(shè)置初始數(shù)據(jù)庫:mysql_install_db --force
讓mysql支持遠(yuǎn)程訪問:
mysql->grant all privileges on *.* to root@'%' identified by 'your_password' with grant option;
mysql->flush privileges;
/etc/my.cnf 里修改bind-address=0.0.0.0
2、設(shè)置字符集(/etc/my.cnf)
[client] and [mysqld]
// add default-character-set
// mysql 5.5 版本添加character-set-server=utf8
default-character-set = utf8
字符集搜索結(jié)果如下:
(如果想更改某個字符集,輸入如下):
mysql>SETcharacter_set_client=utf8;
mysql>SETcharacter_set_connection=utf8;
mysql>SETcharacter_set_database=utf8;
mysql>SETcharacter_set_results=utf8;
mysql>SETcharacter_set_server=utf8;
mysql>SETcollation_connection=utf8;
mysql>SETcollation_database=utf8;
mysql>SETcollation_server=utf8;
PHP:
php相關(guān)模塊
php5? php5-cgi? php5-fastcgi? php5-mod-gd? php5-mod-json? php5-mod-mysql
php-mod-pdo? php5-mod-pdo-mysql php5-mod-xml
php5-mod-iconv ?iconv? php5-mod-mbstring(中文支持)
時間支持
安裝zoneinfo-asia
修改php.ini :date.timezone = Asia/Shanghai
(這是為了防止strtotime方法無法使用)
ln -s /usr/lib/libpcre.so /usr/lib/libpcre.so.0(如果安裝新版無法找到so.0)