Skip to main content

Install WordPress 3.1.3 on Ubuntu 11.04

WordPress is web application you can use to create a beautiful blog or website. This is an open source software. You can get it free at http://wordpress.org/download/ . Before you install WordPress on Ubuntu 11.04 (Natty Narwhal), make sure you already install on your Linux machine: Apache, MySQL and PHP (LAMP).

1. Unzip wordpress-3.1.3.zip to a specified.

2. Make the virtual path for Apache web server:
sudo gedit /etc/apache2/httpd.conf
add a new line:
Alias /wordpress /home/yourusername/wordpress
and
restart sudo /etc/init.d/apache2 restart

3. Type http://127.0.0.1/wordpress/readme.html on your browser to read some instruction.

4. Create MySQL database and user for WordPress

mysql -u root -p
mysql> use mysql;
mysql> create database wordpress;
mysql> INSERT INTO user (Host,User,Password) VALUES('localhost','wpuser',PASSWORD('wppass'));
mysql> grant all privileges on wordpress.* to wpuser@localhost;
mysql> flush privileges;
mysql> exit;

5. chmod -c 777 -R ~/wordpress

6. Type http://127.0.0.1/wordpress/wp-admin/install.php to install.
If you got this error message: "Error establishing a database connection", make sure user name and password are correct. It took me almost an hour to figure it out. For some reason, my MySQL password for wpuser@localhost is empty instead of a specified password that I set when I create a MySQL user account.

Comments

Popular posts from this blog

Visual Studio 2010 Keyboard Shortcuts

These keyboard shortcuts are helpful. Some of them are not document in Visual Studio 2010 Express, for example: <Ctrl> F5 to run the application without debug <Ctrl> Period or <Ctrl> Space for code completion. <Ctr> <Shift> <B> to build the solution For more download the Visual Studio 2010 Keybinding Posters from Microsoft. Credit:  Visual Studio 2010 Keyboard Shortcuts - ScottGu's Blog DevCurry: 30 Favorite Visual Studio Keyboard Shortcuts

SQL Questions and Answers - Part 3

What is a view? A view can be thought of as either a virtual table or a stored query. The data accessible through a view is not stored in the database as a distinct object. What is stored in the database is a SELECT statement. The result set of the SELECT statement forms the virtual table returned by the view. ( msdn.microsoft.com ) What is an Index? A Microsoft® SQL Server™ index is a structure associated with a table or view that speeds retrieval of rows from the table or view. An index contains keys built from one or more columns in the table or view. These keys are stored in a structure that allows SQL Server to find the row or rows associated with the key values quickly and efficiently. ( msdn.microsoft.com ) What are all the different types of indexes? These are different types of indexes in Microsoft SQL Server 2008R2: Clustered : A clustered index sorts and stores the data rows of the table or view in order based on the clustered index key. The clustered index is implemente

Recent Activity

It’s fun to check my email account recent activity. Here is the fun. Someone attempted to log in to my account from other countries. It is good to check activity log in your Gmail, Hotmail, Yahoo, Facebook, and other accounts frequently.