Installing Apache2 with PHP5 and MySQL on Ubuntu 9.10 in 5 easy steps

A 'Setup Apache2 with PHP5 and MySQL on Linux is usually also known as LAMP (acronym indicating precisely L inux, A pache, M ySQL, P HP) and represents the typical configuration needed to activate what is the web platform par excellence, which can be characterized as being the most popular and used worldwide: WordPress, phpBB, and Drupal are some of the web applications based on LAMP.

In particular, in this article we will see how to install in a few moments Apache2 with PHP5 and MySQL on Ubuntu 9.10. Read more

How to recover the root password of a MySQL database

MySQL is probably the most widely used relational database free in circulation, and preferred partner by PHP applications, is the reference in all DBMS platforms LAMP. In fact MySQL has its wide distribution to two fundamental factors:

1. availability on multiple platforms: there are versions for both Linux / Unix and Windows
2. its excellent performances in terms of performance and speed, very high in relation to the hardware resources needed

In any MySQL database is normally associated with a root user with full powers to manage and administer every feature. This obviously implies that if by chance (or misfortune) if you lose the password, the database becomes practically unusable. Here we see two methods to retrieve the root password of a MySQL database. Read more

Automate the backup of your MySQL database on Windows and Linux

Backing up a MySQL database is a very important especially for a site of medium / high should be made even daily. In this article we will see how this type of operation is easily automated by scheduling a simple script from the command line, whether you're using a Linux server and Windows. Read more

Setup Apache 2, MySQL 5 and PHP 5 on Windows in 5 minutes

Although we all agree that Linux is the ideal platform for such applications, it can still happen to also have the need to install Apache, MySQL and PHP on Windows. The main problem in this case is not so much to install individual applications, how to configure for smooth integration. And on Windows this may be more confusing than Linux in which the steps to be performed are very clear and precise.

In this situation we can assist XAMPP, a special installer made for Windows (although still there are versions for Mac OS X, Solaris and Linux) that installs in a single operation a comprehensive package of Apache, MySQL and PHP pre-configured and ready to use, complete with a unified management console. Indeed, to be precise the bundle of XAMPP installed and configured on your PC the following applications:

• Apache HTTPD 2.2.8 + Openssl 0.9.8g
• MySQL 5.0.51a
• PHP 5.2.5
• PHP 4.4.8
• phpMyAdmin 2.11.4
• FileZilla FTP Server 0.9.25
• Mercury Mail Transport System 4:52

Read more

Setup Apache2, MySQL and PHP5 on Ubuntu Linux

Last weekend I decided to give a purpose to an old PC (Pentium III with 128MB RAM, 30GB HD) on which a few months ago I installed Ubuntu Server 6.0.6. As always what I was missing was an online test environment that allowed me to make the modifications and new features to add to my sites to avoid doing hot, I needed to install and configure Apache2, MySQL and PHP5.
Read more

Next Page »