How to Reset MySQL or MariaDB Root Password

This post shows students and new users steps to reset or change MySQL or MariaDB password when using Ubuntu Linux. One can create and reset the root passwords easily via its command terminal or shell when using MySQL or MariaDB.

If you have forgotten the root password, the steps below will show you how to reset it easily without deleting and reinstalling the database server.

Forgetting your desktop password is one thing. However, forgetting the root password to your MySQL database in production is totally another thing and not fun. And if you did, then this post is show you show you how to recover the root password.

Also, for students and new users learning Linux, the easiest place to start learning is on Ubuntu Linux. Ubuntu is the modern, open source Linux operating system for desktop, servers and other devices.

Continue reading “How to Reset MySQL or MariaDB Root Password”

How to Install MySQL or MariaDB on Ubuntu Linux

This post shows students and new users steps to install MySQL or MariaDB on Ubuntu Linux. MariaDB and MySQL are twins. Both MySQL and MariaDB is an open-source, multi-threaded relational database management systems. MariaDB is a backward compatible replacement for MySQL.

You can uninstall MySQL and install MariaDB, and your applications may not even know the difference. Since these two databases are identical, we’re going to write a single post detailing how to install both on Ubuntu Linux.

MariaDB maintained and developed by the MariaDB Foundation while MySQL is owned by Oracle.

If you’re a student or new user learning Linux, the easiest place to start learning is on Ubuntu Linux. Ubuntu is the modern, open source Linux operating system for desktop, servers and other devices.

Continue reading “How to Install MySQL or MariaDB on Ubuntu Linux”

How to Check MySQL Version in Ubuntu Linux

This brief tutorial shows students and new users how to check MySQL | MariaDB server versions in Ubuntu Linux.

How do you know which versions of MySQL or MariaDB database server you’re running? How do you find out? What command do you use?

The answer for all your questions detailed below.

Nowadays, 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 database server used in majority of the opensource projects. However, licensing changes made by Oracle, the new parent company established an alternative to MySQL called MariaDB.

MariaDB is a drop-in replacement for MySQL. This means that for many cases, you can just uninstall MySQL and install MariaDB and you are good to go. There is not generally any need to convert any data files.

Whatever database you use, the commands below should work in finding out the version of MySQL or MariaDB.

Continue reading “How to Check MySQL Version in Ubuntu Linux”

How to Setup Self Signed SSL/TLS on MySQL

This brief tutorial shows students and new users how to enable self-signed SSL/TLS certificates and connect to MySQL Server via SSL connection on Ubuntu Linux 20.04 | 18.04.

By default when you install MySQL server, it will only allow connections from the local system for users with the correct credentials regardless of transport protocol.

If you want to add another layer of security, you can enable SSL/TLS certificate settings and force all users to connect securely.

For this tutorials, we’re going to be creating a self signed certificate to configure with MySQL.

Continue reading “How to Setup Self Signed SSL/TLS on MySQL”

How to Install MySQL on Ubuntu 20.04 | 18.04

This brief tutorial shows students and new users how to install MySQL server on Ubuntu 20.04 | 18.04 LTS.

MySQL is an opensource, fast, secure and scalable relational database management system. It is one key component of the LAMP or LEMP stack that powered countless websites and applications online today.

Although MariaDB sever is now the default database server in most opensource projects, MySQL is the father of MariaDB and both are the same with different names.

For more about MySQL, please check its homepage.

Continue reading “How to Install MySQL on Ubuntu 20.04 | 18.04”

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.

By default when you install MySQL 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 a remote location, you will not be able to connect databases setup on the server. This brief guide shows you how to enable that.

When configured correctly, you will be able to connect to the database servers from a remote systems and applications not connected to the same subnet or host computer.

If the server is connected directory to the Internet, you may able able to access it from anywhere around the world where Internet access is available. however, opening up your database servers directly to the internet is not recommended, especially in a production environment.

Continue reading “Allow Remote Access to Oracle MySQL Database Server on Ubuntu 18.04”

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 user password to something strong and unique which might help improve your system security.

This post applies to both MySQL and MariaDB database servers. Since both use the same underlying code.

In fact, MariaDB is a drop-in replacement for MySQL. So in the future you decide to switch from MySQL to MariaDB, you should just be able to do it without impacting applications.When you’re ready to learn how to change database users passwords, follow the steps below:

Continue reading “Changing MySQL / MariaDB User Passwords on Linux (Ubuntu)”

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 the steps below to do that.

This brief tutorial shows students and new users how to remove old MySQL databases and users associated with those databases using the command line terminal on Ubuntu and other Linux distributions.

The steps are intended for removing MySQL database and user on Linux via the command line only. and you should be extremely careful when dropping MySQL databases.When you’re ready to drop MySQL databases and associated users on Ubuntu, follow the steps below:

Continue reading “WordPress Tips – Removing MySQL Database and User on Ubuntu 16.04 | 18.04”

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 easily change MySQL or MariaDB user password via its shell terminal.

This tutorial is not about retrieving forgetting user’s passwords. You must already know the current password for the root account for this to work. You won’t be able to reset user passwords without first knowing the root password to logon to MySQL or MariaDB server.When you’re ready to reset user passwords, follow the steps below:

Continue reading “How to Change MySQL / MariaDB User Passwords on Ubuntu 16.04 | 18.04”

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 size, a full support for InnoDB parallel clustered index reads, which can improve CHECK TABLE performance, a bux fix for importing a dump from a MySQL 5.7 server to a server running MySQL 8.0 often failed and many more.

For more about this release, please check its release note.

Below is a list of some of the features and bug fixes included with this release:

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

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 is one thing. however, fogetting the root password to your MySQL database in production is totally another thing and not fun. and if you did, then you’re in the right place. the steps below will show you how to quickly reset the root password to your MySQL database server.

This brief tutorial is going to show students and new users how to quickly regain access to MySQL databases by resetting the root password.

When you’re ready to reset the root password for MysQL, continue with the steps below

Setting MySQL Root Password

Continue reading “Resetting MySQL Root Password on Ubuntu 16.04 / 17.10 and 18.04 LTS”

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 in majority of the opensource projects. Because of licenses changes made by Oracle, MariaDB was introduced and the opensource community migrated to MariaDB instead.

MySQL is now far behind MariaDB in many opensource project. Many of our LAMP and LEMP tutorials used MariaDB as well.

However, some project still work better with MySQL and have not fully enbraced MariaDB. and for those folks, MySQL should be installed.

Continue reading “Install MySQL 8.0 on Ubuntu 16.04 | 17.10 | 18.04”