Changes

Jump to navigation Jump to search

Mini Servers: Introduction

13,708 bytes added, 14:18, 17 August 2008
m
no edit summary
'''''Note''''' The turbo chargers are a limited edition and slightly under powered, as is the main Apache engine. However these are upgradeable by visiting each manufacture to obtain their latest full production version, these are highly tuned providing maximum raw power.
The mini sever series was sparked off because Uniform Server for whatever reason reminded me of a stretched limo , thought I would chop it up into three minis!Ever taken anything apart only to find after reassembly several parts left over hence the fourth mini server series.
== Mini Servers ==
Everyone seems to want bigger better servers with all those bells and whistles occasionally all I want is a small compact test server that performs one specific task and easily configurable. I never like to use something I neither trust or understand hence hack Uniform Server to meet these needs.
Uniform Server’s basic architecture and Apache cores core make for truly ace compact portable servers. Instead of throwing these away I thought it worthwhile to document and publish them hence this mini server series. In the series I emphasise the need for security don’t take security for granted search the Internet for professional advice and implement.
{|width="100%"
|-align="center"
If you do require full language capability use Uniform Server 3.5-Apollo, transferring from a mini server will not be difficult since they are based on 3.5-Apollo’s architecture. (These servers were tested on Windows XP Home only.)
 
{|align="center"
|-align="center"
|width="200"|
[[Image:Uc_mini_1d.gif|Apache 2.2.9 SSL enabled]]
|width="150"|
'''''Two special editions have been added extending server range'''.''
|width="200"|
[[Image:Uc_mini_4a.gif|MySQL Server]][[Image:Uc_mini_14.gif|MySQL Server]]
|}
'''''[[#top | Top]]'''''
!PHP
!PERL
!Port
!Comments
|-align="center" style="background:#ffffff"
|align="left"|[[Mini Servers: Apache 2.2.9 Portable|UC Server 1a1]]||Portable||456KB451KB||1.03MB1MB||2.2.9|| || ||8081|| 
|-align="center" style="background:#ffffff"
|align="left"|[[Mini Servers: Apache 2.2.9 Service|UC Server 1b2]]||Service||404KB402KB||904KB821KB||2.2.9|| || ||8082|| 
|-align="center" style="background:#ffffff"
|align="left"|[[Mini Servers: Server 1cApache 2.2.9 Portable - Authentication|UC Server 1c3]]||Portable||472KB475KB||1.24MB17MB||2.2.9|| || ||8083||align="left"|Includes htaccess, authentication and mod-rewrite
|-align="center" style="background:#ffffff"
|align="left"|[[Mini Servers: Server 1d Apache 2.2.9 Portable - Authentication SSL|UC Server 1d - SSL4]]||Portable||1M1MB||2.99MB89MB||2.2.9|| || ||8084/444||align="left"|As server 1c with added protect protection of SSL
|-align="center" style="background:#ffffff"
|align="left"|[[Mini Servers: Server 1e Apache 2.2.9 Portable - Authentication SSL Standalone|UC Server 1d - SSL Standalone5]]||Portable||0.99M1MKB||2.95MB87MB||2.2.9|| || ||8085||align="left"|As server 1d SSL Standalone no main server on port 808084
|-align="center" style="background:#ffffff"
|align="left"|[[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable|UC Server 2a6]]||Portable||2.03MB02MB||65.07MB87MB||2.2.9||5.2.6|| ||8086||align="left"|Includes Guest Book
|-align="center" style="background:#ffffff"
|align="left"|[[Mini Servers: Apache 2.2.9 PHP 5.2.6 Service|UC Server 2b7]]||Service||2.28MB27MB||76.03MB59MB||2.2.9||5.2.6|| ||8087||align="left"|Includes Guest Book
|-align="center" style="background:#ffffff"
|align="left"|[[Mini Servers: Apache 2.2.9 Perl PHP 5.10 2.6 Portable- MySQL Support|UC Server 3a8]]||Portable||960KB2.47MB||27.67MB93MB||2.2.9||5.2.6|| ||5.108088||align="left"| Includes Guest Book, PHP Mini SQL Admin and MySQL support enabled.
|-align="center" style="background:#ffffff"
|align="left"|[[Mini Servers: Apache 2.2.9 Perl 5.10 Portable|Server 9]]||Portable||953KB||2.54MB||2.2.9|| ||5.10||8089|| |-align="center" style="background:#ffffff"|align="left"|[[Mini Servers: Apache 2.2.9 Perl 5.10 Service|UC Server 3b10]]||Service||1.07MB904MB||32.51MB36MB||2.2.9|| ||5.10||8090|| |-align="center" style="background:#ffffff"|align="left"|[[Mini Servers: MySQL 5.0.51b Portable|Server 11]]||Portable||1.85MB||10.2MB|| || || ||3311||align="left"|MySQL 5.0.51b Server running on port 3311|-align="center" style="background:#ffffff"|align="left"|[[Mini Servers: MySQL 5.0.51b Service|Server 12]]||Service||1.85MB||10.2MB|| || || ||3312||align="left"|MySQL 5.0.51b Server running on port 3312|-align="center" style="background:#ffffff"|align="left"|[[Mini Servers: MySQL 4.1.22 Portable|Server 13]]||Portable||1.46MB||6.38MB|| || || ||3313||align="left"|MySQL 4.1.22 Server running on port 3313|-align="center" style="background:#ffffff"|align="left"|[[Mini Servers: MySQL 4.1.22 Service|Server 14]]||Service||1.46MB||6.37MB|| || || ||3314||align="left"|MySQL 4.1.22 Server running on port 3314
|}
'''''[[#top | Top]]'''''
== Server 1a 1 - Apache core 2.2.9 - Portable ==A very basic portable production server for serving web pages (htm and html). Includes a basic web site. Redesigned Designed to allow multiple servers running on same PC, these require a separate virtual driveautomatically created.
# [[Mini Servers: Apache 2.2.9 Portable|Introduction:]] Intro and security
# [[Mini Servers: Apache 2.2.9 Portable#Support files|Support files:]] - How to download, unpack server and test.
# [[Mini Servers: Apache 2.2.9 Portable#Your web site|Your Web Site:]] Where to put your web site.
# [[Mini Servers: Apache 2.2.9 Portable#Summary|Summary:]] Leading onto uc mini server 1b2.
'''''[[#top | Top]]'''''
 == Server 1b 2 - Apache core 2.2.9 - Service==As above but no longer portable runs A very basic production server running as a service. Remains a production server for serving web pages (htm and html). Includes includes a basic web site. Designed to allow multiple servers running as a service on same PC, will require a separate folder for each server easy to set-up and configure.
