How To Set Up A Ubuntu/Debian LAMP Server

A man providing IT consulting services at a desk adorned with a laptop and a cactus.

Build Your Own Debian/Ubuntu LAMP Server – Quick & Easy Do it Yourself Installation

    • Apache 2 – Linux Web server
    • MySQL 5 – MySQL Database Server
    • PHP4/5 – PHP Scripting Language
    • phpMyAdmin – Web-based database admin software.

Note: Linux + Apache + MySQL + PHP/Perl together commonly known as LAMP Server.

First, let us prepare a system that has a minimum requirement of Debian/Ubuntu version of Linux with at least 256MB of RAM available. Anything less than this minimum ram will cause lot of problems since we are running a server along especially MySQL and Webmin requires lots of RAM to run properly. MySQL will give you this nasty error “cannot connect to mysql.sock” if you don’t have enough memory in your server.

I love Debian/Ubuntu based Linux because of my enormous affinity towards this command apt-get. As a starter knowing this one command, It is so easy to install packages and you don’t need to worry about package dependency and configuration. You need to buy a dedicated server or a VPS package if you want to setup your own server. If you want to experiment with the server and installation it is recommended to buy a VPS package. Believe it or not it is so easy to install and configure your server yourself even though you are new are to Linux and dedicated/VPS hosting.

First download PuTTy if you are accessing your server through SSH. Just enter the IP of your server with root login to access your host. As you probably know, Webmin is a freely available server control panel and we will setup this once we have completed the LAMP server and Mail Server. Webmin makes more easier for us to fine tune our Linux box.

Before proceeding to install, update the necessary packages with Debian with this command.

apt-get install update

1. Installing Apache + PHP

Apache is one of the most famous web server which runs on most Linux based servers. With just few commands you can configure apache to run with PHP 4 or PHP 5.

If you want to install PHP 4, just apt-get

apt-get install apache2 php4 libapache2-mod-php4

To install PHP5, just run the following on Linux shell. Note that if you don’t specify packages with ‘4’, PHP5 will be automatically installed.

apt-get install apache2 php5 libapache2-mod-php5

Apache configuration file is located at: /etc/apache2/apache2.conf and your web folder is /var/www.

To check whether php is installed and running properly, just create a test.php in your /var/www folder with phpinfo() function exactly as shown below.

vi /var/www/test.php

# test.php

PHP Version 5.6.40

System

Windows NT AKURA-PC 6.1 build 7601 (Windows 7 Professional Edition Service Pack 1) i586
Build Date Jan 9 2019 15:05:35
Compiler MSVC11 (Visual C++ 2012)
Architecture x86
Configure Command cscript /nologo configure.js “–enable-snapshot-build” “–disable-isapi” “–enable-debug-pack” “–without-mssql” “–without-pdo-mssql” “–without-pi3web” “–with-pdo-oci=c:php-sdkoraclex86instantclient_12_1sdk,shared” “–with-oci8-12c=c:php-sdkoraclex86instantclient_12_1sdk,shared” “–enable-object-out-dir=../obj/” “–enable-com-dotnet=shared” “–with-mcrypt=static” “–without-analyzer” “–with-pgo”
Server API Apache 2.0 Handler
Virtual Directory Support enabled
Configuration File (php.ini) Path C:Windows
Loaded Configuration File C:xamppphpphp.ini
Scan this dir for additional .ini files (none)
Additional .ini files parsed (none)
PHP API 20131106
PHP Extension 20131226
Zend Extension 220131226
Zend Extension Build API220131226,TS,VC11
PHP Extension Build API20131226,TS,VC11
Debug Build no
Thread Safety enabled
Zend Signal Handling disabled
Zend Memory Manager enabled
Zend Multibyte Support provided by mbstring
IPv6 Support enabled
DTrace Support disabled
Registered PHP Streams php, file, glob, data, http, ftp, zip, compress.zlib, compress.bzip2, https, ftps, phar
Registered Stream Socket Transports tcp, udp, ssl, sslv3, tls, tlsv1.0, tlsv1.1, tlsv1.2
Registered Stream Filters convert.iconv.*, mcrypt.*, mdecrypt.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, zlib.*, bzip2.*
This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies

Configuration

apache2handler

Apache Version Apache/2.4.37 (Win32) OpenSSL/1.0.2p PHP/5.6.40
Apache API Version 20120211
Server Administrator postmaster@localhost
Hostname:Port localhost:80
Max Requests Per Child: 0 – Keep Alive: on – Max Per Connection: 100
Timeouts Connection: 300 – Keep-Alive: 5
Virtual Server No
Server Root C:/xampp/apache
Loaded Modules core mod_win32 mpm_winnt http_core mod_so mod_access_compat mod_actions mod_alias mod_allowmethods mod_asis mod_auth_basic mod_authn_core mod_authn_file mod_authz_core mod_authz_groupfile mod_authz_host mod_authz_user mod_autoindex mod_cgi mod_dav_lock mod_dir mod_env mod_headers mod_include mod_info mod_isapi mod_log_config mod_cache_disk mod_mime mod_negotiation mod_proxy mod_proxy_ajp mod_rewrite mod_setenvif mod_socache_shmcb mod_ssl mod_status mod_version mod_php5
Directive Local Value Master Value
engine 1 1
last_modified 0 0
xbithack 0 0

Apache Environment

