This brief tutorial shows students and new users how to configure remote access connection to MySQL database servers on Ubuntu 18.04 systems..
Our previous tutorial showed you how to enable remote access to MariaDB database server… Since these are two separate (but also the same in some ways) database servers, … Read the rest
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 … Read the rest
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 … Read the rest
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 … Read the rest
MySQL Server, the popular open source database server has been updated to the latest version (8.0.14), and this brief tutorial shows students and new users how to install or upgrade on Ubuntu 16.04 | 18.04 LTS servers…
This release brings lots of changes including, support for importing BSON … Read the rest
We’re humans, and we forget stuff… when we do, we tend to go back in time to remember what was forgotten. The same is true with passwords. We do forgot a lot when it comes to passwords… and that’s why there are countless password managers to help us manage our … Read the rest
This brief tutorial shows students and new users how to install the latest MySQL 8.0 on Ubuntu 16.04 / 17.10 and 18.04…
Nowdays, everywhere you look you’ll find MariaDB database server being used with many opensource projects… This was not the case few years ago.
Then, MySQL was the probably … Read the rest
MySQL is still a popular database server… however, the default open source database server on the majority of Linux systems is MariaDB… Some webmasters still find MySQL very useful and are sticking with it..
The MySQL package version that comes with Ubuntu default repositories is not the latest version… If … Read the rest
Once in a while we forget stuff… and when we do, we tend to go back in time to remember what was forgotten. The same is true with passwords. We humans do forgot when it comes to passwords… and that’s why there are password managers to help us with passwords.… Read the rest
phpMyAdmin allows you to manage MySQL or MariaDB databases via a simple web browser. In most environments, phpMyAdmin package is installed on the same server as the database server… so not much configurations are needed there… it should just work.
However, if you want to manage MySQL or MariaDB databases … Read the rest