How to setup a database for your website on ubuntu server

http://www.debuntu.org/how-to-create-a-mysql-database-and-set-privileges-to-a-user

How to create a webserver based on Ubuntu Server

Goal

The result of following this tutorial should be a (local) webserver that’s built with the following packages:
- Apache2, the actual webserver.
- PHP5, the popular language.
- MySQL, so we can make use of databases.
- SSH, this enables us to reach our server through both SSH and (S)FTP.

This tutorial only covers the installation of the actual server. After the server is installed we’ll still need to create our first website and database.

(more…)

How to find and replace a string in MySQL

UPDATE `table_name` SET `column_name` = REPLACE(`column_name`, 'original_string', 'replace_string')