Variable Value
REDIRECT_HTTP_AUTHORIZATION no value
REDIRECT_MIBDIRS C:/xampp/php/extras/mibs
REDIRECT_MYSQL_HOME xamppmysqlbin
REDIRECT_OPENSSL_CONF C:/xampp/apache/bin/openssl.cnf
REDIRECT_PHP_PEAR_SYSCONF_DIR xamppphp
REDIRECT_PHPRC xamppphp
REDIRECT_TMP xampptmp
REDIRECT_STATUS 200
HTTP_AUTHORIZATION no value
MIBDIRS C:/xampp/php/extras/mibs
MYSQL_HOME xamppmysqlbin
OPENSSL_CONF C:/xampp/apache/bin/openssl.cnf
PHP_PEAR_SYSCONF_DIR xamppphp
PHPRC xamppphp
TMP xampptmp
HTTP_HOST localhost
HTTP_CONNECTION keep-alive
HTTP_UPGRADE_INSECURE_REQUESTS 1
HTTP_USER_AGENT Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/72.0.3626.121 Safari/537.36
HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8
HTTP_REFERER http://localhost/fiverr/news?start=100
HTTP_ACCEPT_ENCODING gzip, deflate, br
HTTP_ACCEPT_LANGUAGE pt-PT,pt;q=0.9,en-US;q=0.8,en;q=0.7
HTTP_COOKIE PHPSESSID=j1dtqpt1g2k9uqfcfqslj8k636; dff6d4b72e4def426a87277bd6d670d6=jpv39q1mhq8ntcv40gj8nusi21; __utmc=111872281; __utmz=111872281.1550529012.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); _ga=GA1.1.1162658711.1550529011; __utma=111872281.1162658711.1550529011.1553044102.1553163706.3; _gid=GA1.1.1424351185.1553163707; b4aa41ef44f2facba6f8066beaeeab03=98fq1d1jl4o5nsru8keh690rb1; __utmt=1; __utmb=111872281.13.10.1553163706; __atuvc=6%7C12; __atuvs=5c9369b63df1b0e5005
PATH C:Windowssystem32;C:Windows;C:WindowsSystem32Wbem;C:WindowsSystem32WindowsPowerShellv1.0
SystemRoot C:Windows
COMSPEC C:Windowssystem32cmd.exe
PATHEXT .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
WINDIR C:Windows
SERVER_SIGNATURE <address>Apache/2.4.37 (Win32) OpenSSL/1.0.2p PHP/5.6.40 Server at localhost Port 80</address>
SERVER_SOFTWARE Apache/2.4.37 (Win32) OpenSSL/1.0.2p PHP/5.6.40
SERVER_NAME localhost
SERVER_ADDR ::1
SERVER_PORT 80
REMOTE_ADDR ::1
DOCUMENT_ROOT C:/xampp/htdocs
REQUEST_SCHEME http
CONTEXT_PREFIX no value
CONTEXT_DOCUMENT_ROOT C:/xampp/htdocs
SERVER_ADMIN postmaster@localhost
SCRIPT_FILENAME C:/xampp/htdocs/fiverr/index.php
REMOTE_PORT 61743
REDIRECT_URL /fiverr/news/how-to-set-up-a-ubuntu-debian-lamp-server
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING no value
REQUEST_URI /fiverr/news/how-to-set-up-a-ubuntu-debian-lamp-server
SCRIPT_NAME /fiverr/index.php

HTTP Headers Information

HTTP Request Headers
HTTP Request GET /fiverr/news/how-to-set-up-a-ubuntu-debian-lamp-server HTTP/1.1
Host localhost
Connection keep-alive
Upgrade-Insecure-Requests 1
User-Agent Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/72.0.3626.121 Safari/537.36
Accept text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8
Referer http://localhost/fiverr/news?start=100
Accept-Encoding gzip, deflate, br
Accept-Language pt-PT,pt;q=0.9,en-US;q=0.8,en;q=0.7
Cookie PHPSESSID=j1dtqpt1g2k9uqfcfqslj8k636; dff6d4b72e4def426a87277bd6d670d6=jpv39q1mhq8ntcv40gj8nusi21; __utmc=111872281; __utmz=111872281.1550529012.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); _ga=GA1.1.1162658711.1550529011; __utma=111872281.1162658711.1550529011.1553044102.1553163706.3; _gid=GA1.1.1424351185.1553163707; b4aa41ef44f2facba6f8066beaeeab03=98fq1d1jl4o5nsru8keh690rb1; __utmt=1; __utmb=111872281.13.10.1553163706; __atuvc=6%7C12; __atuvs=5c9369b63df1b0e5005
HTTP Response Headers
X-Powered-By PHP/5.6.40

bcmath

BCMath support enabled
Directive Local Value Master Value
bcmath.scale 0 0

bz2

BZip2 Support Enabled
Stream Wrapper support compress.bzip2://
Stream Filter support bzip2.decompress, bzip2.compress
BZip2 Version 1.0.6, 6-Sept-2010

calendar

Calendar support enabled

Core

PHP Version 5.6.40
Directive Local Value Master Value
allow_url_fopen On On
allow_url_include Off Off
always_populate_raw_post_data 0 0
arg_separator.input & &
arg_separator.output & &
asp_tags Off Off
auto_append_file no value no value
auto_globals_jit On On
auto_prepend_file no value no value
browscap C:xamppphpextrasbrowscap.ini C:xamppphpextrasbrowscap.ini
default_charset UTF-8 UTF-8
default_mimetype text/html text/html
disable_classes no value no value
disable_functions no value no value
display_errors On On
display_startup_errors On On
doc_root no value no value
docref_ext no value no value
docref_root no value no value
enable_dl Off Off
enable_post_data_reading On On
error_append_string no value no value
error_log C:xamppphplogsphp_error_log C:xamppphplogsphp_error_log
error_prepend_string no value no value
error_reporting 0 22527
exit_on_timeout Off Off
expose_php On On
extension_dir C:xamppphpext C:xamppphpext
file_uploads On On
highlight.comment #FF8000 #FF8000
highlight.default #0000BB #0000BB
highlight.html #000000 #000000
highlight.keyword #007700 #007700
highlight.string #DD0000 #DD0000
html_errors On On
ignore_repeated_errors Off Off
ignore_repeated_source Off Off
ignore_user_abort Off Off
implicit_flush Off Off
include_path C:xamppphpPEAR C:xamppphpPEAR
input_encoding no value no value
internal_encoding no value no value
log_errors On On
log_errors_max_len 1024 1024
mail.add_x_header On On
mail.force_extra_parameters no value no value
mail.log no value no value
max_execution_time 30 30
max_file_uploads 20 20
max_input_nesting_level 64 64
max_input_time 60 60
max_input_vars 1000 1000
memory_limit 128M 128M
open_basedir no value no value
output_buffering 4096 4096
output_encoding no value no value
output_handler no value no value
post_max_size 8M 8M
precision 14 14
realpath_cache_size 16K 16K
realpath_cache_ttl 120 120
register_argc_argv Off Off
report_memleaks On On
report_zend_debug On On
request_order GP GP
sendmail_from no value no value
sendmail_path no value no value
serialize_precision 17 17
short_open_tag Off Off
SMTP localhost localhost
smtp_port 25 25
sql.safe_mode Off Off
sys_temp_dir no value no value
track_errors Off Off
unserialize_callback_func no value no value
upload_max_filesize 2M 2M
upload_tmp_dir C:xampptmp C:xampptmp
user_dir no value no value
user_ini.cache_ttl 300 300
user_ini.filename .user.ini .user.ini
variables_order GPCS GPCS
windows.show_crt_warning Off Off
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
zend.detect_unicode On On
zend.enable_gc On On
zend.multibyte Off Off
zend.script_encoding no value no value