# [[Mini Servers: Apache 2.2.9 Service|Introduction:]] Intro and surgery performed
# [[Mini Servers: Apache 2.2.9 Service#Support files|Support files:]] - How to download, unpack server and test.
# [[Mini Servers: Apache 2.2.9 Service#Your web site |Your Web Site:]] Where to put your web site.
# [[Mini Servers: Apache 2.2.9 Service#Summary|Summary:]] Leading onto uc mini server 2a3.
'''''[[#top | Top]]'''''
== Server 1c - Apache core 2.2.9 - htaccess, authentication and mod-rewrite==
This server is based on Server 1a. It has the following enabled, htaccess, basic authentication and mod rewrite. Mod rewrite was included to enhance basic authentication. Included are two examples of authentication, protection of single private pages and protection of private folders. A name and password are required to access individual protected areas. Runs on virtual drive '''Z''' server uses port '''8080'''.
== Server 3 - Apache core 2.2.9 - htaccess, authentication and mod-rewrite==A very small portable production server for serving web pages (htm and html) includes a basic web site. Designed to allow multiple servers running on same PC, these will require a separate virtual drive automatically created.  This server has the following enabled, htaccess, basic authentication and mod rewrite. Mod rewrite included enhancing basic authentication. Included are two examples of authentication, protection of single private pages and protection of private folders. A name and password are required to access individual protected areas.   # [[Mini Servers: Server 1cApache 2.2.9 Portable - Authentication|Introduction:]] Intro # [[Mini Servers: Server 1cApache 2.2.9 Portable - Authentication#Moving the Server|Moving the Server:]] How to change port to 8080 and virtual drive to z # [[Mini Servers: Server 1cApache 2.2.9 Portable - Authentication#How to enable htaccess|How to enable htaccess:]] and protect from Internet access # [[Mini Servers: Server 1cApache 2.2.9 Portable - Authentication#How to add authentication|How to add authentication:]] Modules required to enable basic authentication # [[Mini Servers: Server 1cApache 2.2.9 Portable - Authentication#Add password folder|:Add password folder]] and file to save name/password pairs. # [[Mini Servers: Server 1cApache 2.2.9 Portable - Authentication#How to add mod rewrite|How to add mod rewrite:]] Extremly easy to add mod rewrite. # [[Mini Servers: Server 1cApache 2.2.9 Portable - Authentication#Mini server httpd.conf|Mini server httpd.conf:]] Complete configuration file. # [[Mini Servers: Server 1cApache 2.2.9 Portable - Authentication#Support files|Support files:]] Download this server. # [[Mini Servers: Server 1cApache 2.2.9 Portable - Authentication#SecureSecure1|SecureSecure1:]] How to protect single pages with a name and password. # [[Mini Servers: Server 1cApache 2.2.9 Portable - Authentication#Secure2|Secure2:]] How to protect individual folders with a name and password.# [[Mini Servers: Server 1cApache 2.2.9 Portable - Authentication#Summary|Summary:]] Leading onto an SSL enabled mini server4.
'''''[[#top | Top]]'''''
== Server 1d 4 - Apache core 2.2.9 - htaccess, authentication and mod-rewrite SSL==This A very small portable production server is based on Server 1c. It has the following enabled, htaccess, basic authentication, mod rewrite for serving web pages (htm and SSL. Mod rewrite was included to enhance html) includes a basic authentication. Included are two examples of authentication, protection of single private pages and protection of private foldersweb site. A name and password are required Designed to access individual protected areas. Runs allow multiple servers running on same PC, these will require a separate virtual drive '''X''' server uses port '''80'''. Increased security is achieved by encrypting the password and data using SSLautomatically created.
This server has the following enabled, htaccess, basic authentication and mod rewrite. Mod rewrite included enhancing basic authentication. Included are two examples of authentication, protection of single private pages and protection of private folders. A name and password are required to access individual protected areas.  Increased security is achieved by encrypting name/password pairs and data using SSL. Creating a new server key and certificate is achieved by running a single file making the whole process extremely easy. This server is ideal for a personal secure server. # [[Mini Servers: Server 1d Apache 2.2.9 Portable - Authentication SSL |Introduction:]] Intro # [[Mini Servers: Server 1d Apache 2.2.9 Portable - Authentication SSL#Folder structure|Folder structure:]] Split the root folders # [[Mini Servers: Server 1d Apache 2.2.9 Portable - Authentication SSL#Configuration file structure|Configuration file structure:]] Uses two configuration files # [[Mini Servers: Server 1d Apache 2.2.9 Portable - Authentication SSL#How to add SSL|How to add SSL:]] Enable SSL in main configuration file # [[Mini Servers: Server 1d Apache 2.2.9 Portable - Authentication SSL#ssl.conf|:ssl.conf]] Enable htaccess in SSL config. # [[Mini Servers: Server 1d Apache 2.2.9 Portable - Authentication SSL#Complete configuration files|Complete configuration files:]]Shows both configuration files used. # [[Mini Servers: Server 1d Apache 2.2.9 Portable - Authentication SSL#Support files|Support files:]] Download this server. # [[Mini Servers: Server 1d Apache 2.2.9 Portable - Authentication SSL#Generate new server Certificate and key|Generate new server Certificate and key:]] Must create new certificate and key# [[Mini Servers: Server 1d Apache 2.2.9 Portable - Authentication SSL#Summary|Summary:]] Leading onto mini server 1e 5
'''''[[#top | Top]]'''''
== Server 1e 5 - Apache core 2.2.9 - authentication and mod-rewrite SSL Standalone==This very small portable production server is based a stand-alone SSL server for serving web pages (htm and html) includes a basic web site. It does not have an insecure server section. Designed to allow multiple servers running on Server 1dsame PC, these will require a separate virtual drive automatically created. Support for  This server has the following enabled, htaccess removed. Basic , basic authentication, and mod rewrite and SSL enabled. Mod rewrite was included to enhance enhancing basic authentication. Included are two examples of authentication, protection of single private pages and protection of private folders. A name and password are required to access individual protected areas. Runs on virtual drive '''X''' no main server on port '''80''' secure sever runs on port 443.  Increased security is achieved by encrypting the name/password pairs and data using SSL. Creating a new server key and certificate is achieved by running a single file making the whole process extremely easy. This server is ideal for a personal secure server.
# [[Mini Servers: Server 1e Apache 2.2.9 Portable - Authentication SSL Standalone|Introduction:]] Intro # [[Mini Servers: Server 1e Apache 2.2.9 Portable - Authentication SSL Standalone#Changes made to server 1d4|Changes made to server 1d4:]] Overview of changes # [[Mini Servers: Server 1e Apache 2.2.9 Portable - Authentication SSL Standalone#Complete configuration file|Complete configuration file:]] New configuration file # [[Mini Servers: Server 1e Apache 2.2.9 Portable - Authentication SSL Standalone#Summary of changes|Summary of changes:]] Dtail of chanfes by section. # [[Mini Servers: Server 1e Apache 2.2.9 Portable - Authentication SSL Standalone#Support files|Support files:]] Download this server. # [[Mini Servers: Server 1e Apache 2.2.9 Portable - Authentication SSL Standalone#Generate new server Certificate and key|Generate new server Certificate and key:]] Must create new certificate and key# [[Mini Servers: Server 1e Apache 2.2.9 Portable - Authentication SSL Standalone#Conclusion|Conclusion:]] End of mini server 1series1 series..
'''''[[#top | Top]]'''''
== Server 2a 6 - Apache 2.2.9 & PHP 5.2.6 ==A basic portable production server with the added power of PHPallowing dynamic web pages in addition to static htm and html pages. Includes a basic web site and Guest book. Designed to allow multiple servers running on same PC, these will require a separate virtual drive automatically created.
# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable|Introduction:]] Intro and security
# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable#Support files|Support files:]] - How to download, unpack server and test.
# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable#Your web site|Your Web Site:]] Where to put your web site.
# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable#Summary|Summary:]] Leading onto mini server 2a 6 guest book.
'''''[[#top | Top]]'''''
== Mini Server 2a 6 Guest book ==
This mini server includes a quest book (version 1.7.2) downloaded from the DigiOz web site.
# [[Mini Servers: Server 2a Guest book|Introduction:]] Intro to guest book# [[Mini Servers: Server 2a Guest book#Server configuration problem |Server configuration problem:]] Guest book highlights a server problem.# [[Mini Servers: Server 2a Guest book#File extensions|File extensions:]] - Shows why you should always a php file extensions.# [[Mini Servers: Server 2a Guest book#Defensive programming|Defensive programming:]] - Never trust user data!# [[Mini Servers: Server 2a Guest book#Automated posts|Automated posts:]] Kill the automated post with a captua# [[Mini Servers: Server 2a Guest book#Summary|Summary:]] Leading onto mini server 2b Server 2 running 7 run as a service.
'''''[[#top | Top]]'''''
 == Server 2b 7 - Apache 2.2.9 & PHP 5.2.6 ==As above but no longer portable runs A basic production server running as a service. A production serverwith the added power of PHP allowing dynamic web pages in addition to static htm and html pages. Includes demo a basic web sites site and guest Guest book. Designed to allow multiple servers running on same PC, will require a separate folder for each server easy to set-up and configure.
# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Service|Introduction:]] Intro and surgery performed
# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Service#Support files |Support files:]] - How to download, unpack server and test.
# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Service#Your web site|Your Web Site:]] Where to put your web site.
# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Service#Summary|Summary:]] Leading onto mini server 3a8 MySQL support enabled. '''''[[#top | Top]]''''' == Server 8 - Apache 2.2.9 & PHP 5.2.6 MySQL support enabled==A basic portable production server with the added power of PHP allowing dynamic web pages in addition to static htm and html pages. Includes a basic web site and Guest book. Designed to allow multiple servers running on same PC, these will require a separate virtual drive automatically created. MySQL support is enabled further enhancing this server’s capability. A neat little script '''PHP Mini SQL Admin''' is included allowing you to access a MySQL server. # [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable - MySQL Support|Introduction:]] Intro and security# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable - MySQL Support#Specification|Specification:]] Increased specification.# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable - MySQL Support#PHP MySQL Support|PHP MySQL Support:]] - How to enable MySQL support.# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable - MySQL Support#libmysql.dll Errors|libmysql.dll Errors:]] - How to make sure Apache finds libmysql.dll# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable - MySQL Support#Problem|Problem:]] Reasons why libmysql.dll can not be found# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable - MySQL Support#Solution|Solution:]] Force Apache to load file.# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable - MySQL Support#PHP Mini SQL Admin |PHP Mini SQL Admin:]] A neat little script that complements the server.# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable - MySQL Support#Support files|Support files:]] - How to download, unpack server and test.# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable - MySQL Support#Your web site|Your Web Site:]] Where to put your web site.# [[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable - MySQL Support#Summary|Summary:]] Leading onto mini server 9.
'''''[[#top | Top]]'''''
 == Server 3a 9 - Apache 2.2.9 & Perl 5.10 ==A basic portable production server with the added power of Perlallowing dynamic web pages in addition to static htm and html pages. Includes a basic web site and a demonstration of server side includes, random quotes and image display. Designed to allow multiple servers running on same PC, these will require a separate virtual drive automatically created.
