Allow Remote Access to MariaDB Database Server on Ubuntu 18.04

This brief tutorial shows students and new users how to configure remote access connection to MariaDB database servers on Ubuntu 18.04 systems. By default when you install MariaDB database server, it only accepts connections its local host.. The same host computer it is installed on.. If want to connect from a remote client computer from […]

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 […]

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… […]

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 […]

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 […]

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 […]

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.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 […]

Upgrading MariaDB from 10.0 to 10.1 to 10.2 on Ubuntu 16.04 / 17.10

For those still running Ubuntu 16.04 LTS and 17.10 with MariaDB 10.0 or 10.1 installed and hoping to upgrade to Ubuntu 18.04, they may want to upgrade MariaDB database server to version 10.2… as it’s the default database version that comes with Ubuntu 18.04 and fully supported… This brief tutorial is going to show students […]