·
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.
·
Backup and Restore MySQL database with mysqldump
This article outlines the process of backing up and restoring MySQL databases using the mysqldump tool on Ubuntu 24.04. It details commands for backing up all databases or specific ones, advises on using table locking or transactions for data integrity, and emphasizes regular backups, effective monitoring, and testing restore processes to prevent data loss.
·
Secure MySQL with Self-Signed SSL Certificate on Ubuntu 24.04
This article discusses the implementation of MySQL self-signed SSL certificates on Ubuntu 24.04 to enhance database security. It covers generating certificates, configuring SSL connections, and enforcing SSL usage for users. Key points include improved encryption, automatic SSL configuration, user restrictions, and validation of SSL setups for a secure database environment.
·
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 Allow Remote Access to MySQL Database on Ubuntu Linux
This tutorial guides on setting up remote access to MySQL server on Ubuntu 18.04. The default configuration not allowing remote connections can be modified by changing bind-address value to 0.0.0.0, enabling MySQL to accept connections on all host interfaces. Individual IP addresses must be granted access explicitly. Firewall exceptions for the specific port need to…
·
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 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…
·
AutoMySQLBackup: Effortless MySQL Database Backups
AutoMySQLBackup is an open-source tool for automatic backup of MySQL databases. It offers features including automatic backups, email notifications, incremental backups, backup compression, and encryption. The tutorial guides on how to install and configure AutoMySQLBackup on Ubuntu servers, including setting up the tool, creating a configuration file, and scheduling automatic backups.