ctype

ctype functions enabled

curl

cURL support enabled
cURL Information 7.59.0
Age 4
Features
AsynchDNS Yes
CharConv No
Debug No
GSS-Negotiate No
IDN Yes
IPv6 Yes
krb4 No
Largefile Yes
libz Yes
NTLM Yes
NTLMWB No
SPNEGO Yes
SSL Yes
SSPI Yes
TLS-SRP No
Protocols dict, file, ftp, ftps, gopher, http, https, imap, imaps, ldap, pop3, pop3s, rtsp, scp, sftp, smb, smbs, smtp, smtps, telnet, tftp
Host i386-pc-win32
SSL Version OpenSSL/1.0.2p
ZLib Version 1.2.7.3
libSSH Version libssh2/1.8.0

date

date/time support enabled
“Olson” Timezone Database Version 2016.10
Timezone Database internal
Default timezone Europe/Berlin
Directive Local Value Master Value
date.default_latitude 31.7667 31.7667
date.default_longitude 35.2333 35.2333
date.sunrise_zenith 90.583333 90.583333
date.sunset_zenith 90.583333 90.583333
date.timezone Europe/Berlin Europe/Berlin

dom

DOM/XML enabled
DOM/XML API Version 20031129
libxml Version 2.9.4
HTML Support enabled
XPath Support enabled
XPointer Support enabled
Schema Support enabled
RelaxNG Support enabled

ereg

Regex Library Bundled library enabled

exif

EXIF Support enabled
EXIF Version 1.4 $Id: cad29b729548e4206f0697710cc9e177f26fdff3 $
Supported EXIF Version 0220
Supported filetypes JPEG,TIFF
Directive Local Value Master Value
exif.decode_jis_intel JIS JIS
exif.decode_jis_motorola JIS JIS
exif.decode_unicode_intel UCS-2LE UCS-2LE
exif.decode_unicode_motorola UCS-2BE UCS-2BE
exif.encode_jis no value no value
exif.encode_unicode ISO-8859-15 ISO-8859-15

fileinfo

fileinfo support enabled
version 1.0.5
libmagic 517

filter

Input Validation and Filtering enabled
Revision $Id: 5b79667bd9a68977a9b4f7505223a8e216e04908 $
Directive Local Value Master Value
filter.default unsafe_raw unsafe_raw
filter.default_flags no value no value

ftp

FTP support enabled

gd

GD Support enabled
GD Version bundled (2.1.0 compatible)
FreeType Support enabled
FreeType Linkage with freetype
FreeType Version 2.7.0
GIF Read Support enabled
GIF Create Support enabled
JPEG Support enabled
libJPEG Version 9 compatible
PNG Support enabled
libPNG Version 1.5.26
WBMP Support enabled
XPM Support enabled
libXpm Version 30512
XBM Support enabled
WebP Support enabled
Directive Local Value Master Value
gd.jpeg_ignore_warning 0 0

gettext

GetText Support enabled

hash

hash support enabled
Hashing Engines md2 md4 md5 sha1 sha224 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost gost-crypto adler32 crc32 crc32b fnv132 fnv1a32 fnv164 fnv1a64 joaat haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5

iconv

iconv support enabled
iconv implementation “libiconv”
iconv library version 1.14
Directive Local Value Master Value
iconv.input_encoding no value no value
iconv.internal_encoding no value no value
iconv.output_encoding no value no value

json

json support enabled
json version 1.2.1

libxml

libXML support active
libXML Compiled Version 2.9.4
libXML Loaded Version 20904
libXML streams enabled

mbstring

Multibyte Support enabled
Multibyte string engine libmbfl
HTTP input encoding translation disabled
libmbfl version 1.3.2
mbstring extension makes use of “streamable kanji code filter and converter”, which is distributed under the GNU Lesser General Public License version 2.1.
Multibyte (japanese) regex support enabled
Multibyte regex (oniguruma) version 5.9.5
Directive Local Value Master Value
mbstring.detect_order no value no value
mbstring.encoding_translation Off Off
mbstring.func_overload 0 0
mbstring.http_input no value no value
mbstring.http_output no value no value
mbstring.http_output_conv_mimetypes ^(text/|application/xhtml+xml) ^(text/|application/xhtml+xml)
mbstring.internal_encoding no value no value
mbstring.language neutral neutral
mbstring.strict_detection Off Off
mbstring.substitute_character no value no value

mcrypt

mcrypt support enabled
mcrypt_filter support enabled
Version 2.5.8
Api No 20021217
Supported ciphers cast-128 gost rijndael-128 twofish cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes arcfour
Supported modes cbc cfb ctr ecb ncfb nofb ofb stream
Directive Local Value Master Value
mcrypt.algorithms_dir no value no value
mcrypt.modes_dir no value no value

mhash

MHASH support Enabled
MHASH API Version Emulated Support

mysql

MySQL Support enabled
Active Persistent Links 0
Active Links 1
Client API version mysqlnd 5.0.11-dev – 20120503 – $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
Directive Local Value Master Value
mysql.allow_local_infile On On
mysql.allow_persistent On On
mysql.connect_timeout 3 3
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port 3306 3306
mysql.default_socket MySQL MySQL
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off

mysqli

MysqlI Support enabled
Client API library version mysqlnd 5.0.11-dev – 20120503 – $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
Active Persistent Links 0
Inactive Persistent Links 0
Active Links 0
Directive Local Value Master Value
mysqli.allow_local_infile On On
mysqli.allow_persistent On On
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.max_persistent Unlimited Unlimited
mysqli.reconnect Off Off
mysqli.rollback_on_cached_plink Off Off

mysqlnd

