Search results

…in replacement for the MySQL database system. However… will allow you to switch your database from MySQL to MariaDB without having to alter your appl…agement software with your databases such as MySQL Workbench…

How to enable Remote access to your MariaDB/MySQL database on Ubuntu Focal / MariaDB > v10.6

perfect server configuration mysql mariadb

…Enable Remote MySQL Access…

Managing MySQL Databases

getting started

Last updated: February 11th 2025

MySQL Guides

perfect server configuration mysql mariadb

How to enable Remote access to your MariaDB/MySQL database and other MariaDB/MySQL guides.

Last updated: February 26th 2025

Upgrading or Downgrading PHP Versions

php upgrade guide downgrade guide

…mysql php7.4…

Last updated: October 24th 2023

Introduction to our Perfect Server Stacks

perfect server

…Nginx and MySQL nitty…MySQL…

…MySQL… Secure your MariaDB installation mysql_secure_installation Point PHP CLI to PHP v…config.inc.php mysql …mysql php5.6…Nginx Mysql and PHP…

Ubuntu LEMP 5.6

nginx perfect server php5.6

…tcp open mysql …mysql 0.0.0.0…mysql 0.0.0.0…mysql 0.0.0.0…

How to check for open ports on your Ubuntu server

security configuration

…MySQL… Secure your MariaDB installation mysql_secure_installation Update PHP CLI configu…config.inc.php mysql …mysql php5.6…Linux Apache Mysql and PHP…

Ubuntu LAMP 5.6

perfect server php5.6 apache

…ebug Secure your MariaDB installation mysql_secure_installation Now disable the defau…mysql php7.4…MySQL…Linux Apache Mysql and PHP…config.inc.php mysql …

Ubuntu LAMP 7.4

perfect server apache php7.4

Last updated: September 7th 2023

Common Certbot Errors

configuration ssl troubleshooting

…mysqld tcp 0 0 127.0.0.1…

Last updated: July 6th 2022

How to Install Open Game Panel on Your Webdock Server

game server panel

…mysql php7.4…

Last updated: July 19th 2023

Laravel development server with aaPanel on Webdock VPS for beginners - Part 2

configuration laravel

… we are going to setup MySql root password. Worth mentioning… MySql root user IS NOT system user … choose a different password for the MySql root. Generally…

Last updated: December 24th 2021

Ubuntu LAMP

perfect server apache php

…ebug Secure your MariaDB installation mysql_secure_installation Now disable the defau…Linux Apache Mysql and PHP…mysql php8.3…MySQL…mysql…config.inc.php mysql …

…ebug Secure your MariaDB installation mysql_secure_installation Now disable the defau…MySQL…config.inc.php mysql …Linux Apache Mysql and PHP…mysql php8.2…

Ubuntu Jammy LAMP 8.2

perfect server apache php

… we are going to pull it from MySQL and store it in Redis before serving it to t…e can make sure the post will be pulled from MySQL only once… then if it is not present pull data from MySQL…

Laravel and Redis 5 - A Functional Example

redis laravel

Last updated: February 24th 2025

Ubuntu LEMP

nginx perfect server php

…ebug Secure your MariaDB installation mysql_secure_installation Symlink phpMyAdmin…Nginx Mysql and PHP…mysql php8.3…MySQL…mysql…config.inc.php mysql …

…ebug Secure your MariaDB installation mysql_secure_installation Symlink phpMyAdmin…MySQL…config.inc.php mysql …Nginx Mysql and PHP…mysql php8.2…

Ubuntu Jammy LEMP 8.2

nginx perfect server php

…ebug Secure your MariaDB installation mysql_secure_installation Symlink phpMyAdmin…MySQL…mysql php8.1…Nginx Mysql and PHP…config.inc.php mysql …

Ubuntu LEMP 8.1

nginx perfect server php8.1

Last updated: May 10th 2023

Upgrading your webservers from Ubuntu Focal to Ubuntu Jammy

upgrade guide ubuntu focal jammy

… mysqldump … mysql …

Last updated: May 11th 2022

Ubuntu LEMP 7.4

nginx perfect server php7.4

…ebug Secure your MariaDB installation mysql_secure_installation Symlink phpMyAdmin…mysql php7.4…MySQL…Nginx Mysql and PHP…config.inc.php mysql …

Last updated: September 7th 2023

How to install OpenLiteSpeed on Webdock

configuration openlitespeed OLS

…mysql lsphp80…

Last updated: March 29th 2023

Privacy Impact Assessment

gdpr Information

…Webdock server. Here the data is stored in a MySQL database. The user password is encrypted and… MySQL…

Last updated: February 7th 2025

Frequently Asked Questions (FAQ)

webdock FAQ

…mysqli…

Ubuntu LAMP 7.3

