MariaDB

Image: How to install MySQL and MariaDB step by stepAhmet Misir­ligulshut­ter­stock

How to install MySQL and MariaDB step by step

MySQL and MariaDB are powerful, widely used re­la­tion­al database systems designed for ef­fi­ciently storing and managing struc­tured data. This com­pre­hens­ive step-by-step guide explains how to install MySQL and how to install MariaDB on various Linux dis­tri­bu­tions, showing you how to…

  • MySQL
  • Tutorials
  • SQL
  • MariaDB
Read more
Image: How to fix the ‘too many connections’ error in MySQL/MariaDBJuice Flairshut­ter­stock

How to fix the ‘too many con­nec­tions’ error in MySQL/MariaDB

The MySQL ‘too many con­nec­tions’ error in MySQL or MariaDB can cripple websites and ap­plic­a­tions if there are too many sim­ul­tan­eous con­nec­tions. In this article, we show the actions you can take to fix it. You’ll learn how to increase the maximum number of allowed con­nec­tions,…

  • Tutorials
  • SQL
  • MariaDB
Read more
Image: How to optimise MySQL/MariaDB performance on a Linux serverrangizzzShut­ter­stock

How to optimise MySQL/MariaDB per­form­ance on a Linux server

The per­form­ance of a MySQL or MariaDB database sig­ni­fic­antly impacts ap­plic­a­tion speed. With the right op­tim­isa­tions, queries can be ac­cel­er­ated, resources used more ef­fi­ciently, and bot­tle­necks avoided. This article guides you step-by-step on how to optimise MySQL/MariaDB on a…

  • MySQL
  • Tutorials
  • SQL
  • MariaDB
Read more
Image: How to fetch data with PHP mysqli_query?Virrage Imagesshut­ter­stock

How to fetch data with PHP mysqli_query?

PHP is designed to integrate easily into a website. One of the most common uses of PHP is to fetch content from a database and display it on an HTML page. This tutorial covers con­nect­ing to a MySQL/MariaDB database, re­triev­ing in­form­a­tion from a simple table with `PHP…

  • Database
  • PHP
  • Tutorials
  • SQL
  • MariaDB
Read more
Image: How to fix “error establishing a database connection” in MySQL/MariaDBOllyyshut­ter­stock

How to fix “error es­tab­lish­ing a database con­nec­tion” in MySQL/MariaDB

The ‘error es­tab­lish­ing a database con­nec­tion’ often blocks access to websites and ap­plic­a­tions using MySQL or MariaDB. Our article provides a step-by-step guide to identi­fy­ing and fixing the cause. Learn how to check cre­den­tials, reset passwords, and test con­nec­tions from the…

  • Database
  • MySQL
  • Tutorials
  • SQL
  • MariaDB
Read more
Image: How to connect a MySQL/MariaDB database to a Linux cloud server with PHPOleksiy Markshut­ter­stock

How to connect a MySQL/MariaDB database to a Linux cloud server with PHP

By con­nect­ing MySQL to a Linux server, you can link your database with a Linux cloud en­vir­on­ment. In this article, we’ll show you how to do it step by step: from creating a test database and accessing it via a PHP script to querying data. You’ll also find troubleshoot­ing tips for…

  • MySQL
  • Tutorials
  • SQL
  • MariaDB
Read more
Image: How to reset MySQL/MariaDB root passwordREDPIXEL.PLshut­ter­stock

How to reset MySQL/MariaDB root password

For­get­ting the root password in MySQL or MariaDB doesn’t need to become a serious issue. By following the right steps, you can reset a MySQL/MariaDB root password quickly and easily at any time. This dedicated guide walks you step by step through both methods and points out what…

  • Security
  • MySQL
  • Tutorials
  • SQL
  • MariaDB
Read more
Image: What are the differences between MariaDB and SQLite?Titima Ongkan­tongShut­ter­stock

What are the dif­fer­ences between MariaDB and SQLite?

MariaDB vs SQLite is a frequent com­par­is­on in the open-source database world. MariaDB is a powerful client-server system, while SQLite is a light­weight library that runs inside ap­plic­a­tions. Knowing the strengths and limits of MariaDB and SQLite helps de­velopers and busi­nesses…

  • Database
  • MariaDB
  • Com­par­is­on
  • Advice
Read more
Image: MariaDB vs. MongoDB: How do they compare?Titima Ongkan­tongShut­ter­stock

MariaDB vs. MongoDB: How do they compare?

MariaDB vs MongoDB – which database is the better fit for your project? MariaDB delivers proven SQL per­form­ance, strong data integrity and re­li­ab­il­ity, while MongoDB takes a document-oriented approach with sche­ma­less storage, built-in scalab­il­ity and flexible data modelling. In…

  • Database
  • MariaDB
  • Com­par­is­on
  • Advice
Read more
Image: How to install MariaDB via DockerTitima Ongkan­tongShut­ter­stock

How to install MariaDB via Docker

With Docker, you can set MariaDB up in just a few steps and avoid complex local in­stall­a­tion. The database runs in isolation from the rest of the system, pre­vent­ing conflicts when testing different versions. You can back up and restore data as needed to create a flexible,…

  • Tutorials
  • Docker
  • MariaDB
Read more