mysqlnd enabled
Version mysqlnd 5.0.11-dev – 20120503 – $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
Compression supported
core SSL supported
extended SSL not supported
Command buffer size 4096
Read buffer size 32768
Read timeout 31536000
Collecting statistics Yes
Collecting memory statistics Yes
Tracing n/a
Loaded plugins mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password
API Extensions mysql,mysqli,pdo_mysql
mysqlnd statistics
bytes_sent 23440949
bytes_received 22423355
packets_sent 37402
packets_received 178992
protocol_overhead_in 715968
protocol_overhead_out 149608
bytes_received_ok_packet 0
bytes_received_eof_packet 0
bytes_received_rset_header_packet 128592
bytes_received_rset_field_meta_packet 0
bytes_received_rset_row_packet 150824
bytes_received_prepare_response_packet 5242782
bytes_received_change_user_packet 16777941
packets_sent_command 18214
packets_received_ok 0
packets_received_eof 0
packets_received_rset_header 14288
packets_received_rset_field_meta 0
packets_received_rset_row 17387
packets_received_prepare_response 68370
packets_received_change_user 77675
result_set_queries 14245
non_result_set_queries 2911
no_index_used 3713
bad_index_used 10
slow_queries 0
buffered_sets 14245
unbuffered_sets 0
ps_buffered_sets 0
ps_unbuffered_sets 0
flushed_normal_sets 0
flushed_ps_sets 0
ps_prepared_never_executed 0
ps_prepared_once_executed 0
rows_fetched_from_server_normal 63430
rows_fetched_from_server_ps 0
rows_buffered_from_client_normal 63430
rows_buffered_from_client_ps 0
rows_fetched_from_client_normal_buffered 63401
rows_fetched_from_client_normal_unbuffered 0
rows_fetched_from_client_ps_buffered 0
rows_fetched_from_client_ps_unbuffered 0
rows_fetched_from_client_ps_cursor 0
rows_affected_normal 62759
rows_affected_ps 0
rows_skipped_normal 63430
rows_skipped_ps 0
copy_on_write_saved 56285
copy_on_write_performed 184385
command_buffer_too_small 401
connect_success 444
connect_failure 0
connection_reused 0
reconnect 0
pconnect_success 399
active_connections 18446744073709551174
active_persistent_connections 18446744073709551217
explicit_close 443
implicit_close 0
disconnect_close 0
in_middle_of_command_close 0
explicit_free_result 14245
implicit_free_result 0
explicit_stmt_close 0
implicit_stmt_close 0
mem_emalloc_count 63545
mem_emalloc_amount 24480383
mem_ecalloc_count 109760
mem_ecalloc_amount 39705560
mem_erealloc_count 32882
mem_erealloc_amount 6212220
mem_efree_count 174743
mem_efree_amount 64412771
mem_malloc_count 124952
mem_malloc_amount 241502910
mem_calloc_count 73201
mem_calloc_amount 9711668
mem_realloc_count 0
mem_realloc_amount 0
mem_free_count 202602
mem_free_amount 251284467
mem_estrndup_count 695
mem_strndup_count 1824
mem_estndup_count 759
mem_strdup_count 2625
proto_text_fetched_null 0
proto_text_fetched_bit 0
proto_text_fetched_tinyint 16707
proto_text_fetched_short 1
proto_text_fetched_int24 0
proto_text_fetched_int 14497
proto_text_fetched_bigint 32571
proto_text_fetched_decimal 87
proto_text_fetched_float 0
proto_text_fetched_double 0
proto_text_fetched_date 0
proto_text_fetched_year 0
proto_text_fetched_time 0
proto_text_fetched_datetime 9712
proto_text_fetched_timestamp 0
proto_text_fetched_string 105729
proto_text_fetched_blob 0
proto_text_fetched_enum 54151
proto_text_fetched_set 0
proto_text_fetched_geometry 0
proto_text_fetched_other 0
proto_binary_fetched_null 0
proto_binary_fetched_bit 0
proto_binary_fetched_tinyint 0
proto_binary_fetched_short 0
proto_binary_fetched_int24 0
proto_binary_fetched_int 0
proto_binary_fetched_bigint 0
proto_binary_fetched_decimal 0
proto_binary_fetched_float 0
proto_binary_fetched_double 0
proto_binary_fetched_date 0
proto_binary_fetched_year 0
proto_binary_fetched_time 0
proto_binary_fetched_datetime 0
proto_binary_fetched_timestamp 0
proto_binary_fetched_string 0
proto_binary_fetched_json 0
proto_binary_fetched_blob 0
proto_binary_fetched_enum 0
proto_binary_fetched_set 0
proto_binary_fetched_geometry 0
proto_binary_fetched_other 0
init_command_executed_count 2
init_command_failed_count 0
com_quit 443
com_init_db 341
com_query 17387
com_field_list 0
com_create_db 0
com_drop_db 0
com_refresh 0
com_shutdown 0
com_statistics 0
com_process_info 0
com_connect 0
com_process_kill 0
com_debug 0
com_ping 0
com_time 0
com_delayed_insert 0
com_change_user 0
com_binlog_dump 0
com_table_dump 0
com_connect_out 0
com_register_slave 0
com_stmt_prepare 0
com_stmt_execute 0
com_stmt_send_long_data 0
com_stmt_close 0
com_stmt_reset 0
com_stmt_set_option 43
com_stmt_fetch 0
com_deamon 0
bytes_received_real_data_normal 16218462
bytes_received_real_data_ps 0

odbc

ODBC Support enabled
Active Persistent Links 0
Active Links 0
ODBC library Win32
Directive Local Value Master Value
odbc.allow_persistent On On
odbc.check_persistent On On
odbc.default_cursortype Static cursor Static cursor
odbc.default_db no value no value
odbc.default_pw no value no value
odbc.default_user no value no value
odbc.defaultbinmode return as is return as is
odbc.defaultlrl return up to 4096 bytes return up to 4096 bytes
odbc.max_links Unlimited Unlimited
odbc.max_persistent Unlimited Unlimited

openssl

OpenSSL support enabled
OpenSSL Library Version OpenSSL 1.0.2p 14 Aug 2018
OpenSSL Header Version OpenSSL 1.0.2q 20 Nov 2018
Openssl default config c:/openssl-1.0.2p-win32/ssl/openssl.cnf
Directive Local Value Master Value
openssl.cafile C:xamppapachebincurl-ca-bundle.crt C:xamppapachebincurl-ca-bundle.crt
openssl.capath no value no value

