Sharon on the 'net

After a bit of trouble-shooting, I discovered that, while Apache may have permission to read/write according to the file permissions above, an additional set of commands need to be run to have Linux verify that Apache really does have those permissions:

sudo chcon -t httpd_sys_rw_content_t /var/www/marketing -R

if the above doesn’t work, you may need to specify certain files/dirs. Health Check plugin can come in handy for identifying those.

Sample for a file: sudo chcon -t httpd_sys_rw_content_t /var/www/marketing/wp-config.php

Since SHA-256 password hashing is used by default since version 8 of MySQL, we run into a problem if users created with this encryption are attempted with a WordPress install. Below are the commands for creating a user with the native password setup (1 create user, 2 create database, 3 give user access to database, 4 flush privileges to make changes available):

CREATE USER 'UserNameHere'@'localhost' IDENTIFIED WITH mysql_native_password;

SET PASSWORD FOR 'UserNameHere'@'localhost' = 'PasswordHere';

CREATE DATABASE IF NOT EXISTS DBNameHere COLLATE 'utf8mb4_general_ci';

GRANT ALL PRIVILEGES ON DBNameHere.* TO 'UserNameHere'@'localhost' WITH GRANT OPTION;

FLUSH PRIVILEGES;

If you wish to change the password authentication type on the root user, you can do so with the following commands:

USE mysql;

ALTER USER 'UserNameHere'@'localhost' IDENTIFIED WITH mysql_native_password BY 'PasswordHere';

FLUSH PRIVILEGES;

Occasionally, WP will have a conniption over file permissions and user/group assignments. The commands below will fix those permissions.

For Centos:

sudo chown -R apache:apache /var/www/html/ && sudo chmod -R g+w /var/www/html/ && sudo find /var/www/html/ -type d -exec chmod 755 {} \; && sudo find /var/www/html/ -type f -exec chmod 644 {} \; && sudo chmod 660 /var/www/html/wp-config.php && sudo chmod 666 /var/www/html/.htaccess

For Ubuntu:

sudo chown -R www-data:www-data /var/www/html/ && sudo chmod -R g+w /var/www/html/ && sudo find /var/www/html/ -type d -exec chmod 755 {} \; && sudo find /var/www/html/ -type f -exec chmod 644 {} \; && sudo chmod 660 /var/www/html/wp-config.php && sudo chmod 666 /var/www/html/.htaccess

For Mac:

sudo chown -R _www:_www /Library/WebServer/Documents/ && sudo chmod -R g+w /Library/WebServer/Documents/ && sudo find /Library/WebServer/Documents/ -type d -exec chmod 755 {} \; && sudo find /Library/WebServer/Documents/ -type f -exec chmod 644 {} \; && sudo chmod 660 /Library/WebServer/Documents/wp-config.php && sudo chmod 666 /Library/WebServer/Documents/.htaccess

or:

sudo chown -R _www:_www /usr/local/var/www/ && sudo chmod -R g+w /usr/local/var/www/ && sudo find /usr/local/var/www/ -type d -exec chmod 755 {} \; && sudo find /usr/local/var/www/ -type f -exec chmod 644 {} \; && sudo chmod 660 /usr/local/var/www/wp-config.php && sudo chmod 666 /usr/local/var/www/.htaccess