Setting up Wordpress locally for development in Ubuntu

wordpress.sh

# Download WordPress
cd /tmp
wget http://wordpress.org/latest.tar.gz

# Extract your WordPress archieve into your server directory
tar zxvf latest.tar.gz
mv wordpress/ /var/www

# Create MySQL Database for WordPress
mysql -u root -p
#Enter password:

# Enter the following in mysql> Prompt
CREATE DATABASE wordpress;
CREATE USER wordpress;
SET PASSWORD FOR wordpress = PASSWORD(“wordpresspassword”);
GRANT ALL PRIVILEGES ON wordpress.* TO “wordpress”@”localhost” IDENTIFIED BY “wordpresspassword”;
flush privileges;
EXIT

# Configure WordPress Setting
cd /var/www/wordpress/
cp wp-config-sample.php wp-config.php
vim wp-config.php

# Install WordPress
# the folder (/var/www/wordpress) and all its files and subfolders must be owned by www-data
chown -R www-data /var/www/wordpress
# Open the browser to “http://localhost/wordpress” to install it

wp-config.php

<?php

/** Find the following lines in wp-config.php */


/** The name of the database for WordPress */
define('DB_NAME', 'wordpress');

/** MySQL database username */
define('DB_USER', 'wordpress');

/** MySQL database password */
define('DB_PASSWORD', 'wordpresspassword');

/** MySQL hostname */
define('DB_HOST', 'localhost');

?>