Knowledge base category
MySQL
69 practical guides in MySQL.
Check MariaDB Versions and Compatibility on Shared Hosting
Check your actual MariaDB/MySQL server version, maintenance coverage and application requirements before requesting a shared-hosting upgrade or move.
MySQLHow to Monitor MySQL Database Server Performance
Learn how to monitor MySQL performance with 4 essential Linux command-line tools.
MySQLHow to secure MySQL connections with SSL on Ubuntu
MySQL allows remote connections and we must protect data transfer happeneing between servers with SSL. Follow this tutorial to learn how.
MySQLHow to set up High Availability WordPress with HyperDB
HyperDB is a drop-in plugin that allows you to set up High Availability WordPress site that can work with multiple database servers at once.
MySQLHow to manage MySQL users via Command line
MySQL is one of the most popular RDBMS in the market. Follow thiss guide to learn how to effectively manage MySQL users via command line interface.
MySQLHow to manage MySQL databases with command line
MySQL is one of the most popular RDBMSes available in the market. Follow this guide to learn how to manage MySQL databases using command line.
MySQLmysqldump Export Scopes: Tables, Schema and Recovery Limits
Choose mysqldump export scope deliberately. Understand tables, schema, exclusions and database-name references, then test the intended recovery.
MySQLSetup Master-Master replication in MySQL on Ubuntu
In MySQL, you can set up master master replication. Follow this guide to learn how to set up master master replication in MySQL on Ubuntu server.
MySQLImport and Export Databases in MySQL using Command Line
MySQL provides us the feature to import and export our MySQL databases directly from the command line. Follow this tutorial to learn the same.
MySQLSet up DirectAdmin to Use a Remote MySQL Server
DA Setting Up to Use a Remote MySQL Server. We can set up MySQL to be run as on an external server when we have a large database that cannot spit up and
MySQLHow to Reset MySQL root password in Ubuntu
If you forget the MySQL root password, there is no easy way to reset it. Follow this guide to reset the MySQL root password in Ubuntu server.
MySQLSetup Nginx, MySQL, PHP (LEMP stack) on Ubuntu 16.04
LEMP stands for Linux, Nginx, MySQL and PHP. LEMP stack is a common stack to host your PHP applications. Follow this guide to set up LEMP on Ubuntu 16.04.