Archives For
wordpress

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 user needs to enter or customize will be in red in this tutorial!

Now, go to http://UBUNTUSERVERIP/phpmyadmin/ in your client’s browser and type in root and the password you set when MySQL was installed to login.

phpmyadmin login

2. Follow the below steps to create database and user with same name.

Step 1 – Click on Users then click Add User.
Step 2 – Type in your desired User name (wordpress is a good one) and ensure Use text field is selected. Ensure Host is set to Local from the drop down list and the text box will change to localhost and enter a Password and then confirm it in the Re-type box. Ensure the Password Use text field is also selected.
Step 3 – Check the box that says Create database with same name and grant all priviliges.
Step 4 – Click on Go.

phpmyadmin create user and database

2. Download & Config WordPress:

Download the latest wordpress from its official website:

cd && wget http://wordpress.org/latest.tar.gz

Decompress the package:

tar -xzvf latest.tar.gz

Go to the result folder and create the configuration file by copying the sample file:

cd wordpress/ && cp wp-config-sample.php wp-config.php

Edit the wordpress configuration file via vi editor:

vi wp-config.php

Find the section that contains the field below and substitute in the correct name for your database, username, and password:

// ** MySQL settings – You can get this info from your web host ** //
/** The name of the database for WordPress */
define(‘DB_NAME’, ‘DATABASE_NAME_HERE‘);

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 in this tutorial!

1. Create MySQL Database and User for WordPress

If you’re using LAMP, install PhpMyAdmin to get a graphical way setting your MySQL Database.

To install PhpMyAdmin, run command below in Ubuntu server:

sudo apt-get install phpmyadmin

Choose apache2 webserver while the installing process and say NO to “Configure database for phpmyadmin with dbconfig-common?”

Now, go to http://UBUNTUSERVERIP/phpmyadmin/ in your client’s browser and type in root and the password you set when MySQL was installed to login.

phpmyadmin login

Follow the steps below to create Database and user:

Step 1 – Click on Users then click Add User.
Step 2 – Type in your desired User name (wordpress is a good one) and ensure Use text field is selected. Ensure Host is set to Local from the drop down list and the text box will change to localhost and enter a Password and then confirm it in the Re-type box. Ensure the Password Use text field is also selected.
Step 3 – Click on Create database with same name and grant all priviliges.
Step 4 – Click on Go.