pcre

PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 8.38 2015-11-23
Directive Local Value Master Value
pcre.backtrack_limit 1000000 1000000
pcre.recursion_limit 100000 100000

PDO

PDO support enabled
PDO drivers mysql, sqlite

pdo_mysql

PDO Driver for MySQL enabled
Client API version mysqlnd 5.0.11-dev – 20120503 – $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $

pdo_sqlite

PDO Driver for SQLite 3.x enabled
SQLite Library 3.8.10.2

Phar

Phar: PHP Archive support enabled
Phar EXT version 2.0.2
Phar API version 1.1.1
SVN revision $Id: 6e5cec2462a6ded53d4379ea9a69487a60d5c43c $
Phar-based phar archives enabled
Tar-based phar archives enabled
ZIP-based phar archives enabled
gzip compression enabled
bzip2 compression enabled
OpenSSL support enabled
Phar based on pear/PHP_Archive, original concept by Davey Shafik.
Phar fully realized by Gregory Beaver and Marcus Boerger.
Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle.
Directive Local Value Master Value
phar.cache_list no value no value
phar.readonly On On
phar.require_hash On On

Reflection

Reflection enabled
Version $Id: 5f15287237d5f78d75b19c26915aa7bd83dee8b8 $

session

Session Support enabled
Registered save handlers files user
Registered serializer handlers php_serialize php php_binary wddx
Directive Local Value Master Value
session.auto_start Off Off
session.cache_expire 180 180
session.cache_limiter none nocache
session.cookie_domain no value no value
session.cookie_httponly On Off
session.cookie_lifetime 0 0
session.cookie_path / /
session.cookie_secure Off Off
session.entropy_file no value no value
session.entropy_length 0 0
session.gc_divisor 1000 1000
session.gc_maxlifetime 900 1440
session.gc_probability 1 1
session.hash_bits_per_character 5 5
session.hash_function 0 0
session.name b4aa41ef44f2facba6f8066beaeeab03 PHPSESSID
session.referer_check no value no value
session.save_handler user files
session.save_path C:xampptmp C:xampptmp
session.serialize_handler php php
session.upload_progress.cleanup On On
session.upload_progress.enabled On On
session.upload_progress.freq 1% 1%
session.upload_progress.min_freq 1 1
session.upload_progress.name PHP_SESSION_UPLOAD_PROGRESS PHP_SESSION_UPLOAD_PROGRESS
session.upload_progress.prefix upload_progress_ upload_progress_
session.use_cookies On On
session.use_only_cookies On On
session.use_strict_mode Off Off
session.use_trans_sid 0 0

SimpleXML

Simplexml support enabled
Revision $Id: d7077fc935154236afb4fe70814ba358efdbdca4 $
Schema support enabled

SPL

SPL support enabled
Interfaces Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
Classes AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, CallbackFilterIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveCallbackFilterIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException

standard

Dynamic Library Support enabled
Internal Sendmail Support for Windows enabled
Directive Local Value Master Value
assert.active 1 1
assert.bail 0 0
assert.callback no value no value
assert.quiet_eval 0 0
assert.warning 1 1
auto_detect_line_endings 0 0
default_socket_timeout 60 60
from no value no value
url_rewriter.tags a=href,area=href,frame=src,input=src,form=fakeentry a=href,area=href,frame=src,input=src,form=fakeentry
user_agent no value no value

tokenizer

Tokenizer Support enabled

wddx

WDDX Support enabled
WDDX Session Serializer enabled

xml

XML Support active
XML Namespace Support active
libxml2 Version 2.9.4

xmlreader

XMLReader enabled

xmlwriter

XMLWriter enabled

zip

Zip enabled
Zip version 1.12.5
Libzip version 0.11.2

zlib

ZLib Support enabled
Stream Wrapper compress.zlib://
Stream Filter zlib.inflate, zlib.deflate
Compiled Version 1.2.7.3
Linked Version 1.2.7.3
Directive Local Value Master Value
zlib.output_compression Off Off
zlib.output_compression_level -1 -1
zlib.output_handler no value no value

Additional Modules

Module Name

Environment

Variable Value
no value ::=::
ALLUSERSPROFILE C:ProgramData
APPDATA C:UsersAkuraAppDataRoaming
CommonProgramFiles C:Program Files (x86)Common Files
CommonProgramFiles(x86) C:Program Files (x86)Common Files
CommonProgramW6432 C:Program FilesCommon Files
COMPUTERNAME AKURA-PC
ComSpec C:Windowssystem32cmd.exe
FP_NO_HOST_CHECK NO
HOMEDRIVE C:
HOMEPATH UsersAkura
LOCALAPPDATA C:UsersAkuraAppDataLocal
LOGONSERVER \AKURA-PC
NUMBER_OF_PROCESSORS 2
OS Windows_NT
Path C:Windowssystem32;C:Windows;C:WindowsSystem32Wbem;C:WindowsSystem32WindowsPowerShellv1.0
PATHEXT .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PROCESSOR_ARCHITECTURE x86
PROCESSOR_ARCHITEW6432 AMD64
PROCESSOR_IDENTIFIER Intel64 Family 6 Model 37 Stepping 5, GenuineIntel
PROCESSOR_LEVEL 6
PROCESSOR_REVISION 2505
ProgramData C:ProgramData
ProgramFiles C:Program Files (x86)
ProgramFiles(x86) C:Program Files (x86)
ProgramW6432 C:Program Files
PSModulePath C:Windowssystem32WindowsPowerShellv1.0Modules
PUBLIC C:UsersPublic
SESSIONNAME Console
SystemDrive C:
SystemRoot C:Windows
TEMP C:UsersAkuraAppDataLocalTemp
TMP C:UsersAkuraAppDataLocalTemp
USERDOMAIN Akura-PC
USERNAME Akura
USERPROFILE C:UsersAkura
windir C:Windows
windows_tracing_flags 3
windows_tracing_logfile C:BVTBinTestsinstallpackagecsilogfile.log
AP_PARENT_PID 4240

PHP Variables

