這篇文章主要介紹“Linux+Apache2+Mysql+Php的安裝配置方法”,在日常操作中,相信很多人在Linux+Apache2+Mysql+Php的安裝配置方法問題上存在疑惑,小編查閱了各式資料,整理出簡單好用的操作方法,希望對大家解答”Linux+Apache2+Mysql+Php的安裝配置方法”的疑惑有所幫助!接下來,請跟著小編一起來學(xué)習(xí)吧!
成都創(chuàng)新互聯(lián)公司網(wǎng)絡(luò)公司擁有十載的成都網(wǎng)站開發(fā)建設(shè)經(jīng)驗,上千家客戶的共同信賴。提供成都網(wǎng)站設(shè)計、成都做網(wǎng)站、外貿(mào)網(wǎng)站建設(shè)、網(wǎng)站開發(fā)、網(wǎng)站定制、賣鏈接、建網(wǎng)站、網(wǎng)站搭建、響應(yīng)式網(wǎng)站建設(shè)、網(wǎng)頁設(shè)計師打造企業(yè)風(fēng)格,提供周到的售前咨詢和貼心的售后服務(wù)在此Linux下全新安裝配置Mysql、Apache2、PHP,解決在安裝Mysql時出現(xiàn)的報錯: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的相關(guān)安裝配置信息說明/usr/local/mysql/info/mysql.info
[@more@]
在此Linux下全新安裝配置Mysql、Apache2、PHP,解決在安裝Mysql時出現(xiàn)的報錯: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的相關(guān)安裝配置信息說明/usr/local/mysql/info/mysql.info
############################################
1.檢查系統(tǒng)及內(nèi)核狀態(tài)
[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操作系統(tǒng)位數(shù)
[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.準(zhǔn)備好安裝包
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.進(jìn)行安裝配置
3.1檢查系統(tǒng)是否已經(jīng)安裝相應(yīng)的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打頭的信息,則說明沒有安裝.如果已經(jīng)安裝,則可以直接使用或更換新版本
卸載方法:
# rpm -e mysql-xxxxxx
# rpm -e httpd-xxxxxx
# rpm -e php-xxxxxx
遇到依賴性問題而無法卸載,可以使用--nodeps或—force強(qiáng)制卸載.不過最好慎用.
rpm -e --nodeps httpd
rpm -e --nodeps php
3.2進(jìn)行安裝
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 進(jìn)行編譯安裝
#prefix=/usr/local/mysql mysql安裝的目標(biāo)目錄
#sysconfdir=/etc my.cnf配置文件的路徑
#localstatedir=/var/lib/mysql 數(shù)據(jù)庫存放的路徑
安裝完以后要初始化數(shù)據(jù)庫,當(dāng)然你是升級的話不用做這步;
/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進(jìn)行測試
/etc/rc.d/init.d/mysqld status
/etc/rc.d/init.d/mysqld start
如果大家還是不能啟動不了的話,那就用我的比較繁瑣的權(quán)限的設(shè)置,反正我每次都是這么做的,一般不會有問題,見下:
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
其下可能還有如下錯誤出現(xiàn)
/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/)
現(xiàn)在找到該解決辦法是打mysql-5.0.45-linux-i686-glibc23.tar.gz補(bǔ)丁包
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,沒有出現(xiàn)gbk的報錯
繼續(xù)修改/etc/my.cnf的參數(shù)配置,將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轉(zhuǎn)移mysql數(shù)據(jù),先從舊庫導(dǎo)出成*.sql,然后導(dǎo)入到新庫
[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
--關(guān)閉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
到此,關(guān)于“Linux+Apache2+Mysql+Php的安裝配置方法”的學(xué)習(xí)就結(jié)束了,希望能夠解決大家的疑惑。理論與實踐的搭配能更好的幫助大家學(xué)習(xí),快去試試吧!若想繼續(xù)學(xué)習(xí)更多相關(guān)知識,請繼續(xù)關(guān)注創(chuàng)新互聯(lián)-成都網(wǎng)站建設(shè)公司網(wǎng)站,小編會繼續(xù)努力為大家?guī)砀鄬嵱玫奈恼拢?/p>
文章題目:Linux+Apache2+Mysql+Php的安裝配置方法-創(chuàng)新互聯(lián)
當(dāng)前鏈接:http://muchs.cn/article48/iodhp.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供網(wǎng)站營銷、外貿(mào)建站、動態(tài)網(wǎng)站、云服務(wù)器、微信小程序、App設(shè)計
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請盡快告知,我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場,如需處理請聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時需注明來源: 創(chuàng)新互聯(lián)
猜你還喜歡下面的內(nèi)容