·
Migrate MySQL to MariaDB on Ubuntu 24.04
The article outlines the process of migrating from MySQL to MariaDB on Ubuntu 24.04. It emphasizes the importance of backing up databases, checking compatibility, uninstalling MySQL, installing MariaDB, and restoring backups. Following these steps ensures a smooth transition, allowing users to benefit from MariaDB’s additional features and optimizations.
·
How to Create a Self-Signed SSL Certificate for MariaDB on Ubuntu 24.04
This article details the process of creating and configuring a self-signed SSL certificate for MariaDB on Ubuntu 24.04. It enhances security by enabling encrypted connections. Steps include generating the certificate, configuring MariaDB settings, validating SSL installation, and ensuring users connect via SSL, thus safeguarding sensitive data.
·
How to Reset MySQL or MariaDB Root Password
This content provides a step-by-step guide to resetting or changing MySQL or MariaDB passwords on Ubuntu Linux. The tutorial addresses scenarios such as forgetting the root password in these databases and guides users through various command line instructions for password recovery, depending on the MySQL or MariaDB server’s version being used. Additionally, it covers using…
·
Install MySQL and MariaDB on Ubuntu: A Step-by-Step Guide
This guide provides detailed instructions on how to install MySQL or on Ubuntu Linux for students or new users. Both MySQL and MariaDB are open-source, multi-threaded relational database management systems, with MariaDB being a backward-compatible replacement for MySQL. The post outlines steps on installing default and latest versions, and securing MariaDB and MySQL databases. The…
·
How to Check MySQL & MariaDB Versions in Ubuntu
This tutorial guides users on how to check MySQL or MariaDB server versions in Ubuntu Linux using various methods. These include using the built-in `mysqld –version` or `mysqladmin -V` commands, logging into the server using the `sudo mysql` command, or running the `STATUS` query. Other methods include using PHP to create a file displaying the…
·
How to Backup and Restore MariaDB on Ubuntu
This tutorial guides users through the process of backing up and restoring MariaDB databases and data files on Ubuntu using Mariabackup. Mariabackup, an open-source tool introduced in MariaDB 10.1, does “hot online” backups of InnoDB tables and other files. The tutorial includes step-by-step instructions on installing Mariabackup, creating backups, and restoring data from these backups.
·
How to Allow Remote Access to MariaDB in Ubuntu Linux
The tutorial explains how to setup remote access connections to MariaDB database servers on Ubuntu 18.04 systems. It involves installing MariaDB, enabling the service to always start up when the server boots, and configuring the server to allow remote access. The article also provides the necessary commands for enabling this on the Ubuntu Firewall. Care…
·
How to Change MySQL or MariaDB User Password on Ubuntu Linux
This tutorial guides users on how to change MySQL or MariaDB database passwords for enhanced system security. The process includes understanding the necessity of changing passwords, considering the account’s application, and deciding on password strength. The tutorial instructs users to apply the ‘UPDATE’, ‘SET PASSWORD’, or ‘ALTER’ SQL statements for changing passwords, emphasizing the importance…
·
How to Setup MariaDB Master and Slave Replication on Ubuntu Linux
The tutorial provides step-by-step instructions on setting up MySQL/MariaDB master and slave replication on Ubuntu 16.04 and 18.04 servers, which is crucial for security, fault tolerance, and scalability. The process involves setting server details, installing MariaDB on both servers, creating and configuring master and slave servers, and testing the setup. Changes made on the master…
·
How to Delete MySQL Database and User on Ubuntu Linux
The post is a tutorial showing how to delete old MySQL databases and associated user accounts via the Ubuntu command line, a task particularly relevant for those managing websites with content management systems like WordPress. It underlines the permanence and potential risk of these actions and provides step-by-step commands for both dropping databases and user…
Tag: MariaDB
MariaDB Server is one of the most popular open-source relational databases.