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..

Read More

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… Read More

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… Read More

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… Read More

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..

Read More

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

Read More

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.

Read More

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 latest version of MySQL database, you may want to install its repository in Ubuntu.. In many cases, the most up-to-date packages are available from the package own repository and not from Ubuntu… So if you need to get the latest versions of MySQL, the steps below is a great place to start…

This brief tutorial shows students and new users how to easily add MySQL database repository in order to install the most up-to-date version.

Read More

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 database root password, the steps below will help you regain access to your database easily… This 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

Read More

Manage Remote MySQL Databases via phpMyAdmin on Ubuntu 17.04 | 17.10

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 on a remote server via phpMyAdmin web interface, you’ll need to make some changes in its configuration files.

In order to access and manage remote MySQL or MariaDB servers, you must configure the servers to allow remote access over the network. The steps below will show you how.

This brief tutorial is going to install and configure phpMyAdmin on Ubuntu 17.04 | 17.10 to access and manage a remote MySQL or MariaDB database server. When you’re ready, please continue with the steps below:

Read More