-
Tutorial
Being able to import and export your database is an important skill to have. You can use data dumps for backup and restoration purposes, so you can recover older copies of your database in case of an emergency, or you...
•
By
Mateusz Papiernik
MySQL
MariaDB
Databases
Backups
CentOS
Debian
Ubuntu
Open Source
-
Tutorial
Forgetting passwords happens to the best of us. If you forget or lose the root password to your MySQL or MariaDB database, you can still gain access and reset the password if you have access to the server and a sudo-e...
•
By
Mateusz Papiernik
MySQL
MariaDB
Databases
CentOS
Debian
Ubuntu
Ubuntu 16.04
-
Tutorial
MySQL is an open-source database management system. CentOS 7 prefers MariaDB, a fork of MySQL managed by the original MySQL developers and designed as a replacement for MySQL. Unless you have a specific use-case for M...
•
By
Melissa Anderson
MySQL
Databases
MariaDB
CentOS
-
Tutorial
phpMyAdmin is an application that allows users to interact with MySQL (or MariaDB) databases through a web interface. This tutorial covers the process of installing and securing phpMyAdmin on a Debian 10 server.
•
By
Mark Drake
Applications
PHP
Apache
MariaDB
Debian 10
-
Tutorial
MariaDB is an open-source database management system, commonly used as an alternative for the MySQL portion of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It is intended to be a drop-in replacement...
•
By
Brian Boucheron, Mark Drake
MariaDB
Databases
MySQL
Ubuntu
Ubuntu 20.04
-
Tutorial
MariaDB is an open-source database management system, commonly used for the MySQL portion of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack.
•
By
Justin Ellingwood, Jamon Camisso
MariaDB
MySQL
Databases
Debian 10
-
Tutorial
MariaDB is an open-source database management system, commonly installed as part of the popular LEMP stack.
In this tutorial, we will explain how to install the latest version of MariaDB on a CentOS 7 server. If you ...
•
By
Melissa Anderson
MariaDB
Databases
MySQL
CentOS
-
Tutorial
Forgetting passwords happens to the best of us. If you forget or lose the root password to your MySQL or MariaDB database, you can still gain access and reset the password if you have access to the server and a sudo-e...
•
By
Mateusz Papiernik
MySQL
MariaDB
Databases
Security
Ubuntu 18.04
-
Tutorial
A "LAMP" stack is a group of open source software that is typically installed together to enable a server to host dynamic websites and web apps. This stack typically consists of the Linux operating system, the Apache ...
•
By
Mark Drake
LAMP Stack
Apache
MariaDB
PHP
Databases
Debian 9
-
Tutorial
MariaDB is an open-source database management system, commonly used as an alternative for the MySQL portion of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It is intended to be a drop-in replacement...
•
By
Brian Boucheron
MySQL
MariaDB
Databases
Ubuntu
Ubuntu 18.04
-
Tutorial
MySQL and MariaDB are relational databases used in many unique situations. However, they can pose a security risk for your system and your data if you do not secure them properly. This guide will introduce some basi...
•
By
Justin Ellingwood
Security
MySQL
MariaDB
-
Tutorial
MySQL and MariaDB are database management software that use the SQL querying language. In this guide, we will discuss how to create and manage databases from within the MySQL or MariaDB interface. This guide will co...
•
By
Justin Ellingwood
MySQL
MariaDB
-
Tutorial
A “LAMP” stack is a group of open source software that is typically installed together to enable a server to host dynamic websites and web apps written in PHP. This term is an acronym which represents the Linux operat...
•
By
Erika Heidi
LAMP Stack
PHP
Apache
MariaDB
CentOS
-
Tutorial
Zabbix is open-source monitoring software for networks and applications. In this tutorial, you will configure a Zabbix-based monitoring system on two CentOS 7 machines. One will be configured as the server, and the ot...
•
By
Vadym Kalsin
Monitoring
Networking
High Availability
System Tools
PHP
Apache
MySQL
MariaDB
CentOS
Open Source
-
Tutorial
This article provides a real-world example of using Docker Compose to install an application, in this case WordPress with PHPMyAdmin as an extra. WordPress normally runs on a LAMP stack, which means Linux, Apache, My...
•
By
Nik van der Ploeg
Docker
WordPress
Databases
MySQL
MariaDB
PHP
Ubuntu
-
Tutorial
Django is a flexible framework for quickly creating Python applications. By default, Django applications are configured to store data into a lightweight SQLite database file. While this works well under some loads, mo...
•
By
Justin Ellingwood
MySQL
MariaDB
Django
Python
Python Frameworks
Ubuntu
-
Tutorial
In this guide, you will configure an active-active MariaDB Galera cluster. For demonstration purposes, you will configure and test three CentOS 7 Droplets that will act as nodes in the cluster. MariaDB is an open sour...
•
By
bsder
Clustering
MariaDB
Databases
High Availability
CentOS
Open Source
-
Tutorial
Databases grow over time, sometimes outgrowing the space on the file system. You can also run into I/O contention when they’re located on the same partition as the rest of the operating system. RAID, network block sto...
•
By
Melissa Anderson
MariaDB
Databases
Block Storage
CentOS
-
Tutorial
MySQL query profiling is a useful technique when trying to analyze the overall performance of a database driven application. When developing a mid to large size application, there tends to be hundreds of queries distr...
•
By
Jesse Cascio
MySQL
Server Optimization
MariaDB
-
Tutorial
SQL databases come installed with all the commands you need to add, modify, delete, and query your data. This cheat sheet-style guide provides a quick reference to some of the most commonly-used SQL commands.
•
By
Mark Drake
MySQL
PostgreSQL
MariaDB
Databases
Featured Tutorial