Installing LAMP On Ubuntu
1. Install Apache
sudo apt-get install apache2
enter your password
1.1. Testing Apache
1.1.2 Open up any web browser and then enter the following into the web address:
http://localhost/
2. Install PHP
sudo apt-get install php5 libapache2-mod-php5
enter your password
2.1 In order for PHP to work and be compatible with Apache we must restart it:
sudo /etc/init.d/apache2 restart
2.2 Testing PHP
sudo gedit /var/www/test.php
3. Install MySQL
sudo apt-get install mysql-server
3.1 In order for other computers on your network to view the server you have created,
you must first edit the "Bind Address".
Begin by opening up Terminal to edit the my.cnf file:
gksudo gedit /etc/mysql/my.cnf
3.1.1 Change the line
bind-address = 127.0.0.1 to your IP address
3.2 Testing Mysql
mysql -u root --password='yourpassword'
or
mysql -u root
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourpassword');
3.3 We are now going to install a program called phpMyAdmin which is an easy tool to edit your databases. Copy/paste the following line into Terminal:
sudo apt-get install libapache2-mod-auth-mysql php5-mysql phpmyadmin
or
Download MySQL Workbench