Variable Value
_REQUEST[“Itemid”] 1041
_REQUEST[“option”] com_easyblog
_REQUEST[“id”] 61
_REQUEST[“view”] entry
_COOKIE[“PHPSESSID”] j1dtqpt1g2k9uqfcfqslj8k636
_COOKIE[“dff6d4b72e4def426a87277bd6d670d6”] jpv39q1mhq8ntcv40gj8nusi21
_COOKIE[“__utmc”] 111872281
_COOKIE[“__utmz”] 111872281.1550529012.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)
_COOKIE[“_ga”] GA1.1.1162658711.1550529011
_COOKIE[“__utma”] 111872281.1162658711.1550529011.1553044102.1553163706.3
_COOKIE[“_gid”] GA1.1.1424351185.1553163707
_COOKIE[“b4aa41ef44f2facba6f8066beaeeab03”] 98fq1d1jl4o5nsru8keh690rb1
_COOKIE[“__utmt”] 1
_COOKIE[“__utmb”] 111872281.13.10.1553163706
_COOKIE[“__atuvc”] 6|12
_COOKIE[“__atuvs”] 5c9369b63df1b0e5005
_SERVER[“REDIRECT_HTTP_AUTHORIZATION”] no value
_SERVER[“REDIRECT_MIBDIRS”] C:/xampp/php/extras/mibs
_SERVER[“REDIRECT_MYSQL_HOME”] xamppmysqlbin
_SERVER[“REDIRECT_OPENSSL_CONF”] C:/xampp/apache/bin/openssl.cnf
_SERVER[“REDIRECT_PHP_PEAR_SYSCONF_DIR”] xamppphp
_SERVER[“REDIRECT_PHPRC”] xamppphp
_SERVER[“REDIRECT_TMP”] xampptmp
_SERVER[“REDIRECT_STATUS”] 200
_SERVER[“HTTP_AUTHORIZATION”] no value
_SERVER[“MIBDIRS”] C:/xampp/php/extras/mibs
_SERVER[“MYSQL_HOME”] xamppmysqlbin
_SERVER[“OPENSSL_CONF”] C:/xampp/apache/bin/openssl.cnf
_SERVER[“PHP_PEAR_SYSCONF_DIR”] xamppphp
_SERVER[“PHPRC”] xamppphp
_SERVER[“TMP”] xampptmp
_SERVER[“HTTP_HOST”] localhost
_SERVER[“HTTP_CONNECTION”] keep-alive
_SERVER[“HTTP_UPGRADE_INSECURE_REQUESTS”] 1
_SERVER[“HTTP_USER_AGENT”] Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/72.0.3626.121 Safari/537.36
_SERVER[“HTTP_ACCEPT”] text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8
_SERVER[“HTTP_REFERER”] http://localhost/fiverr/news?start=100
_SERVER[“HTTP_ACCEPT_ENCODING”] gzip, deflate, br
_SERVER[“HTTP_ACCEPT_LANGUAGE”] pt-PT,pt;q=0.9,en-US;q=0.8,en;q=0.7
_SERVER[“HTTP_COOKIE”] PHPSESSID=j1dtqpt1g2k9uqfcfqslj8k636; dff6d4b72e4def426a87277bd6d670d6=jpv39q1mhq8ntcv40gj8nusi21; __utmc=111872281; __utmz=111872281.1550529012.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); _ga=GA1.1.1162658711.1550529011; __utma=111872281.1162658711.1550529011.1553044102.1553163706.3; _gid=GA1.1.1424351185.1553163707; b4aa41ef44f2facba6f8066beaeeab03=98fq1d1jl4o5nsru8keh690rb1; __utmt=1; __utmb=111872281.13.10.1553163706; __atuvc=6%7C12; __atuvs=5c9369b63df1b0e5005
_SERVER[“PATH”] C:Windowssystem32;C:Windows;C:WindowsSystem32Wbem;C:WindowsSystem32WindowsPowerShellv1.0
_SERVER[“SystemRoot”] C:Windows
_SERVER[“COMSPEC”] C:Windowssystem32cmd.exe
_SERVER[“PATHEXT”] .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
_SERVER[“WINDIR”] C:Windows
_SERVER[“SERVER_SIGNATURE”] <address>Apache/2.4.37 (Win32) OpenSSL/1.0.2p PHP/5.6.40 Server at localhost Port 80</address>
_SERVER[“SERVER_SOFTWARE”] Apache/2.4.37 (Win32) OpenSSL/1.0.2p PHP/5.6.40
_SERVER[“SERVER_NAME”] localhost
_SERVER[“SERVER_ADDR”] ::1
_SERVER[“SERVER_PORT”] 80
_SERVER[“REMOTE_ADDR”] ::1
_SERVER[“DOCUMENT_ROOT”] C:/xampp/htdocs
_SERVER[“REQUEST_SCHEME”] http
_SERVER[“CONTEXT_PREFIX”] no value
_SERVER[“CONTEXT_DOCUMENT_ROOT”] C:/xampp/htdocs
_SERVER[“SERVER_ADMIN”] postmaster@localhost
_SERVER[“SCRIPT_FILENAME”] C:/xampp/htdocs/fiverr/index.php
_SERVER[“REMOTE_PORT”] 61743
_SERVER[“REDIRECT_URL”] /fiverr/news/how-to-set-up-a-ubuntu-debian-lamp-server
_SERVER[“GATEWAY_INTERFACE”] CGI/1.1
_SERVER[“SERVER_PROTOCOL”] HTTP/1.1
_SERVER[“REQUEST_METHOD”] GET
_SERVER[“QUERY_STRING”] no value
_SERVER[“REQUEST_URI”] /fiverr/news/how-to-set-up-a-ubuntu-debian-lamp-server
_SERVER[“SCRIPT_NAME”] /fiverr/index.php
_SERVER[“PHP_SELF”] /fiverr/index.php
_SERVER[“REQUEST_TIME_FLOAT”] 1553165508.577
_SERVER[“REQUEST_TIME”] 1553165508

PHP Credits

