LAMP - Revision history

Kevin: /* = Change Charset */

2013-01-01T06:04:58Z

= Change Charset

← Older revision		Revision as of 06:04, 1 January 2013
Line 37:		Line 37:
	#no-auto-rehash # faster start of mysql but no tab completion		#no-auto-rehash # faster start of mysql but no tab completion
	'''default-character-set=utf8'''		'''default-character-set=utf8'''
		+
		+	* For 5.5
		+	[mysqld]
		+	# ...
		+	collation-server = utf8_unicode_ci
		+	init-connect='SET NAMES utf8'
		+	character-set-server = utf8
		+

	-After adding these two lines, the result of the following command		-After adding these two lines, the result of the following command
Line 107:		Line 115:
	+----------------+--------+		+----------------+--------+
	1 row in set (0.00 sec)		1 row in set (0.00 sec)
-

	== Install PHP module for Apache ==		== Install PHP module for Apache ==

Kevin at 08:49, 13 May 2011

2011-05-13T08:49:54Z

← Older revision		Revision as of 08:49, 13 May 2011
Line 15:		Line 15:
	</pre>		</pre>

-	===~~Change Charset~~===	+	=== Configuration ===
-	-~~modify~~ <code>/etc/mysql/my.cnf</code> file (add '''<code>default-character-set=utf8</code>''')	+	-open <code>/etc/mysql/my.cnf</code> file
		+
		+	==== Change Charset ===
		+	-add '''<code>default-character-set=utf8</code>'''

	user = mysql		user = mysql
Line 35:		Line 38:
	'''default-character-set=utf8'''		'''default-character-set=utf8'''

		+	-After adding these two lines, the result of the following command
		+	mysql> show variables like '%character%';
		+	should be changed from
		+	+--------------------------+----------------------------+
		+	\| Variable_name \| Value \|
		+	+--------------------------+----------------------------+
		+	\| character_set_client \| '''latin1''' \|
		+	\| character_set_connection \| '''latin1''' \|
		+	\| character_set_database \| '''latin1''' \|
		+	\| character_set_filesystem \| binary \|
		+	\| character_set_results \| '''latin1''' \|
		+	\| character_set_server \| '''latin1''' \|
		+	\| character_set_system \| utf8 \|
		+	\| character_sets_dir \| /usr/share/mysql/charsets/ \|
		+	+--------------------------+----------------------------+
		+	8 rows in set (0.00 sec)
		+	to
		+	+--------------------------+----------------------------+
		+	\| Variable_name \| Value \|
		+	+--------------------------+----------------------------+
		+	\| character_set_client \| '''utf8''' \|
		+	\| character_set_connection \| '''utf8''' \|
		+	\| character_set_database \| '''utf8''' \|
		+	\| character_set_filesystem \| binary \|
		+	\| character_set_results \| '''utf8''' \|
		+	\| character_set_server \| '''utf8''' \|
		+	\| character_set_system \| utf8 \|
		+	\| character_sets_dir \| /usr/share/mysql/charsets/ \|
		+	+--------------------------+----------------------------+
		+	8 rows in set (0.00 sec)


		+	==== Change Default Database Engine to InnoDB ====
		+	- add '''<code>default-storage-engine</code>'''
		+
		+	# * InnoDB
		+	#
		+	# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
		+	# Read the manual for more InnoDB related options. There are many!
		+	#
		+	# * Security Features
		+	#
		+	# Read the manual, too, if you want chroot!
		+	# chroot = /var/lib/mysql/
		+	#
		+	# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
		+	#
		+	# ssl-ca=/etc/mysql/cacert.pem
		+	# ssl-cert=/etc/mysql/server-cert.pem
		+	# ssl-key=/etc/mysql/server-key.pem
		+
		+	'''default-storage-engine=InnoDB'''

		+	-After changing it, the result of the following command should be changed
		+	mysql> show variables like '%storage_engine%';
		+	from
		+	+----------------+--------+
		+	\| Variable_name \| Value \|
		+	+----------------+--------+
		+	\| storage_engine \| '''MyISAM''' \|
		+	+----------------+--------+
		+	1 row in set (0.00 sec)
		+	to
		+	+----------------+--------+
		+	\| Variable_name \| Value \|
		+	+----------------+--------+
		+	\| storage_engine \| '''InnoDB''' \|
		+	+----------------+--------+
		+	1 row in set (0.00 sec)

Kevin at 06:13, 10 April 2009

2009-04-10T06:13:25Z

← Older revision		Revision as of 06:13, 10 April 2009
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>

Kevin at 08:36, 3 April 2009

2009-04-03T08:36:46Z

← Older revision		Revision as of 08:36, 3 April 2009
Line 6:		Line 6:
	== Install Apache Web Server ==		== Install Apache Web Server ==
	<pre>		<pre>
-	$ sudo apt-get install apache2	+	$ sudo apt-get install apache2
	</pre>		</pre>

Line 12:		Line 12:
	== Install MySQL Database ==		== Install MySQL Database ==
	<pre>		<pre>
-	$ sudo apt-get install mysql-server	+	$ sudo apt-get install mysql-server
	</pre>		</pre>

Line 42:		Line 42:
	== Install PHP module for Apache ==		== Install PHP module for Apache ==
	<pre>		<pre>
-	$ sudo apt-get install php5 libapache2-mod-php5	+	$ sudo apt-get install php5 libapache2-mod-php5
	</pre>		</pre>

Line 54:		Line 54:
	== Install PHPMyAdmin==		== Install PHPMyAdmin==
	<pre>		<pre>
-	$ apt-get install phpmyadmin	+	$ apt-get install phpmyadmin
	</pre>		</pre>

Kevin at 04:55, 8 January 2009

2009-01-08T04:55:44Z

← Older revision		Revision as of 04:55, 8 January 2009
Line 43:		Line 43:
	<pre>		<pre>
	$ sudo apt-get install php5 libapache2-mod-php5		$ sudo apt-get install php5 libapache2-mod-php5
		+	</pre>
		+
		+
		+	===Install GD Graphics Library (Optional)===
		+	<pre>
		+	$ sudo apt-get install php5-gd
	</pre>		</pre>

Kevin at 21:08, 11 October 2008

2008-10-11T21:08:39Z

← Older revision		Revision as of 21:08, 11 October 2008
Line 32:		Line 32:

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

Kevin: New page: Category:Linux APM in web application development normally stands for 'Apache Web Server, PHP and MySQL.' This i...

2008-09-29T06:07:44Z

New page: Category:Linux APM in web application development normally stands for 'Apache Web Server, PHP and MySQL.' This i...

New page

[[Category:Linux]]
APM in web application development normally stands for '[[wikipedia:Apache HTTP Server|Apache Web Server]], [[wikipedia:PHP|PHP]] and [[wikipedia:MySQL|MySQL]].'

This instruction is for [[wikipedia:Ubuntu|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.

== Install Apache Web Server ==
<pre>
$ sudo apt-get install apache2
</pre>

== Install MySQL Database ==
<pre>
$ sudo apt-get install mysql-server
</pre>

===Change Charset===
-modify <code>/etc/mysql/my.cnf</code> file (add '''<code>default-character-set=utf8</code>''')

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 completition
'''default-character-set=utf8'''

== Install PHP module for Apache ==
<pre>
$ sudo apt-get install php5 libapache2-mod-php5
</pre>

== Install PHPMyAdmin==
<pre>
$ apt-get install phpmyadmin
</pre>