Install WordPress on Apache Server

Install WordPress on Apache Server

Download the wordpress files on /var/www/html or /var/www/ folder depend on the Operating System (Deb 8, Deb 7)

#cd /var/www/
#wget --no-check-certificate http://wordpress.org/latest.zip

We have to install unzip to unpack our wordpress files
Unzip the wordpress files in the /var/www/ directory:

#apt-get install install unzip
#unzip latest.zip

Move all extracted folder files to /var/www/

#cd /var/www/wordpress/
#mv * /var/www/
#rm -rf /var/www/wordpress/

We will need to create an /upload directory on /var/www/wp-content/ folder so we can make contents and upload files into it.

#mkdir -p /var/www/wp-content/uploads

Set the user, group ownership and permissions for the directory:

#chown -R www-data:www-data /var/www/
#chmod -R 755 /var/www/

Create database with mySQL
Log into mysql server as root.

[root@vpshelpdesk]#mysql -u root -p
Connect-to-mySQL-server-as-root-from-console
Create a mySQL database from console by type this
mysql>CREATE DATABASE dbuser;
create-database-mySQL
mysql>CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
mysql>GRANT ALL PRIVILEGES ON dbuser.* TO 'user'@'localhost' WITH GRANT OPTION;
mysql>CREATE USER 'user'@'%' IDENTIFIED BY 'password';
mysql>GRANT ALL PRIVILEGES ON dbuser.* TO 'user'@'%' WITH GRANT OPTION;
mysql>FLUSH PRIVILEGES;
mysql>SHOW GRANTS FOR 'user'@'localhost';
SHOW-GRANTS-FOR-user-localhost
Displaying list of users, use the SELECT USER statement

Installing WordPress via web browser http://ipaddress and follow the instruction