PHP Group
Thies C. Arntzen, Stig Bakken, Shane Caraveo, Andi Gutmans, Rasmus Lerdorf, Sam Ruby, Sascha Schumann, Zeev Suraski, Jim Winstead, Andrei Zmievski
Language Design & Concept
Andi Gutmans, Rasmus Lerdorf, Zeev Suraski, Marcus Boerger
PHP Authors
Contribution Authors
Zend Scripting Language Engine Andi Gutmans, Zeev Suraski, Stanislav Malyshev, Marcus Boerger, Dmitry Stogov, Xinchen Hui, Nikita Popov
Extension Module API Andi Gutmans, Zeev Suraski, Andrei Zmievski
UNIX Build and Modularization Stig Bakken, Sascha Schumann, Jani Taskinen
Windows Port Shane Caraveo, Zeev Suraski, Wez Furlong, Pierre-Alain Joye, Anatol Belski
Server API (SAPI) Abstraction Layer Andi Gutmans, Shane Caraveo, Zeev Suraski
Streams Abstraction Layer Wez Furlong, Sara Golemon
PHP Data Objects Layer Wez Furlong, Marcus Boerger, Sterling Hughes, George Schlossnagle, Ilia Alshanetsky
Output Handler Zeev Suraski, Thies C. Arntzen, Marcus Boerger, Michael Wallner
SAPI Modules
Contribution Authors
AOLserver Sascha Schumann
Apache 1.3 (apache_hooks) Rasmus Lerdorf, Zeev Suraski, Stig Bakken, David Sklar, George Schlossnagle, Lukas Schroeder
Apache 1.3 Rasmus Lerdorf, Zeev Suraski, Stig Bakken, David Sklar
Apache 2.0 Filter Sascha Schumann, Aaron Bannert
Apache 2.0 Handler Ian Holsman, Justin Erenkrantz (based on Apache 2.0 Filter code)
Caudium / Roxen David Hedbor
CGI / FastCGI Rasmus Lerdorf, Stig Bakken, Shane Caraveo, Dmitry Stogov
CLI Edin Kadribasic, Marcus Boerger, Johannes Schlueter, Moriyoshi Koizumi, Xinchen Hui
Continuity Alex Leigh (based on nsapi code)
Embed Edin Kadribasic
FastCGI Process Manager Andrei Nigmatulin, dreamcat4, Antony Dovgal, Jerome Loyet
ISAPI Andi Gutmans, Zeev Suraski
litespeed George Wang
NSAPI Jayakumar Muthukumarasamy, Uwe Schindler
phpdbg Felipe Pena, Joe Watkins, Bob Weinand
phttpd Thies C. Arntzen
pi3web Holger Zimmermann
Sendmail Milter Harald Radi
thttpd Sascha Schumann
tux Sascha Schumann
WebJames Alex Waugh
Module Authors
Module Authors
BC Math Andi Gutmans
Bzip2 Sterling Hughes
Calendar Shane Caraveo, Colin Viebrock, Hartmut Holzgraefe, Wez Furlong
COM and .Net Wez Furlong
ctype Hartmut Holzgraefe
cURL Sterling Hughes
Date/Time Support Derick Rethans
DB-LIB (MS SQL, Sybase) Wez Furlong, Frank M. Kromann
DBA Sascha Schumann, Marcus Boerger
DOM Christian Stocker, Rob Richards, Marcus Boerger
enchant Pierre-Alain Joye, Ilia Alshanetsky
ereg Rasmus Lerdorf, Jim Winstead, Jaakko Hyvätti
EXIF Rasmus Lerdorf, Marcus Boerger
fileinfo Ilia Alshanetsky, Pierre Alain Joye, Scott MacVicar, Derick Rethans
Firebird driver for PDO Ard Biesheuvel
FTP Stefan Esser, Andrew Skalski
GD imaging Rasmus Lerdorf, Stig Bakken, Jim Winstead, Jouni Ahto, Ilia Alshanetsky, Pierre-Alain Joye, Marcus Boerger
GetText Alex Plotnick
GNU GMP support Stanislav Malyshev
Iconv Rui Hirokawa, Stig Bakken, Moriyoshi Koizumi
IMAP Rex Logan, Mark Musone, Brian Wang, Kaj-Michael Lang, Antoni Pamies Olive, Rasmus Lerdorf, Andrew Skalski, Chuck Hagenbuch, Daniel R Kalowsky
Input Filter Rasmus Lerdorf, Derick Rethans, Pierre-Alain Joye, Ilia Alshanetsky
InterBase Jouni Ahto, Andrew Avdeev, Ard Biesheuvel
Internationalization Ed Batutis, Vladimir Iordanov, Dmitry Lakhtyuk, Stanislav Malyshev, Vadim Savchuk, Kirti Velankar
JSON Omar Kilani, Scott MacVicar
LDAP Amitay Isaacs, Eric Warnke, Rasmus Lerdorf, Gerrit Thomson, Stig Venaas
LIBXML Christian Stocker, Rob Richards, Marcus Boerger, Wez Furlong, Shane Caraveo
mcrypt Sascha Schumann, Derick Rethans
MS SQL Frank M. Kromann
Multibyte String Functions Tsukada Takuya, Rui Hirokawa
MySQL driver for PDO George Schlossnagle, Wez Furlong, Ilia Alshanetsky, Johannes Schlueter
MySQL Zeev Suraski, Zak Greant, Georg Richter, Andrey Hristov
MySQLi Zak Greant, Georg Richter, Andrey Hristov, Ulf Wendel
MySQLnd Andrey Hristov, Ulf Wendel, Georg Richter, Johannes Schlüter
OCI8 Stig Bakken, Thies C. Arntzen, Andy Sautins, David Benson, Maxim Maletsky, Harald Radi, Antony Dovgal, Andi Gutmans, Wez Furlong, Christopher Jones, Oracle Corporation
ODBC driver for PDO Wez Furlong
ODBC Stig Bakken, Andreas Karajannis, Frank M. Kromann, Daniel R. Kalowsky
OpenSSL Stig Venaas, Wez Furlong, Sascha Kettler, Scott MacVicar
Oracle (OCI) driver for PDO Wez Furlong
pcntl Jason Greene, Arnaud Le Blanc
Perl Compatible Regexps Andrei Zmievski
PHP Archive Gregory Beaver, Marcus Boerger
PHP Data Objects Wez Furlong, Marcus Boerger, Sterling Hughes, George Schlossnagle, Ilia Alshanetsky
PHP hash Sara Golemon, Rasmus Lerdorf, Stefan Esser, Michael Wallner, Scott MacVicar
Posix Kristian Koehntopp
PostgreSQL driver for PDO Edin Kadribasic, Ilia Alshanetsky
PostgreSQL Jouni Ahto, Zeev Suraski, Yasuo Ohgaki, Chris Kings-Lynne
Pspell Vlad Krupin
Readline Thies C. Arntzen
Recode Kristian Koehntopp
Reflection Marcus Boerger, Timm Friebe, George Schlossnagle, Andrei Zmievski, Johannes Schlueter
Sessions Sascha Schumann, Andrei Zmievski
Shared Memory Operations Slava Poliakov, Ilia Alshanetsky
SimpleXML Sterling Hughes, Marcus Boerger, Rob Richards
SNMP Rasmus Lerdorf, Harrie Hazewinkel, Mike Jackson, Steven Lawrance, Johann Hanne, Boris Lytochkin
SOAP Brad Lafountain, Shane Caraveo, Dmitry Stogov
Sockets Chris Vandomelen, Sterling Hughes, Daniel Beulshausen, Jason Greene
SPL Marcus Boerger, Etienne Kneuss
SQLite 3.x driver for PDO Wez Furlong
SQLite3 Scott MacVicar, Ilia Alshanetsky, Brad Dewar
Sybase-CT Zeev Suraski, Tom May, Timm Friebe
System V Message based IPC Wez Furlong
System V Semaphores Tom May
System V Shared Memory Christian Cartus
tidy John Coggeshall, Ilia Alshanetsky
tokenizer Andrei Zmievski, Johannes Schlueter
WDDX Andrei Zmievski
XML Stig Bakken, Thies C. Arntzen, Sterling Hughes
XMLReader Rob Richards
xmlrpc Dan Libby
XMLWriter Rob Richards, Pierre-Alain Joye
XSL Christian Stocker, Rob Richards
Zip Pierre-Alain Joye, Remi Collet
Zlib Rasmus Lerdorf, Stefan Roehrich, Zeev Suraski, Jade Nicoletti, Michael Wallner
PHP Documentation
Authors Mehdi Achour, Friedhelm Betz, Antony Dovgal, Nuno Lopes, Hannes Magnusson, Georg Richter, Damien Seguy, Jakub Vrana, Adam Harvey, Peter Cowburn
Editor Philip Olson
User Note Maintainers Daniel P. Brown, Thiago Henrique Pojda
Other Contributors Previously active authors, editors and other contributors are listed in the manual.
PHP Quality Assurance Team
Ilia Alshanetsky, Joerg Behrens, Antony Dovgal, Stefan Esser, Moriyoshi Koizumi, Magnus Maatta, Sebastian Nohn, Derick Rethans, Melvyn Sopacua, Jani Taskinen, Pierre-Alain Joye, Dmitry Stogov, Felipe Pena, David Soria Parra, Stanislav Malyshev, Julien Pauli, Stephen Zarkos, Anatol Belski, Remi Collet, Ferenc Kovacs
Websites and Infrastructure team
PHP Websites Team Rasmus Lerdorf, Hannes Magnusson, Philip Olson, Lukas Kahwe Smith, Pierre-Alain Joye, Kalle Sommer Nielsen, Peter Cowburn, Adam Harvey, Ferenc Kovacs, Levi Morrison
Event Maintainers Damien Seguy, Daniel P. Brown
Network Infrastructure Daniel P. Brown
Windows Infrastructure Alex Schoenmaker

