Linux+Apache2+Mysql+Php的安裝配置方法

143次閱讀

共計 6227 個字符，預計需要花費 16 分鐘才能閱讀完成。

這篇文章主要介紹“Linux+Apache2+Mysql+Php 的安裝配置方法”，在日常操作中，相信很多人在 Linux+Apache2+Mysql+Php 的安裝配置方法問題上存在疑惑，丸趣 TV 小編查閱了各式資料，整理出簡單好用的操作方法，希望對大家解答”Linux+Apache2+Mysql+Php 的安裝配置方法”的疑惑有所幫助！接下來，請跟著丸趣 TV 小編一起來學習吧！

在此 Linux 下全新安裝配置 Mysql、Apache2、PHP，解決在安裝 Mysql 時出現的報錯：Character set gbk is not a compiled character set and is not specified in the /usr/local/mysql/share/mysql/charsets/Index.xml file

在安裝 mysql 后可以在下面目錄找到 mysql 的相關安裝配置信息說明 /usr/local/mysql/info/mysql.info

[@more@]

在此 Linux 下全新安裝配置 Mysql、Apache2、PHP，解決在安裝 Mysql 時出現的報錯：Character set gbk is not a compiled character set and is not specified in the /usr/local/mysql/share/mysql/charsets/Index.xml file

在安裝 mysql 后可以在下面目錄找到 mysql 的相關安裝配置信息說明 /usr/local/mysql/info/mysql.info

############################################

1. 檢查系統及內核狀態
[root@app /]# cat /etc/issue
Red Hat Enterprise Linux AS release 4 (Nahant)
Kernel r on an m
[root@app /]# cat /proc/version
Linux version 2.6.9-5.ELsmp (bhcompile@decompose.build.redhat.com) (gcc version 3.4.3 20041212 (Red Hat 3.4.3-9.EL4)) #1 SMP Wed Jan 5 19:30:39 EST 2005
[root@app /]# uname -r
2.6.9-5.ELsmp
1.1 查看 CPU 及 MEM
[root@app /]# grep model name /proc/cpuinfo
model name : Intel(R) Xeon(R) CPU 5130 @ 2.00GHz
model name : Intel(R) Xeon(R) CPU 5130 @ 2.00GHz
model name : Intel(R) Xeon(R) CPU 5130 @ 2.00GHz
model name : Intel(R) Xeon(R) CPU 5130 @ 2.00GHz
[root@app /]# grep MemTotal /proc/meminfo
MemTotal: 4147280 kB
1.2 操作系統位數
[root@app /]# getconf LONG_BIT
32
[root@app /]# ldd /sbin/mii-tool
libc.so.6 = /lib/tls/libc.so.6 (0x0097e000)
/lib/ld-linux.so.2 (0x00965000)

2. 準備好安裝包
mysql-5.0.45.tar.gz
mysql-5.0.45-linux-i686-glibc23.tar.gz
httpd-2.2.4.tar.gz
php-4.4.7.tar.gz

3. 進行安裝配置
3.1 檢查系統是否已經安裝相應的 Mysql,php,apache 軟件包
# rpm -qa | grep mysql 和# rpm -qa | grep MySQL
rpm -q -a|grep -i mysql
rpm -q -a|grep -i httpd
rpm -q -a|grep -i php
如果沒有返回以 mysql 或 MySQL 打頭的信息, 則說明沒有安裝. 如果已經安裝, 則可以直接使用或更換新版本
卸載方法:
# rpm -e mysql-xxxxxx
# rpm -e httpd-xxxxxx
# rpm -e php-xxxxxx
遇到依賴性問題而無法卸載，可以使用 –nodeps 或—force 強制卸載. 不過最好慎用.
rpm -e –nodeps httpd
rpm -e –nodeps php
3.2 進行安裝
cp mysql-5.0.45.tar.gz /tmp
cp mysql-5.0.45-linux-i686-glibc23.tar.gz /tmp
cp httpd-2.2.4.tar.gz /tmp
cp php-4.4.7.tar.gz /tmp
3.3 Mysql-5.0.45 版本的安裝
cd /tmp
tar xvfz mysql-5.0.45.tar.gz
cd /mysql-5.0.45
./configure –prefix=/usr/local/mysql –with-extra-charsets=gbk –with-charset=gbk –sysconfdir=/etc –localstatedir=/var/lib/mysql
make
make install
指定字符類型為 gbk 進行編譯安裝

#prefix=/usr/local/mysql mysql 安裝的目標目錄

#sysconfdir=/etc my.cnf 配置文件的路徑

#localstatedir=/var/lib/mysql 數據庫存放的路徑

安裝完以后要初始化數據庫，當然你是升級的話不用做這步；

/usr/local/mysql/bin/mysql_install_db –user=mysql