perfect server php7.3 apache

…MySQL… Secure your MariaDB installation mysql_secure_installation Restart your server …mysql php7.3…config.inc.php mysql …Linux Apache Mysql and PHP…

…html Run mysqldump …data . Import your database mysql …

Upgrading your webservers from Ubuntu Bionic to Ubuntu Focal

upgrade guide ubuntu bionic focal

Last updated: July 15th 2020

How to free up disk space on an Ubuntu Nginx or Apache Web Server

nginx apache ubuntu optimization

…press site that just needs the webserver and MySQL … really have to. If you notice that the MySQl log is very big in …mysql …mysql…mysql…mysqld…mysqld…mysql…

Last updated: October 16th 2023

Database and tracking JSON Web Tokens (JWT) (Part 3)

laravel JWT

… here we will use standard MySql database. In production software…

Last updated: May 25th 2021

Ubuntu LAMP 7.2

perfect server php7.2 apache

…MySQL… Secure your MariaDB installation mysql_secure_installation Update PHP CLI configu…config.inc.php mysql …mysql php7.2…Linux Apache Mysql and PHP…

…ebug Secure your MariaDB installation mysql_secure_installation Symlink phpMyAdmin…Nginx Mysql and PHP…config.inc.php mysql …mysql php7.4…MySQL…

Ubuntu Focal LEMP 7.4

nginx perfect server php7.4

… you will be provided MySQL credentials in the terminal. Copy them to a …

How to set up Runcloud on Webdock

3rd party control panel Runcloud

Last updated: July 29th 2024

Load Balancing

Load Balancing CloudFlare

…MySQL access. You will need at least 4 servers to …u need To allow remote connections to a MySQL server… Configure the MySQL server to listen for specific IP addresses …

Last updated: November 8th 2022

How to enable Encryption for MariaDB

security mariadb

…yone can read plaintext data stored in them. MySQL tables are stored in …mysql…mysql…mysql…mysql…mysql…mysql…mysql…mysql…mysql…mysql…mysql…mysql…mysql…R mysql…mysql…mysql…

Last updated: October 29th 2024

Ubuntu LEMP 7.1

nginx perfect server php7.1

…mysql php7.1…MySQL… Secure your MariaDB installation mysql_secure_installation Install PHPMyAdmin …Nginx Mysql and PHP…

…ebug Secure your MariaDB installation mysql_secure_installation Now disable the defau…config.inc.php mysql …MySQL…Linux Apache Mysql and PHP…mysql php8.1…

Ubuntu Focal LAMP 8.1

perfect server apache php8.1

…mysql…e DB running on the second machine using the MySQL CLI. There it is…

Private Communication Between Your Webdock Servers using Tailscale

networking VLAN

Last updated: January 18th 2024

Migrating a Wordpress site to Webdock

wordpress migration

… shared hosting environment. Run mysqldump …data . Import your database mysql …

Last updated: July 19th 2022

Upgrading to PHP8 on Webdock Focal Stacks

perfect server upgrade guide php8.0

…mysql php7.4…mysql php8.0…

… and the level of security required. MySQL…

Part 4: Typical Software You Need on Your Linux Web Server

Web Fundamentals Web Server Management

Last updated: July 19th 2023

Ubuntu LEMP 7.3

nginx perfect server php7.3

…MySQL… Secure your MariaDB installation mysql_secure_installation Install Letsencrypt Ce…mysql php7.3…config.inc.php mysql …Nginx Mysql and PHP…

…tcp You can also allow the MySQL and HTTPS service by referencing them by nam… ufw allow mysql ufw allow https Add the UFW rule to allo…allow mysql…

How to work with your firewall (UFW - Uncomplicated Firewall)

firewall perfect server ufw

Last updated: January 10th 2024

Ubuntu LAMP 7.1

perfect server apache php7.1

…mysql php7.1…MySQL… Secure your MariaDB installation mysql_secure_installation Install Mongodb a…Linux Apache Mysql and PHP…

…html Run mysqldump …data . Import your database mysql …

Upgrading your webservers from Ubuntu Xenial to Ubuntu Bionic

upgrade guide ubuntu xenial bionic

Last updated: September 15th 2019

How to set up Gridpane on Webdock

3rd party control panel GridPane

… MySQL or MariaDB …

Last updated: February 25th 2025

How to install and run docker containers using docker-compose

Docker

… mysql_service… Now under the mysql_service option… we will add mysql container options as key value pairs. The im… part of. So the final compose file for mysql service will look like this. version…

Last updated: February 19th 2025

Ubuntu Focal LAMP 7.4

perfect server apache php7.4

…ebug Secure your MariaDB installation mysql_secure_installation Now disable the defau…Linux Apache Mysql and PHP…config.inc.php mysql …mysql php7.4…