PHP License

This program is free software; you can redistribute it and/or modify it under the terms of the PHP License as published by the PHP Group and included in the distribution in the file: LICENSE

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

If you did not receive a copy of the PHP license, or have any questions about PHP licensing, please contact [email protected].

Point your browser to http://ip.address/test.php or http://domain/test.php and this should show all your php configuration and default settings.

You can edit necessary values or setup virtual domains using apache configuration file.

2. Installing MySQL Database Server

Installing mysql database server is always necessary if you are running a database driven e-commerce site. Remember running MySQL server to a fair extend requires at least 256mb of RAM in your server. So unless you are running database driven sites you don’t absolutely need MySQL. The following commands will install MySQL 5 server and MySQL 5 client.

apt-get install mysql-server mysql-client php5-mysql

Note: If you have already installed php4, you should make a slight change like this.

apt-get install mysql-server mysql-client php4-mysql

The configuration file of MySQL is located at: /etc/mysql/my.cnf

Creating users to use MySQL and Changing Root Password

By default mysql creates user as root and runs with no passport. You might need to change the root password.

To change Root Password

mysql -u root

mysql> USE mysql;

mysql> UPDATE user SET Password=PASSWORD(‘new-password’) WHERE user=’root’;

mysql> FLUSH PRIVILEGES;

You must never use root password, so you might need to create a user to connect to MySQL database for a PHP script. Alternatively you can add users to MySQL database by using a control panel like Webmin or phpMyAdmin to easily create or assign database permission to users. We will install Webmin and phpMyAdmin during later once we complete basic installation.

3. PhpMyAdmin Installation

PhpMyAdmin is a nice web based database management and administration software and easy to install and configure under apache. Managing databases with tables couldn’t be much simpler by using phpMyAdmin.

All you need to do is:

apt-get install phpmyadmin

The phpMyAdmin configuration file is located at: /etc/phpmyadmin folder.

To set up under Apache all you need to do is include the following line in /etc/apache2/apache2.conf:

Include /etc/phpmyadmin/apache.conf

Now restart Apache:

/etc/init.d/apache2 restart

Point your browser to: http://domain/phpmyadmin

That’s it! MySQL and phpMyAdmin are ready. Log in with your mysql root password and create users to connect to database from your php script.

This tutorial was written by Scott who currently runs MySQL-Apache-PHP.com.

What do you think?

Leave a Reply

Related articles

Two business people sitting at a desk in an office.

Integris Health Patients Face Shocking Extortion Emails Following Devastating Cyberattack

Integris Health, an Oklahoma-based healthcare provider, is notifying patients they may receive extortion emails after suffering a cyberattack. The attack targeted the systems of NoMoreClipboard, an online patient portal, affecting 102,000 patients. Cybercriminals are demanding $2,000 in Bitcoin for the return of patient data, including medical records and contact information.

Read more
Contact us

Partner with Us for Comprehensive IT

We’re happy to answer any questions you may have and help you determine which of our services best fit your needs.

Your benefits:
What happens next?
1

We Schedule a call at your convenience 

2

We do a discovery and consulting meting 

3

We prepare a proposal 

Schedule a Free Consultation