Allow Remote Access to Oracle MySQL Database Server on Ubuntu 18.04

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, some configurations might be different.. […]

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

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

MySQL Server 8.0.14 Released — Here’s How to Install / Upgrade on Ubuntu 16.04 | 18.04

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 data, a feature to disable innodb_buffer_pool_in_core_file to reduce its […]

Resetting MySQL Root Password on Ubuntu 16.04 / 17.10 and 18.04 LTS

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 passwords. Forgetting your desktop password […]

Install MySQL 8.0 on Ubuntu 16.04 | 17.10 | 18.04

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 the only databse server used […]

Install MySQL Latest Versions on Ubuntu 16.04 LTS Server

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 you need to install the […]

Resetting MySQL Root Password on Ubuntu 17.04 | 17.10

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. The day you forget MySQL […]