Install Wordpress

1. Install Apache2
sudo apt-get install apache2

2. Install php
sudo apt-get install php libapache2-mod-php (install version 7)

3. Install mysql
sudo apt-get install mysql-server php-mysql

4. Install phpmyadmin
sudo apt-get install phpmyadmin 
sudo apt-get install libapache2-mod-auth-mysql

5. Enable dynamic extensions
sudo nano /etc/php/7.0/apache2/php.ini
unmark
;extensions=msql.so ====>>> extensions=msql.so

6. Add setting parameters in /etc/apache2/apache2.conf file
sudo nano /etc/apache2/apache2.conf
Include /etc/phpmyadmin/apache.conf

7. Download wordpress latest version
Latest version here.

8. Change owner of folder var/www/html
sudo chown -R www-data:www-data html

9. Add user pi to group www-data and add permission write to group in folder var/www/html
sudo usermod -aG www-data pi
sudo chmod -R g+w html

10. Unzip all wordpress files to var/www/html

11. Set up wordpress database
sudo mysql -uroot -p
enter password for user root

mysql> create database wordpress;
output:
Query OK, 1 row affected (0.00 sec)

quit mySQL prompt
mysql>\q or exit;

12. Wordpress configuration
open browser and navigate to http://[Pi local IP address] e.x http://192.168.10.18

13. Edit /var/www/html/wp-config-sample.php
add field

database: 'wordpress' 

user: 'root'
password: 'your password'
database host: 'localhost'
table prefix: 'wp_'
save file and exit

14. Press "let's go" button and fill the required information
For version 14.10 and below root user connect using password but in 15.04 and above uses unix_socket.

A) For OS 14.10 and below

Give a site title and a username
Hit "Install Wordpress" button

 B) For OS 15.10 and above

a) change root user to use plugin"mysql_native_password" (dont work on raspbian strech x86) 

i. Verify how root connect
sudo mysql -uroot -p
mysql> use mysql;
mysql> select user, host, plugin from mysql.user;

Output:
User         host              plugin
root          localhost      unix_socket     
ii.  Set root user to use mysql_native_password plugin
mysql> update user set plugin='mysql_native_password' where User='root';
mysql> flush privileges;
mysql> exit;

sudo service mysql restart

b) create new user "pi"

sudo mysql -u root

mysql> USE mysql;
mysql> CREATE USER 'pi'@'localhost' IDENTIFIED BY 'your_password';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'pi'@'localhost';
mysql> FLUSH PRIVILEGES;
mysql> exit;


sudo service mysql restart

More information about message access denied for user 'root'@'localhost' at links below
here and here.


test login http://[Pi local IP address]/phpmyadmin
login as user: pi
password:  your_password

continue instalation of wordpress ... step 14