Remote Root Access for MariaDB on Ubuntu 16.04 LTS

October 13, 2016 | ubuntu | linux | databases |

Typically, when you install MySQL on Ubuntu, it asks you for a root password which you can then use to log into the database. It seems that MariaDB uses a plugin instead to authenticate the root user. This means that the only way to log into MariaDB by default as root is locally with sudo mysql -u root In order to give the root user a password and login the “traditional” way (which includes remote access via a tunnel) you have to do the following.

Log into MariaDB as the Root user
```
sudo mysql -u root
```

Disable the Auth Plugin

use mysql;
update user set plugin='' where User='root';

Create a password for the root user

grant all privileges on *.* to 'root'@'127.0.0.1' identified by '$STRONG_PASSWORD';
flush privileges;

Restart MariaDB
```
sudo service mysql Restart
```

You can now access the root account with a password, and also over an SSH tunnel remotely.

Thank you for reading! Share your thoughts with me on bluesky, mastodon, or via email.

Check out some more stuff to read down below.

Most popular posts this month

Recent Favorite Blog Posts

This is a collection of the last 8 posts that I bookmarked.

A eulogy for Vim from Drew DeVault's blog
Pluralistic: AI "journalists" prove that media bosses don't give a shit (11 Mar 2026) from Pluralistic: Daily links from Cory Doctorow
Avi Alkalay: Uniqlo T-Shirt Bash Script Easter Egg from Fedora People
Offline 23 hours a day from Derek Sivers blog
Pluralistic: California can stop Larry Ellison from buying Warners (28 Feb 2026) from Pluralistic: Daily links from Cory Doctorow
On Alliances from Smashing Frames
Acting ethically in an imperfect world from Smashing Frames
Diffusion of Responsibility from Smashing Frames

Articles from blogs I follow around the net

Highlights from my conversation about agentic engineering on Lenny's Podcast

I was a guest on Lenny Rachitsky's podcast, in a new episode titled An AI state of the union: We've passed the inflection point, dark factories are coming, and automation timelines. It's available on YouTube, Spotify, and Apple Podcasts. Here …

via Simon Willison's Weblog: Entries April 2, 2026

Flood Fill vs the Magic Circle

Musings from Robin Sloan: Most olive oil production at medium-or-greater scale depends on machines of this kind [over-the-row olive harvester]; they trundle over trees planted in long rows, almost like continuous hedges, and collect the fruit with vibratin…

via Information Overload April 2, 2026

The Blandness of Systematic Rules vs. The Delight of Localized Sensitivity

Marcin Wichary brings attention to this lovely dialog in ClarisWorks from 1997: He quips: this breaks the rule of button copy being fully comprehensible without having to read the surrounding strings first, perhaps most well-known as the “avoid «click here»…

via Jim Nielsen’s Blog April 2, 2026

Generated by openring