Go Back   TechArena Community > ARENA > Guides & Tutorials
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to install Apache, PHP and MySQL on Debian

Guides & Tutorials


Reply
 
Thread Tools Search this Thread
  #1  
Old 15-06-2010
Member
 
Join Date: Feb 2010
Posts: 136
How to install Apache, PHP and MySQL on Debian
  

Apache, PHP and MySQL on Linux Debian


1. General
This article will guide you in installing a Web server Apache with PHP, MySQL and phpMyAdmin. This assumes that you have an Internet connection and an environment Debian GNU Linux. If you do not have GNU/ Debian Linux operating system, then you can visit their official site and see the documentation on installation.

2. Update apt sources
To install the latest packages, it is necessary to update the package list of the tool apt . Please log in root in a terminal using the command su. Type ensuite apt-get update. Once the download is complete, you have the list of latest packages.

Reply With Quote
  #2  
Old 15-06-2010
Member
 
Join Date: Feb 2010
Posts: 136
Re: How to install Apache, PHP and MySQL on Debian

3. Installing Apache 2
This is the only Web server. Without documentation, no server side language, no database can rally work.
Just issue the following command in your terminal as a root user
Code:
apt-get install apache2
Total size: 5252 KB (approximate)
You can verify that the server is running by typing
Code:
http://127.0.0.1/
in your favorite browser


4. Installing Apache 2 documentation
This documentation is visible from a virtual server.
Just issue the following command from the terminal as a root user
Code:
apt-get install apache2-doc
Total size: 14.3 Mb (approximate)
This material is visible by typing
Code:
http://127.0.0.1/manual/
in a browser. You restart the server using the command
Code:
/ Etc/init.d/apache2 restart.

5. Installing MySQL
The popular free database MySql is very powerful. Version 4.1 supports nested queries, so why not use it?
You have to issue the following command in the terminal as a root user
Code:
apt-get install mysql-server-4.1
Total size: 41.0 MB (approximate)
Your database is operational, we must now set a password for the super user root to avoid any security. In the terminal type
Code:
mysql-u root
You are then directly connected to root on the MySQL server. The first thing to do is create a password.
Code:
mysql> USE mysql; mysql> UPDATE user -> SET password = PASSWORD
('motsecret') -> WHERE user = 'root'; mysql> flush privileges;
Disconnect the command you exit, you can reconnect using
Code:
mysql-u root-p
By doing so, MySQL will prompt you for your password.
Reply With Quote
  #3  
Old 15-06-2010
Member
 
Join Date: Feb 2010
Posts: 136
Re: How to install Apache, PHP and MySQL on Debian

6. Installing PHP 4
PHP allows you to generate Web pages dynamically. It is a server-side programming language. It is able to fetch information in the MySQL database.
Just issue the following command in the terminal as a root user
Code:
apt-get install libapache2-mod-php4 php4-mysql php4-gd php4-cli
Total size: 8012 KB (approximate)
We installed the PHP 4 module for Apache 2 module that allows communication between PHP and the MySQL server. A PHP interpreter command line, very convenient. For other packages php4 to install, do php4 apt-cache search. Search for the package name corresponding to your needs, then install it if necessary. Here is the list of packages related to PHP extensions:
Code:
php4-apd
php4-auth-pam
php4-cgi
php4-cli
php4-common
php4-curl
php4-dbtcp
php4-dev
php4-domxml
php4-gd
php4-gpib
php4-idn
php4-imagick
php4-imap
php4-interbase
php4-ldap
php4-maxdb
php4-mcal
php4-mcrypt
php4-mhash
php4-mysql
odbc php4-
php4-pear
php4-pear-log
php4-pgsql
php4-ps
php4-recode
php4-rrdtool
php4-snmp
php4-sqlite
php4-sqlrelay
php4-sybase
php4-syck
php4-tclink
php4-xslt

7. Installing phpMyAdmin
This tool developed in PHP will be very useful to administer and manage your databases.
Issue the following command in the terminal as a root user
Code:
apt-get install phpmyadmin
Total size: 9486 kb (approximate)
Then you will have access to phpMyAdmin by typing in the address bar
Code:
http://127.0.0.1/phpmyadmin/
After you restart the Apache server log in as root. You then have the possibility to create databases, manage privileges, then create users and give them rights on these grounds.
Reply With Quote
  #4  
Old 15-06-2010
Member
 
Join Date: Feb 2010
Posts: 136
Re: How to install Apache, PHP and MySQL on Debian

8. Create a directory for users (personal pages) of the machine
To ensure that each system user has a space to host their web pages, you need to configure Apache in the file
Code:
/ Etc/apache2/apache2.confusing
using vim or any other editor which you like and this as root (control su) Locate the following lines:
Code:
# UserDir Is Now a module # UserDir public_html # UserDir disabled root 
# <Directory /home/*/public_html> # AllowOverride FileInfo AuthConfig Limit 
# Options Indexes # SymLinksIfOwnerMatch IncludesNOEXEC </Directory>
Uncomment all and then store at
Code:
# UserDir Is Now a module UserDir public_html UserDir disabled root 
<Directory /home/*/public_html> AllowOverride FileInfo AuthConfig Limit 
Options Indexes SymLinksIfOwnerMatch IncludesNOEXEC </Directory>
For the changes to take effect, we will have to restart the Web server using the command
Code:
/Etc/init.d/apache2 restart
Run this command in the terminal as a root user. Now every user has the ability to implement its own homepage. For this, they simply create a directory name public_html, his home directory. The directory should at least be running for the other group and owner. The directory public_html must be readable by everyone.
Code:
$ cd / home / test / 
$ mkdir public_html 
$ chmod 755 public_html / 
$ chmod o + x. / 
$ cd public_html 
$ cat> index.php <?php phpinfo(); ?> 
CTRL + D to end of file
From now on, personal Web space is available from the address
Code:
http://127.0.0.1/ ~ user /
Or in the case of the example above
Code:
http://127.0.0.1/ test ~ /

9. Conclusion
I hope this tutorial will help you. If you are going to use these software's that is Apache, MySql, PHP on GNU/Linux Debian system, then you will get a great performance from your web server. GNU/Linux Debian is very well know for its stability.
Reply With Quote
  #5  
Old 15-06-2010
Member
 
Join Date: Jan 2007
Posts: 200
Re: How to install Apache, PHP and MySQL on Debian

Thank you so much for this installation tutorial
Reply With Quote
Reply

  TechArena Community > ARENA > Guides & Tutorials
Tags: , , , , , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to install Apache, PHP and MySQL on Debian"
Thread Thread Starter Forum Replies Last Post
Unable to install MySQL and MySQL Workbench on Linux mint 10 Zared Windows Software 4 13-01-2011 12:08 AM
Best ebooks for Web Development (PHP, Apache, MySql) SoftWore Ebooks 2 11-08-2010 02:06 PM
Install Apache and MySql on windows Enriquee Networking & Security 5 05-01-2010 03:32 AM
Installing apache php and mysql on slackware WinSlayer Operating Systems 3 10-08-2009 09:54 PM
cannot connect to local MySQL server in Debian 4 Protoplasm Networking & Security 4 06-05-2009 12:38 PM


All times are GMT +5.5. The time now is 11:50 AM.