Students and new webmasters should learn how to export and import MySQL or MariaDB databases. For those managing a WordPress website and thinking of migrating to a new host or will be making changes to their sites, then learning to export and import these databases is a great skill to have. One good habit to keep […]
MariaDB Database
MariaDB 10.3.9 Released — Here’s How to Install on Ubuntu 16.04 / 18.04 LTS
MariaDB, a popular open source database server has recently been updated to the current stable version 10.3.9… This brief tutorial shows students and new users how to always get MariaDB latest versions when they’re released…. For those who don’t know, here’s an overview of MariaDB: MariaDB Database is an open source database server that is […]
MariaDB 10.3.10 Has Been Released — Here’s How to Install / Upgrade on Ubuntu 16.04 / 18.04 / 18.10
MariaDB database server which is probably the most popular open source database server has recently been updated to version 10.3.10… This brief tutorial shows students and new users how to always get MariaDB latest versions when they’re released on Ubuntu 16.04 / 18.04 and 18.10…. For those who don’t know, here’s an overview of MariaDB: […]
MariaDB 10.3.11 Available — Here’s How to Install / Upgrade on Ubuntu 16.04 / 18.04 / 18.10
A new maintenance release of the 10.3 series of MariaDB database server is available for download…. This release is 10.3.11 and this brief tutorial is going to show students and new users how to install or upgrade on Ubuntu 16.04 / 18.04 / 18.10… For those who don’t know, here’s an overview of MariaDB: MariaDB […]
How to Change MySQL / MariaDB User Passwords on Ubuntu 16.04 / 18.04
After installing MySQL or MariaDB server, one can create and reset user passwords easily via its command terminal or shell.. For example, if you wish to reset or change MySQL / MariaDB root password or another user, the steps below will help you do that… This brief tutorial shows students and new users how to […]
WordPress Tips – Removing MySQL Database and User on Ubuntu 16.04 / 18.04
Sometimes you may want to drop or delete old databases and user accounts on MySQL (MariaDB) server… When running a website powered by WordPress or other content management system (CMS) that uses a database server like MySQL or MariaDB, and you want to delete old databases that are no longer in used, you can use […]
Setup MariaDB Master / Slave Replication on Ubuntu 16.04 / 18.04
For security and fault tolerance reasons, setting up MySQL / MariaDB master and slave replication is a way to go… In a master and slave setup, one database server serves are the primary or master and the other(s) as slave in this topology… Changes made on the master server are replicated to the slave servers… […]
Changing MySQL / MariaDB User Passwords on Linux (Ubuntu)
There may be a time when you want to change a database user password… Some reasons for changing MySQL or MariaDB database user passwords might be to ensure strong password, the account is compromised or just doing some house cleaning.. This brief tutorial shows students and new users how to change MySQL or MariaDB database […]
Lesson 1: How to Install MariaDB on Ubuntu
Student lesson 1: This brief tutorial shows students how to install MariaDB database server on Ubuntu systems. Students from everywhere enjoy our tutorials. We write our guides so simple to read and understand that users from different corners send us emails thanking us for these wonderful tutorials. Few days ago, we wrote a tutorial on […]
Lesson 28: Install MariaDB Latest Version on Ubuntu
Students lesson 28 assignment: How do you install the latest version of MariaDB on Ubuntu servers? As we said earlier, MariaDB is a drop in replacement for MySQL. It’s practically MySQL with a different name. MariaDB comes in Ubuntu default repository. However, the version in the repository is a stable tested version and not the […]