…MySQL… Secure your MariaDB installation mysql_secure_installation Update PHP CLI configu…config.inc.php mysql …mysql php7.2…Nginx Mysql and PHP…

Ubuntu LEMP 7.2

nginx perfect server php7.2

… index.php Update MySQL Connection Parameters Now you need to up… file. This file contains configuration for MySQL settings…ble prefix and ABSPATH. Change the necessary MySQL connection parameters only such as highlight…

How to Migrate Your Website From CPanel to Webdock

migration 3rd party control panel cPanel

Last updated: May 13th 2021

API Callback Events

webdock-api

…mysql Called whenever a Mysql database is created…dbuser Called whenever a Mysql user is created…

Last updated: November 10th 2020

Ubuntu LAMP 8.1

perfect server apache php8.1

…ebug Secure your MariaDB installation mysql_secure_installation Now disable the defau…MySQL…mysql php8.1…Linux Apache Mysql and PHP…config.inc.php mysql …

Last updated: May 10th 2023

Part 12: PHP Configuration and Optimization

configuration Web Server Management

… such as MySQL…

…ebug Secure your MariaDB installation mysql_secure_installation Symlink phpMyAdmin…config.inc.php mysql …MySQL…Nginx Mysql and PHP…mysql php8.1…

Ubuntu Focal LEMP 8.1

nginx perfect server php8.1

…based tool that simplifies managing MySQL databases. It offers a user… those who need to be better versed with the MySQL prompt. For many users… having a database management system like MySQL is a necessity. However…

Top Tools to Install on Your Ubuntu Web Server

ubuntu optimization linux

Last updated: July 19th 2023

How to Move a Wordpress Website from Laravel Forge to Webdock

wordpress migration Laravel Forge

… mysqldump … This command will create a backup of your MySQL database and save it in the …

… mysqldump … a MySQL database by creating a .sql file containing …

How to Move A Wordpress Website from Serverpilot to Webdock

wordpress migration ServerPilot

Last updated: November 28th 2024

How we optimized provision time from 4 minutes to 25 seconds

webdock optimization

… mysql etc. …

Beginner's Guide: Clustered vs Non-clustered Index

database

…Specific Clustered Index Implementations MySQL …

Last updated: February 3rd 2025

Node.js boilerplate Typescript, Express, Prisma

nodejs javascript typescript express

… MySQL…

Last updated: February 6th 2025

Nodejs: Implementing a Basic Authentication Mechanism

nodejs

…tion you may want to switch to PostgreSQL or MySQL…

Last updated: February 7th 2025

How To Install Uptime Kuma on Your Webdock Server

configuration Installation monitoring

… you might want to consider using MySQL or PostgreSQL. After you…

Last updated: February 27th 2025

Secure VPS Communication with SSL and UFW

configuration

…ndational step in safeguarding services like MySQL and NGINX. Let… Securing MySQL with UFW Let…'s first secure a MySQL server by ensuring it accepts connections on…

Last updated: March 4th 2024

Guide to Increasing Open File Limits for Nginx, Apache2, and Linux

nginx apache configuration webserver

…cated for other services such as MariaDB and MySQL where this issue usually occurs. Increas…

Last updated: March 3rd 2025

A Guide to Installing ERPNext on Your Webdock Server

App Installation

…y MySQL client library development files We…ll need the MySQL client library to enable applications to com…municate with the MySQL database server by handling connection…

Last updated: February 21st 2025

Beyond the Basics: Understanding Socket Statistics

networking linux

… 3306 Displays all TCP connections to MySQL port …

Last updated: March 24th 2025

A Quick Guide to Managing Systemd Services

configuration linux

…user.target Systemd file for MySQL This service file is responsible for man…aging the MySQL database server. It specifies how to start a…nd stop the MySQL service and ensures it restarts on failure. …

Last updated: August 13th 2024

What Is Netcat and How To Use It

networking

… MySQL…

Last updated: April 28th 2025

Selfhost All Your Sites with A Few Clicks using Coolify

configuration App

… MySQL…

Last updated: May 6th 2025

How to Benchmark PHP Performance on Your Webdock Server

benchmarking php

… including how to incorporate MySQL benchmarks for a thorough analysis. Why B…O and MySQL performance…Server...................................... mysqlbench Max memory usage....................…

…database management system. Ghost recommends MySQL 8… apt install mysql…y Once you've installed MySQL… mysql_secure_installation You will be prompted…

How to Install Ghost CMS on a Webdock Server

configuration

Last updated: February 24th 2025

How to Move A Wordpress Website from SpinupWP to Webdock

wordpress migration SpinupWP

… mysqldump …

… mysqldump … of a MySQL database and save it in the …

How to Move A Wordpress Website From Ploi to Webdock

wordpress migration Ploi