LAMP

From KevinWiki

Revision as of 08:36, 3 April 2009 (view source) Kevin (Talk | contribs) m ← Older edit		Revision as of 06:13, 10 April 2009 (view source) Kevin (Talk | contribs) Newer edit →
Line 56:		Line 56:
	$ apt-get install phpmyadmin		$ apt-get install phpmyadmin
	</pre>		</pre>
		+
		+	*To make it always use SSL, open the <code>phpmyadmin.conf</code> file in the <code>/etc/apache2/conf.d</code> directory and add <code>SSLRequireSSL</code>.
		+	e.g.)
		+	<Directory /usr/share/phpmyadmin>
		+	Options Indexes FollowSymLinks
		+	DirectoryIndex index.php
		+
		+	'''SSLRequireSSL'''
		+
		+	......
		+	</Directory>

---

Revision as of 06:13, 10 April 2009

APM in web application development normally stands for 'Apache Web Server, PHP and MySQL.'

This instruction is for Ubuntu Linux 8.04 (possibly other versions). It may work for other Linux distributions or may not. This document only has the essential information to install those software packages so for details please see other documents which have the details such as how to configure and use.

Contents 1 Install Apache Web Server 2 Install MySQL Database 2.1 Change Charset 3 Install PHP module for Apache 3.1 Install GD Graphics Library (Optional) 4 Install PHPMyAdmin

Install Apache Web Server

$ sudo apt-get install apache2 

Install MySQL Database

$ sudo apt-get install mysql-server 

Change Charset

-modify /etc/mysql/my.cnf file (add default-character-set=utf8)

user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
language        = /usr/share/mysql/english
default-character-set=utf8
skip-external-locking

...

[mysql]
#no-auto-rehash # faster start of mysql but no tab completion
default-character-set=utf8

Install PHP module for Apache

$ sudo apt-get install php5 libapache2-mod-php5 

Install GD Graphics Library (Optional)

$ sudo apt-get install php5-gd 

Install PHPMyAdmin

$ apt-get install phpmyadmin 

• To make it always use SSL, open the phpmyadmin.conf file in the /etc/apache2/conf.d directory and add SSLRequireSSL.

e.g.)

<Directory /usr/share/phpmyadmin>
        Options Indexes FollowSymLinks
        DirectoryIndex index.php

        SSLRequireSSL

       ......
</Directory>