• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

WBXPress.NET

Website Developement Guide

  • apache2
  • nginx
  • mysql
  • php7
  • SSL
  • wordpress
  • genesis
  • caching
  • seo

mysql

Check all Table Size of a MySQL Database using Command

Updated on 20th January 2021 Leave a Comment

SELECT table_name AS “Table”,
ROUND(((data_length + index_length) / 1024 / 1024), 2) AS “Size (MB)”
FROM information_schema.TABLES
WHERE table_schema = “wbxpress”
ORDER BY (data_length + index_length) DESC;

Filed Under: mysql

Commands to Host WordPress in LEMP (Ubuntu 20.04)

Updated on 18th January 2021 Leave a Comment

Necessary commands to host a LEMP stack in Ubuntu 20.04 in a Lionde VPS. These commands are applicable for any other VPS too e.g. Digital Ocean. First thing you need to buy a VPS. Its start with a price of $5 per month where you can host unlimited websites.

Filed Under: mysql, nginx, php7, SSL, wordpress Tagged With: linode, ubuntu

Host Multiple Sites with SSL in Ubuntu 20.04

Updated on 27th August 2020 Leave a Comment

We will show only the commands necessary for hosting website. We will also show how to use https i.e. SSL for the websites. Your website can be of any type. We are showing WordPress installation although the commands are almost same.

Filed Under: mysql, nginx, php7, SSL, wordpress Tagged With: linode, ubuntu

Host Multiple Sites with SSL in Ubuntu 18.04

Updated on 29th August 2018 Leave a Comment

In this tutorial we shall share all the commands necessary to host multiple websites in a VPS server. We used VPS servers from Linode and Digital Ocean. Both are excellent and best value for money.

Filed Under: mysql, nginx, php7, SSL, wordpress Tagged With: linode, ubuntu

Host Multiple Sites with SSL in LAMP

Updated on 12th August 2017 Leave a Comment

How to host multiple websites in a single VPS in LAMP environment. All sites will use SSL certificates (https). All commands are for shown considering Ubuntu linux.

Filed Under: apache2, mysql, php7, SSL Tagged With: ubuntu

Add Administrator of WordPress through MySQL

Updated on 15th October 2016 2 Comments

If you can not login to your wordpress site using administrator account in conventional methos, then you may create another administrator account using mysql commands.

Filed Under: mysql, troubleshooting, wordpress

  • Go to page 1
  • Go to page 2
  • Go to Next Page »

Primary Sidebar

Most Popular Posts

  • Remove/ Defer Render-blocking JavaScripts
  • Customizing Genesis eleven40-pro Theme
  • Free Genesis Child Theme by WBXPress
  • Host Multiple Sites with SSL in Ubuntu 18.04
  • 25 Ways to Boost Website Traffic that Really Work

Recent Comments

  • Ruhul on Customizing Genesis eleven40-pro Theme
  • Priya Agarwal on Customizing Genesis eleven40-pro Theme
  • mimi roy on Remove/ Defer Render-blocking JavaScripts
  • danish choudhary on Customizing Genesis eleven40-pro Theme
  • Radhe on Customizing Genesis eleven40-pro Theme

Copyright © 2021 · Powered by WordPress · Log in