Search results

…Enable Remote Mysql Access…iate privileges to a new or existing user in MySQL using the command line…in replacement for the MySQL database system. However…

How to enable Remote access to your MariaDB/MySQL database on Ubuntu Bionic or MariaDB < v10.6

perfect server configuration mysql mariadb

Last updated: December 28th 2022

How to back up your MariaDB/MySQL database

configuration mysql mariadb

…rticle outlines steps on how to back up your MySQL…MySQL to flush any transactions which have not bee…mysql…mysql…my.cnf For MySQL 8…mysql…mysql.conf.d…mysqld.cnf The directives for MySQL 8 will be similar…

Last updated: December 6th 2022

How to check for open ports on your Ubuntu server

security configuration

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

…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 …

Ubuntu LAMP 8.1

perfect server apache php8.1

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

Migrating a Wordpress site to Webdock

wordpress migration

Last updated: July 19th 2022

Upgrading to PHP8 on Webdock Focal Stacks

perfect server upgrade guide php8.0

…mysql php7.4…mysql php8.0…

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

Ubuntu LAMP 7.2

perfect server php7.2 apache

…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 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 …

Load Balancing

Load Balancing CloudFlare

Last updated: November 8th 2022

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

Frequently Asked Questions (FAQ)

webdock FAQ

…mysqli…

Last updated: December 29th 2022

Ubuntu LEMP 8.1

nginx perfect server php8.1

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

Upgrading or Downgrading PHP Versions

php upgrade guide downgrade guide

…mysql php7.4…

…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

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

Ubuntu LAMP 7.3

perfect server php7.3 apache

…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

…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

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

Ubuntu LEMP 7.4

nginx perfect server php7.4

Last updated: January 17th 2023

Upgrading your webservers from Ubuntu Bionic to Ubuntu Focal

upgrade guide ubuntu bionic focal

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

Last updated: July 15th 2020

Upgrading your webservers from Ubuntu Focal to Ubuntu Jammy

upgrade guide ubuntu focal jammy

… mysqldump … mysql …

Last updated: May 11th 2022

Laravel and Redis 5 - A Functional Example

redis laravel

… 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…

Last updated: October 8th 2020

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…

…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

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

Ubuntu LEMP 7.1

nginx perfect server php7.1

… mysql… mysql…mysql lsphp80…

How to install OpenLiteSpeed on Webdock

perfect server configuration openlitespeed

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

Ubuntu LEMP 7.3

nginx perfect server php7.3

…Nginx and MySQL nitty…MySQL…

Introduction to our Perfect Server Stacks

perfect server

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

Privacy Impact Assessment

gdpr Information

…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

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

How to set up Runcloud on Webdock

3rd party control panel Runcloud

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

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

API Callback Events

webdock-api

Last updated: November 10th 2020

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: October 29th 2022

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…

…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…mysqld…mysqld…mysql…mysql…

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

nginx apache ubuntu optimization

Last updated: November 22nd 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: March 24th 2023

How to set up Gridpane on Webdock

3rd party control panel GridPane

… MySQL or MariaDB …

Last updated: December 7th 2022

How to Install Open Game Panel on Your Webdock Server

game server panel

…mysql php7.4…

Ubuntu LAMP 7.4

perfect server apache php7.4

…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 …

…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

…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

Common Certbot Errors

configuration ssl troubleshooting

…mysqld tcp 0 0 127.0.0.1…

Last updated: July 6th 2022

Database Guides

perfect server configuration mysql mariadb

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