Installing LAMP (Linux, Apache, MySQL and PHP) On Linux Mint


Through this tutorial, you'll learn how to Install Apache, MySQL and PHP.
If you're a webpage designer or developer and use PHP, mySQL and Apache, you'll be needing these applications to be installed. When I istalled Mint, I was looking for a way to install LAMP and found a tutorial on a website by somebody named "Cargoship". That tutorial was for ubuntu. But I installed it on my Linux mint, and it is working.

 

 
In this guide I will show you how to install a LAMP system. LAMP stands for Linux, Apache, MySQL, PHP. The guide is intended to help those who have very little knowlegde of using Linux.

We will not cover how to install Linux the L of LAMP, because Linux Mint is already installed in your computer.

Install Apache

To start off we will install Apache.
1. Open up the Terminal (Applications > Accessories > Terminal).
2. Copy/Paste or type the following line of code into Terminal and then press enter:
sudo apt-get install apache2
3. The Terminal will then ask you for you're password, type it and then press enter.

Testing Apache

To make sure everything installed correctly we will now test Apache to ensure it is working properly.
1. Open up any web browser and then enter the following into the web address:
http://localhost/

Test PHP

To ensure there are no issues with PHP let's give it a quick test run.
Step 1. In the terminal copy/paste or type the following line:
sudo gedit /var/www/testphp.php
This will open up a file called phptest.php.

Step 2. Copy/Paste this line into the phptest file:
Step 3. Save and close the file.
Step 4. Now open you're web browser and type the following into the web address:
http://localhost/testphp.php
 
(It will show you the page that has all information about your php. If you have prior experience of installing php in some other OS, you must have seen this page.)
Congrats you have now installed both Apache and PHP!

Install MySQL

To finish this guide up we will install MySQL.
Step 1. Once again open up the amazing Terminal and then copy/paste or type this line:
sudo apt-get install mysql-server
Step 2 (optional). 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
Change the line
bind-address = 127.0.0.1
And change the 127.0.0.1 to your IP address.
(In Linux Mint 11, terminal itself asked to the set password, But if it doesn't follow the step 3.)
Step 3. This is where things may start to get tricky. Begin by typing the following into Terminal:
mysql -u root
Following that copy/paste or type this line:
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourpassword');
(Make sure to change yourpassword to a password of your choice.)
Step 4. We are now going to install a program called phpMyAdmin which is an easy tool to edit your databases. Copy/paste or type the following line into Terminal:
sudo apt-get install libapache2-mod-auth-mysql php5-mysql phpmyadmin
After that is installed our next task is to get PHP to work with MySQL. To do this we will need to open a file entitled php.ini. To open it type the following:
gksudo gedit /etc/php5/apache2/php.ini
Now we are going to have to uncomment the following line by taking out the semicolon (;).
Change this line:
;extension=mysql.so
To look like this:
extension=mysql.so
Now just restart Apache and you are all set!
sudo /etc/init.d/apache2 restart

You should see a folder entitled apache2-default/. Open it and you will see a message saying "It works!" , congrats to you! or something like that!

Install PHP

In this part we will install PHP 5.
Step 1. Again open up the Terminal (Applications > Accessories > Terminal).
Step 2. Copy/Paste or type the following line into Terminal and press enter:
sudo apt-get install php5 libapache2-mod-php5
Step 3. In order for PHP to work and be compatible with Apache we must restart Apache. Type the following code in Terminal to do this:
sudo /etc/init.d/apache2 restart


Calculus is here!

All those dx / dy's are now turning crystal clear. I am finally learning calculus.

I had been crawling the whole web in my search to find the best site to learn calculus from scratch!
This (intmath.com) is what I have discovered as the best of the lot!

I started off from limits and derivatives, and ended up in integration. Have fun!

Internet Explorer 6 bids goodbye

Microsoft itself has told its users to bid goodbye to the ancient version of the Internet Explorer -- IE6.
Recently, it has stepped up its efforts to dissuade people from using IE6 by publishing what I'd like to call anti-IE6 stuff all over the web.

However, it is not without a reason. With HTML5 supported browsers coming into the market and millions of security loopholes being exposed in the old version of IE, and major firms like Google refusing to give browser support to browsers other than the so-called 'modern browsers', Microsoft has even decided to 'silently' update users' version of IE in the background to provide them with the latest technology and support.

The largest user base of IE6 is in China, and IE, as a whole still leads the global market, but with a narrow margin. Internet Explorer has a 51% share in the world's browser market!

Well, I posted this post as a tribute to the world's most used browser once upon a time - Microsoft Windows Internet Explorer 6!

Apache Derby: 4 useful commands

Well, if you haven't heard of SQL, then this post is definitely not for you! You might want to visit http://w3schools.org/sql to learn the ropes!!


On the other hand, if you are one of those geniuses who have executed a simple SELECT, INSERT, UPDATE or DROP statement, then this is absolutely designed for you ;)


I am working with the Apache Derby database (also known as Java DB) and since tutorials on this one is hard to get, I am writing one of my own!!


Here are the top few tutorials and "hacks" that might help you like Apache Derby! I know that blank theory is like verse without prose, which is why I have explained only through examples. 


1. Create an auto-increment column in Apache Derby:
An auto-increment column would be useful in cases when you want to generate unique IDs for every row. A good instance would be a student database where each student would have a primary key as a STUDENT_ID and you don't want to take the dumb initiative of increasing the ID value manually.
This might come in handy for you!