Installing MySQL system tables…
OK
Filling help tables…
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/local/mysql/bin/mysqladmin -u root password new-password
/usr/local/mysql/bin/mysqladmin -u root -h app.shunde.gov.cn password new-password
See the manual for more instructions.
You can start the MySQL daemon with:
cd /usr/local/mysql ; /usr/local/mysql/bin/mysqld_safe
信息有提示將
cp /usr/local/mysql/share/mysql/mysql.server /etc/rc.d/init.d/mysqld
cp /usr/local/mysql/share/mysql/my-huge.cnf /etc/my.cnf
/usr/local/mysql/bin/mysqladmin -u root password ******
啟動 Mysql 進行測試
/etc/rc.d/init.d/mysqld status
/etc/rc.d/init.d/mysqld start
如果大家還是不能啟動不了的話，那就用我的比較繁瑣的權限的設置，反正我每次都是這么做的，一般不會有問題，見下：
chown -R root /usr/local/mysql
chgrp -R mysql /usr/local/mysql
chown -R root /usr/local/mysql/bin
chgrp -R mysql /usr/local/mysql/bin
chgrp -R mysql /var/lib/mysql
chmod 777 /var/lib/mysql
chown -R root /var/lib/mysql/mysql
chgrp -R mysql /var/lib/mysql/mysql
chmod 777 /var/lib/mysql/mysql
chown -R root /var/lib/mysql/mysql/*
chgrp -R mysql /var/lib/mysql/mysql/*
chmod 777 /var/lib/mysql/mysql/*
chmod 777 /usr/local/mysql/lib/mysql/libmysqlclient.a

ln -s /usr/local/mysql/lib/mysql /usr/lib/mysql
ln -s /usr/local/mysql/include/mysql /usr/include/mysql

其下可能還有如下錯誤出現
/usr/local/mysql/bin/mysqladmin: Character set gbk is not a compiled character set and is not specified in the

/usr/local/mysql/share/mysql/charsets/Index.xml file
/usr/local/mysql/bin/mysqladmin: connect to server at localhost failed
error: Can t initialize character set gbk (path: /usr/local/mysql/share/mysql/charsets/)

現在找到該解決辦法是打 mysql-5.0.45-linux-i686-glibc23.tar.gz 補丁包
cd /tmp
tar xvfz mysql-5.0.45-linux-i686-glibc23.tar.gz
cp /usr/local/mysql /usr/local/old_mysql
rm -rf /usr/local/mysql
cp mysql-5.0.45-linux-i686-glibc23 /usr/local/mysql
重新啟動 Mysql，沒有出現 gbk 的報錯

繼續修改 /etc/my.cnf 的參數配置，將 default-character-set=gbk 增加在如下位置
[client]
default-character-set=gbk
[mysqld]
default-character-set=gbk
重新啟動 Mysql
/etc/rc.d/init.d/mysqld restart
登錄 Mysql
/usr/local/mysql/bin/mysql -uroot -p******
mysql SHOW VARIABLES LIKE char%
+————————–+—————————————-+
| Variable_name | Value |
+————————–+—————————————-+
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_database | gbk |
| character_set_filesystem | binary |
| character_set_results | gbk |
| character_set_server | gbk |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/mysql/share/mysql/charsets/ |
+————————–+—————————————-+
8 rows in set (0.01 sec)
如上圖所示改成所需字符類型 gbk
[root@app bin]# /usr/local/mysql/bin/mysqlshow -uroot -p******
[root@app bin]# /usr/local/mysql/bin/mysqlcheck -A -uroot -p******
3.3.1 轉移 mysql 數據，先從舊庫導出成 *.sql, 然后導入到新庫
[root@house ~]# /usr/local/mysql/bin/mysqldump -uroot -p****** db1 /opt/db1_bakup.20080304.sql
[root@house ~]# /usr/local/mysql/bin/mysqldump -uroot -p****** db2 /opt/db2_bakup.20080304.sql

[root@house ~]# /usr/local/mysql/bin/mysql -uroot -p****** db1 /opt/db1_bakup.20080304.sql
[root@house ~]# /usr/local/mysql/bin/mysql -uroot -p****** db2 /opt/db2_bakup.20080304.sql

3.4 安裝 Apache-2.2.4
cd /tmp
tar xvfz httpd-2.2.4.tar.gz
cd /httpd-2.2.4
./configure –prefix=/usr/local/apache2 –enable-module=so –enable-module=rewrite –enable-shared=max
– 啟動 apache
/usr/local/apache2/bin/apachectl start
– 關閉 apache
/usr/local/apache2/bin/apachectl stop

3.5 安裝 php-4.4.7
cd /tmp
tar xvfz php-4.4.7.tar.gz
cd / php-4.4.7
[root@app php-4.4.7]# ./configure –prefix=/usr/local/php –with-mysql=/usr/local/mysql –enable-force-cgi-redirect –with-freetype-dir=/usr –with-png-

dir=/usr –with-gd –enable-gd-native-ttf –with-ttf –with-gdbm –with-gettext –with-iconv –with-jpeg-dir=/usr –with-png –with-zlib –with-xml —

enable-calendar –with-apxs2=/usr/local/apache2/bin/apxs
make
make install
3.5.1 配置 php.ini
/usr/local/php/lib/php.ini

到此，關于“Linux+Apache2+Mysql+Php 的安裝配置方法”的學習就結束了，希望能夠解決大家的疑惑。理論與實踐的搭配能更好的幫助大家學習，快去試試吧！若想繼續學習更多相關知識，請繼續關注丸趣 TV 網站，丸趣 TV 小編會繼續努力為大家帶來更多實用的文章！

正文完