# [[Mini Servers: Apache 2.2.9 Perl 5.10 Portable|Introduction:]] Intro and security
# [[Mini Servers: Apache 2.2.9 Perl 5.10 Portable#Your web site|Your Web Site:]] Where to put your web site.
# [[Mini Servers: Apache 2.2.9 Perl 5.10 Portable#Problems - shebang|Shebang problem:]] Make sure you are using the correct one
# [[Mini Servers: Apache 2.2.9 Perl 5.10 Portable#Summary|Summary:]] Leading onto mini server 3b 10 run as service.
'''''[[#top | Top]]'''''
 == Server 3b 10 - Apache 2.2.9 & Perl 5.10 ==As above but no longer portable runs A basic production server running as a servicewith the added power of Perl allowing dynamic web pages in addition to static htm and html pages. A production  Includes a basic web site and a demonstration of serverside includes, random quotes and image display. Includes demo web sites Designed to allow multiple servers running on same PC, will require a separate folder for each server easy to set-up and guest bookconfigure.
# [[Mini Servers: Apache 2.2.9 Perl 5.10 Service|Introduction:]] Intro
# [[Mini Servers: Apache 2.2.9 Perl 5.10 Service#Your web site|Your Web Site:]] Where to put your web site.
# [[Mini Servers: Apache 2.2.9 Perl 5.10 Service#Problems - shebang|Shebang problem:]] Make sure you are using the correct one
# [[Mini Servers: Apache 2.2.9 Perl 5.10 Service#Summary|Summary:]] Leading onto !!!server 11 MySQL portable'''''[[#top | Top]]''''' == Server 11 - MySQL 5.0.51b Portable ==A fully portable MySQL server ideal for leaning SQL it is possible to connect using phpMyAdmin. Alternatively use the built in MySQL clients '''mysqladmin''' and '''mysql'''. Automatically detects free drive letter to run on easily configured port change default 3311 to any other port not in use. Designed to allow multiple MySQL servers running on same PC, easy to set-up and configure. # [[Mini Servers: MySQL 5.0.51b Portable|Introduction:]] Intro# [[Mini Servers: MySQL 5.0.51b Portable#Specification|Specification:]] Short server specification.# [[Mini Servers: MySQL 5.0.51b Portable#Support files|Support files:]] - How to download, unpack server and test.# [[Mini Servers: MySQL 5.0.51b Portable#DOS (CMD) Prompt|DOS (CMD) Prompt:]] How to open and use a command window.# [[Mini Servers: MySQL 5.0.51b Portable#PHP|PHP:]] Test script to connect to this server and create a database.# [[Mini Servers: MySQL 5.0.51b Portable#Change Virtual Drive|Change Virtual Drive:]] How to override auto detection.# [[Mini Servers: MySQL 5.0.51b Portable#Change server default port|Change server default port:]] How to change default port 3308.# [[Mini Servers: MySQL 5.0.51b Portable#MySQL - Admin|MySQL - Admin:]] MySQL client to configure server.# [[Mini Servers: MySQL 5.0.51b Portable#MySQL - Client program|MySQL - Client program:]] MySQL client allows you to enter SQL commands.# [[Mini Servers: MySQL 5.0.51b Portable#Summary|Summary]] Leading onto mini-server 12. '''''[[#top | Top]]''''' == Server 12 - MySQL 5.0.51b Service ==A MySQL server running as a service ideal for leaning SQL it is possible to connect using phpMyAdmin. Alternatively use the built in MySQL clients '''mysqladmin''' and '''mysql'''. Easily configured port, change default 3312 to any other port not in use. Designed to allow multiple MySQL servers running on same PC, easy to set-up and configure. # [[Mini Servers: MySQL 5.0.51b Service|Introduction:]] Intro# [[Mini Servers: MySQL 5.0.51b Service#Specification|Specification:]] Short server specification.# [[Mini Servers: MySQL 5.0.51b Service#Configuring MySQL|Configuring MySQL:]] Change paths to absolute.# [[Mini Servers: MySQL 5.0.51b Service#install.bat|install.bat:]] Installs the server as a service.# [[Mini Servers: MySQL 5.0.51b Service#uninstall.bat |uninstall.bat:]] Uninstalls the service.# [[Mini Servers: MySQL 5.0.51b Service#console.bat|console.bat:]] Opens a command window to run MySQL clients.# [[Mini Servers: MySQL 5.0.51b Service#Support files|Support files:]] - How to download, unpack server and test.# [[Mini Servers: MySQL 5.0.51b Service#Test|Test:]] Quick test guide.# [[Mini Servers: MySQL 5.0.51b Service#Change drive letter and or folder|Change drive letter and or folder:]] How to move the server.# [[Mini Servers: MySQL 5.0.51b Service#Change server default port|Change server default port:]] How to change default port 3308.# [[Mini Servers: MySQL 5.0.51b Service#MySQL - Admin|MySQL - Admin:]] MySQL client to configure server.# [[Mini Servers: MySQL 5.0.51b Service#Change Root password|Change Root password:]] How to change root password.# [[Mini Servers: MySQL 5.0.51b Service#MySQL - Client program|MySQL - Client program:]] MySQL client allows you to enter SQL commands.# [[Mini Servers: MySQL 5.0.51b Service#Summary|Summary]] Leading onto mini-server 13. '''''[[#top | Top]]'''''== Server 13 - MySQL 4.1.22 Portable ==This MySQL server is the last in the 4 series however it is still widely used by service providers hence included in the mini-series allowing code to be tested. With code tested on both MySQL series 4 and 5 you reduce incompatibility problems when transferring to a service provider. A fully portable MySQL server ideal for leaning SQL it is possible to connect using phpMyAdmin. Alternatively use the built in MySQL clients '''mysqladmin''' and '''mysql'''. Automatically detects free drive letter to run on easily configured port change default 3311 to any other port not in use. Designed to allow multiple MySQL servers running on same PC, easy to set-up and configure. # [[Mini Servers: MySQL 4.1.22 Portable|Introduction:]] Intro# [[Mini Servers: MySQL 4.1.22 Portable#Specification|Specification:]] Short server specification.# [[Mini Servers: MySQL 4.1.22 Portable#Support files|Support files:]] - How to download, unpack server and test.# [[Mini Servers: MySQL 4.1.22 Portable#DOS (CMD) Prompt|DOS (CMD) Prompt:]] How to open and use a command window.# [[Mini Servers: MySQL 4.1.22 Portable#PHP|PHP:]] Test script to connect to this server and create a database.# [[Mini Servers: MySQL 4.1.22 Portable#Change Virtual Drive|Change Virtual Drive:]] How to override auto detection.# [[Mini Servers: MySQL 4.1.22 Portable#Change server default port|Change server default port:]] How to change default port 3308.# [[Mini Servers: MySQL 4.1.22 Portable#MySQL - Admin|MySQL - Admin:]] MySQL client to configure server.# [[Mini Servers: MySQL 4.1.22 Portable#MySQL - Client program|MySQL - Client program:]] MySQL client allows you to enter SQL commands.# [[Mini Servers: MySQL 4.1.22 Portable#Summary|Summary]] Leading onto mini-server 12. '''''[[#top | Top]]''''' == Server 14 - MySQL 4.1.22 Service ==This MySQL server is the last in the 4 series however it is still widely used by service providers hence included in the mini-series allowing code to be tested. With code tested on both MySQL series 4 and 5 you reduce incompatibility problems when transferring to a service provider. A MySQL server running as a service ideal for leaning SQL it is possible to connect using phpMyAdmin. Alternatively use the built in MySQL clients '''mysqladmin''' and '''mysql'''. Easily configured port, change default 3312 to any other port not in use. Designed to allow multiple MySQL servers running on same PC, easy to set-up and configure. # [[Mini Servers: MySQL 4.1.22 Service|Introduction:]] Intro# [[Mini Servers: MySQL 4.1.22 Service#Specification|Specification:]] Short server specification.# [[Mini Servers: MySQL 4.1.22 Service#Configuring MySQL|Configuring MySQL:]] Change paths to absolute.# [[Mini Servers: MySQL 4.1.22 Service#install.bat|install.bat:]] Installs the server as a service.# [[Mini Servers: MySQL 4.1.22 Service#uninstall.bat |uninstall.bat:]] Uninstalls the service.# [[Mini Servers: MySQL 4.1.22 Service#console.bat|console.bat:]] Opens a command window to run MySQL clients.# [[Mini Servers: MySQL 4.1.22 Service#Support files|Support files:]] - How to download, unpack server and test.# [[Mini Servers: MySQL 4.1.22 Service#Test|Test:]] Quick test guide.# [[Mini Servers: MySQL 4.1.22 Service#Change drive letter and or folder|Change drive letter and or folder:]] How to move the server.# [[Mini Servers: MySQL 4.1.22 Service#Change server default port|Change server default port:]] How to change default port 3308.# [[Mini Servers: MySQL 4.1.22 Service#MySQL - Admin|MySQL - Admin:]] MySQL client to configure server.# [[Mini Servers: MySQL 4.1.22 Service#Change Root password|Change Root password:]] How to change root password.# [[Mini Servers: MySQL 4.1.22 Service#MySQL - Client program|MySQL - Client program:]] MySQL client allows you to enter SQL commands.# [[Mini Servers: MySQL 4.1.22 Service#Summary|Summary]] End of series. '''''[[#top | Top]]'''''
== Summary ==
Each mini server is complete including an example of the type of web site it can support. The [[Mini Servers: Apache 2.2.9 Portable|first in the series ]] is probably about as secure as anyone can make a server on Windows! Well enjoy I hope you can find a use for one of these or just use the full version of Uniform Server.
'''''[[#top | Top]]'''''
| [[Image:uc_small_logo.gif]] || [[User:Ric|Ric]]
|}
 
[[Category: UniCenter]]

Navigation menu