Hello, now I’m going to give some tutorial to set up LAMP Server and to use it. Some people are confused to use this local server at UBuntu/Debian. Other linux will catch up later.
Firstly, you need to have this things inside your ubuntu/debian
- Apache 2 – Linux Web server
- MySQL 5 – MySQL Database Server
- PHP4/5 – PHP Scripting Language
- phpMyAdmin – Web-based database admin software.
You need 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 lot of RAM to run properly. Mysql will give you this nasty error “cannot connect to mysql.sock” if you dont have enough memory in your server. But I recommend you to have at least 512 of RAM available for more better performance.
Download PuTTy if you are accessing your server through SSH. Just enter the IP of your server with root login to access your host. You also can use Webmin, 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. You need to use both of those software.
OK, now all things are set up perfectly, now you need to refresh the repositories in your ubuntu/debian by typing: sudo apt-get update
After following those steps, now we’re ready to perform the installation.
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. You can choose the PHP type there 4 and 5, and pick one of the (DO NOT INSTALL BOTH OF THEM) Choose between PHP 4 or PHP 5.
PHP 4 & apache Command(Type in terminal):
PHP 5 & apache Command(Type in terminal):
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.
Type: nano /var/www/test.php
And here is the results after you type at the terminal:
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.Use konqueror or firefox to perform this.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 ecommerce site. Remember running mysql server to a fair extend requires atleast 256mb of RAM in your server. So unless you are running database driven sites you dont absolutely need mysql. The following commands will install mysql 5 server and mysql 5 client
N.B: 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 really nice web based database management and administration software and easy to install and configure under apache. Managing databases with tables couldnt be much simpler by using phpmyadmin. And here is the code to 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(put this code inside the apache2.conf): Include /etc/phpmyadmin/apache.conf
Now restart Apache by typing this code:
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. You can perform some installation and I already provide the tutorial to installing joomla at your apache, please visit this link to install joomla at your LAMP: http://allforlinux.blogspot.com/2008/05/installing-joomla-in-ubuntu-tutorial.html