• user warning: Table './avideotutorial/votingapi_vote' is marked as crashed and last (automatic?) repair failed query: SELECT * FROM votingapi_vote v WHERE 1 = 1 AND v.content_type = 'node' AND v.content_id = 222 AND v.tag = 'upndown' AND v.uid = 0 AND v.vote_source = '3.145.105.85' AND v.timestamp >= 1735576347 in /data/avideotutorial/sites/all/modules/votingapi/votingapi.module on line 557.
  • user warning: Table './avideotutorial/votingapi_vote' is marked as crashed and last (automatic?) repair failed query: SELECT * FROM votingapi_vote v WHERE 1 = 1 AND v.content_type = 'node' AND v.content_id = 222 AND v.tag = 'upndown' AND v.uid = 0 AND v.vote_source = '3.145.105.85' AND v.timestamp >= 1735576347 in /data/avideotutorial/sites/all/modules/votingapi/votingapi.module on line 557.

Installing LAMP Server on Ubuntu Desktop 10.10


What is LAMP Server?

LAMP server is a stack of technologies layered on top of eachother to serve not only as a development platform, but as well as a robust and stable web application hosting platform.

LAMP server it self stands for:
- Linux (operating system)
- Apache (webserver)
- MySQL (database application)
- PHP (programming language)

When setting it up on your own computer, in most cases you will be setting it up to work on, or develop websites/web apps offline for testing. This often helps developers speed up the process to going live with a site. It also gives them the opportunity to make crucial changes to a website offline, without potentially interfereing with you online version of the site, and possibly causing service outages.

Through the Ubuntu forms and community, there is well-documented instructions on how and what packages you would and could install to get up and running with your very own LAMP server. However I tend to find that the documentation is often a bit outdated, with each seperate package you install, you could easily throw off install of the entire system.

First thing we will do is open a new terminal window and type:

sudo apt-get install lamp-server^

Don't forget to put the little ^ at the end. For some strange reason you will need to do this for it to install properly.

It should be mentioned that you could have added phpmyadmin after the lamp-server^ statement, but it was forgotten in this demo.

to install phpmyadmin simply type:

sudo apt-get install phpmyadmin

and follow the setup instrctions.

Now that we have fully installed LAMP Server on Ubuntu 10.10 with PhpMyAdmin, we can now go ahead and start configuring PhpMyAdmin to work with Apache webserver so you can access your MySQL databases. :) For this, we will need to edit our Apache configuration file. To edit this file, we will type in:

sudo gedit /etc/apache2/apache2.conf

Once you see the text editor open up, we will need to add the following line to the bottom of this configuration file:

Include /etc/phpmyadmin/apache.conf

save the file and exit. In order for the webserver to see these new changes we will have to restart it. Relax. This isn't Windows, so we won't have to reboot. Simply type in:

sudo /etc/init.d/apache2 reload

the webserver will researt and you will need ot open your browser. first checka nd see if your webserver is working.

type in "localhost"

"it works" - it works

localhost/phpmyadmin

log in, and begin your work!

https://help.ubuntu.com/community/phpMyAdmin


See video

Comments

Post new comment

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

More information about formatting options