{"id":3232,"date":"2014-04-26T07:37:05","date_gmt":"2014-04-26T07:37:05","guid":{"rendered":"http:\/\/ubuntuhandbook.org\/?p=3232"},"modified":"2014-04-26T07:37:05","modified_gmt":"2014-04-26T07:37:05","slug":"install-set-up-wordpress-ubuntu-14-04","status":"publish","type":"post","link":"https:\/\/ubuntuhandbook.org\/index.php\/2014\/04\/install-set-up-wordpress-ubuntu-14-04\/","title":{"rendered":"Install and Set up WordPress in Ubuntu 14.04 Server"},"content":{"rendered":"

\"install<\/a><\/p>\n

Already installed LEMP<\/a> or LAMP<\/a> on your Ubuntu server? Well, now it’s time to install wordpress CMS and get your site running!<\/p>\n

As you may know, wordPress is a popular blogging tool and a content management system (CMS) based on PHP and MySQL. It’s free and open-source. In the steps below the lines that the user needs to enter or customize will be in red<\/span> in this tutorial!<\/b><\/p>\n

1. Setup Mysql Database for WordPress<\/h3>\n

For LEMP (Ubuntu, Nginx, Mysql, Php) without phpmyadmin installed:<\/b><\/p>\n

Database name: wordpress_db<\/span>; user name: ubuntuhandbook<\/span>; password: 12345678<\/span>; Change them in the code below.<\/p>\n

Step 1 – Run command in Ubuntu Server to log into MySQL Shell with MySQL root password:<\/p>\n

mysql -u root -p<\/pre>\n
Step 2 – Create database, here I named it wordpress_db:<\/p>\n
CREATE DATABASE wordpress_db;<\/span><\/pre>\n
Step 3 – Create a new user named ubuntuhandbook:<\/p>\n
CREATE USER ubuntuhandbook<\/span>@localhost;<\/pre>\n
Step 4 – Set a password for this user:<\/p>\n
SET PASSWORD FOR ubuntuhandbook<\/span>@localhost= PASSWORD(\"12345678<\/span>\");<\/pre>\n
Step 5 – Grant all privileges to the new user:<\/p>\n
GRANT ALL PRIVILEGES ON wordpress_db<\/span>.* TO ubuntuhandbook<\/span>@localhost IDENTIFIED BY '12345678<\/span>';<\/pre>\n
Step 6 – Refresh MySQL:<\/p>\n
FLUSH PRIVILEGES;<\/pre>\n
Exit MySQL shell:<\/p>\n
exit<\/pre>\n<\/blockquote>\n
For LAMP (Apache2, Mysql, Php, Ubuntu Linux):<\/b><\/p>\n
If you’ve installed LEMP and want to use PhpMyadmin to manage database, click the link in the top of this tutorial.<\/p>\n
1. Install Phpmyadmin:<\/p>\n
sudo apt-get install phpmyadmin<\/pre>\n
Choose apache2<\/b> webserver during the installing process and say NO<\/b> to “Configure database for phpmyadmin with dbconfig-common?”<\/p>\n
Once installed, run commands below to get it working:<\/p>\n
sudo sh -c 'echo \"Include \/etc\/phpmyadmin\/apache.conf\" >> \/etc\/apache2\/apache2.conf' && sudo service apache2 restart<\/pre>\n
Now, go to http:\/\/UBUNTUSERVERIP\/phpmyadmin\/<\/u> in your client’s browser and type in root<\/b> and the password you set when MySQL was installed to login.<\/p>\n
\"phpmyadmin<\/a><\/p>\n
phpmyadmin login<\/p>\n<\/div>\n
2. Follow the below steps to create database and user with same name.<\/p>\n
Step 1 – Click on Users<\/b> then click Add User<\/b>.
\nStep 2 – Type in your desired User name<\/b> (wordpress is a good one) and ensure Use text field<\/b> is selected. Ensure Host<\/b> is set to Local<\/b> from the drop down list and the text box will change to localhost<\/b> and enter a Password<\/b> and then confirm it in the Re-type<\/b> box. Ensure the Password Use text field is also selected.
\nStep 3 – Check the box that says Create database with same name and grant all priviliges.<\/b>
\nStep 4 – Click on Go<\/b>.<\/p>\n<\/blockquote>\n
\"phpmyadmin<\/a><\/p>\n
phpmyadmin create user and database<\/p>\n<\/div>\n
2. Download & Config WordPress:<\/h3>\n
Download the latest wordpress from its official website:<\/p>\n
cd && wget http:\/\/wordpress.org\/latest.tar.gz<\/pre>\n
Decompress the package:<\/p>\n
tar -xzvf latest.tar.gz <\/pre>\n
Go to the result folder and create the configuration file by copying the sample file:<\/p>\n
cd wordpress\/ && cp wp-config-sample.php wp-config.php<\/pre>\n
Edit the wordpress configuration file via vi editor:<\/p>\n
vi wp-config.php<\/pre>\n
Find the section that contains the field below and substitute in the correct name for your database, username, and password:<\/p>\n
\/\/ ** MySQL settings – You can get this info from your web host ** \/\/
\n\/** The name of the database for WordPress *\/
\ndefine(‘DB_NAME’, ‘DATABASE_NAME_HERE<\/span>‘);<\/p>\n
\/** MySQL database username *\/
\ndefine(‘DB_USER’, ‘USER_NAME_HERE<\/span>‘);<\/p>\n
\/** MySQL database password *\/
\ndefine(‘DB_PASSWORD’, ‘PASSWORD_HERE<\/span>‘);<\/p>\n<\/blockquote>\n
Press i<\/b> to start editing, and Esc<\/b> to end editing. Finally press Shift+:<\/b> followed by wq<\/b> and Enter to save and exit the file.<\/p>\n
3. Copy Files and Set Ownership:<\/h3>\n
Now move WordPress files to webserver root directory:<\/p>\n
For LAMP:<\/p>\n
cd && sudo rsync -avP wordpress\/ \/var\/www\/<\/pre>\n
For LNMP:<\/p>\n
cd && sudo rsync -avP wordpress\/ \/usr\/share\/nginx\/html\/<\/pre>\n<\/blockquote>\n
Set ownership of the root directory:<\/p>\n
cd \/var\/www\/  ###For nginx: cd \/usr\/share\/nginx\/html\/\n\nsudo chown www-data:www-data * -R \n\nsudo usermod -a -G www-data www-data<\/pre>\n
4. Install WordPress:<\/h3>\n
Finally in your client’s web browser go to http:\/\/UBUNTUSERVERIP\/wp-admin\/install.php<\/u> and install your wordpress site:<\/p>\n
\"installing<\/a><\/p>\n
installing wordpress<\/p>\n<\/div>\n
Once done, if you still get “It Works!” Apache page. Run command below to edit dir.conf:<\/p>\n
sudo vi \/etc\/apache2\/mods-enabled\/dir.conf<\/pre>\n
You will see a line of index files (index.html, index.php, index.cgi, etc) under the DirectoryIndex setting. Add index.php<\/b> as the first item in the list.<\/p>\n
After that, restart Apache server by:<\/p>\n
sudo service apache2 restart<\/pre>\n
Now you can access your new website:<\/p>\n
\"wordpress<\/a><\/p>\n
wordpress site<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"
Already installed LEMP or LAMP on your Ubuntu server? Well, now it’s time to install wordpress CMS and get your site running! As you may know, wordPress is a popular blogging tool and a content management system (CMS) based on PHP and MySQL. It’s free and open-source. In the steps below the lines that the […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[855,158],"class_list":["post-3232","post","type-post","status-publish","format-standard","hentry","category-howtos","tag-ubuntu-14-04","tag-wordpress"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ubuntuhandbook.org\/index.php\/wp-json\/wp\/v2\/posts\/3232","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ubuntuhandbook.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ubuntuhandbook.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ubuntuhandbook.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ubuntuhandbook.org\/index.php\/wp-json\/wp\/v2\/comments?post=3232"}],"version-history":[{"count":0,"href":"https:\/\/ubuntuhandbook.org\/index.php\/wp-json\/wp\/v2\/posts\/3232\/revisions"}],"wp:attachment":[{"href":"https:\/\/ubuntuhandbook.org\/index.php\/wp-json\/wp\/v2\/media?parent=3232"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ubuntuhandbook.org\/index.php\/wp-json\/wp\/v2\/categories?post=3232"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ubuntuhandbook.org\/index.php\/wp-json\/wp\/v2\/tags?post=3232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}