Original post from devanswers.co, In this guide we will install and secure phpMyAdmin to work with Apache on Ubuntu Server 20.04. Prerequisites You should be using a non-root user with sudo privileges as explained in Ubuntu 20.04 Initial Server Setup. You should also have your LAMP stack for Ubuntu 20.04 already installed and serving web pages before continuing…
Month: May 2024
Ubuntu 20.04 Initial Server Setup
Original post from devanswers.co, In this guide we will configure your new Ubuntu 20.04 server and implement some best practices. Prerequisites If you are accessing Ubuntu Server 20.04 remotely and don’t know how to access terminal via SSH, please see one of the following guides: How to Log into Linux from Windows using PuTTY How…
How To Install Apache, MySQL, PHP (LAMP) Stack on Ubuntu 20.04 / 20.10
Original post from devanswers.co, In this guide we will install a LAMP Stack (Apache, MySQL, PHP) on Ubuntu Server 20.04 / 20.10 and configure a web server. Prerequisites You should use a non-root user account with sudo privileges. Please see the Initial server setup for Ubuntu 20.04 / 20.10 guide for more details. 1. Install Apache The…
WordPress .htaccess Basic
# BEGIN WordPress RewriteEngine On RewriteRule .* – [E=HTTP_AUTHORIZATION:%{HTTP:Authorization}] RewriteBase / RewriteRule ^index\.php$ – [L] RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule . /index.php [L] # END WordPress
WooCommerce Bulk Delete
1. Bulk Delete All Orders DELETE FROM wp_woocommerce_order_itemmeta; DELETE FROM wp_woocommerce_order_items; DELETE FROM wp_comments WHERE comment_type = ‘order_note’; DELETE FROM wp_postmeta WHERE post_id IN ( SELECT ID FROM wp_posts WHERE post_type = ‘shop_order’ ); DELETE FROM wp_posts WHERE post_type = ‘shop_order’; 2. Bulk Delete All Products DELETE FROM wp_postmeta WHERE post_id IN ( SELECT ID…
WP-CLI Import Content
Rather than using the WordPress admin to import a WXR file, you might find it helpful to use WP-CLI instead. By importing with WP-CLI instead of the WordPress admin, you’ll also have additional options available to you, such as skipping certain types of data. Importing WordPress WXR (.xml) Files To perform a simple import of…
Apache sub post/page not found
In gara-gara setting di apache2.conf, sudo nano /etc/apache2/apache2.conf Ganti : <Directory /var/www/> Options Indexes FollowSymLinks AllowOverride None Require all granted </Directory> Dengan : <Directory /var/www/> Options Indexes FollowSymLinks AllowOverride All Require all granted </Directory>
Apache error “Could not reliably determine the server’s fully qualified domain name”
This is just a friendly warning and not really a problem (as in that something does not work). If you go to: /etc/apache2/apache2.conf and insert: ServerName localhost and then restart apache by typing into the terminal: sudo systemctl reload apache2 the notice will disappear. If you have a name inside /etc/hostname you can also use that name…
Setting Apache, Mysql, PHP
Follow : https://devanswers.co/install-apache-mysql-php-lamp-stack-ubuntu-20-04/ Common Errors : Failed! Error: SET PASSWORD has no significance for user ‘root’@’localhost’ as the authentication method used doesn’t store authentication data in the MySQL server. Please consider using ALTER USER instead if you want to change authentication parameters. Solution : Login as root, sudo mysql, ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password…
Nambah Virtual Host Apache
Create a new directory in /var/www/ for your domain. Just replace mydomain.com with your own. sudo mkdir -p /var/www/mydomain.com 8.2. Create Virtual Host Create a virtual host configuration file replacing mydomain.com with your own. sudo nano /etc/apache2/sites-available/mydomain.com.conf Enter the following replacing mydomain.com with your own. <VirtualHost *:80> ServerAdmin webmaster@mydomain.com ServerName mydomain.com ServerAlias www.mydomain.com DocumentRoot /var/www/mydomain.com/public_html…