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.

The AGI economy is coming faster than you think from Freethink
Rolling the ladder up behind us from Xe Iaso's blog
In Praise of “Normal” Engineers from charity.wtf
Reports of Bluesky's death have been greatly exaggerated from The Torment Nexus
What Would a Kubernetes 2.0 Look Like from matduggan.com
We Can Just Measure Things from Armin Ronacher's Thoughts and Writings
The Gentle Singularity from Sam Altman
Whale Watching from https://popagandhi.com/

Articles from blogs I follow around the net

Pluralistic: Daniel de Visé's 'The Blues Brothers' (21 Jun 2025)

Today's links Daniel de Visé's 'The Blues Brothers': Far more than production gossip – an unmissable portrait of a turning point in American comedy and music. Hey look at this: Delights to delectate. Object permanence: 2005, 2010, 2015, 20…

via Pluralistic: Daily links from Cory Doctorow June 21, 2025

Hiding metrics from the web

In 2012, artist Ben Grosser released a browser extension called Facebook Demetricator. Once installed, it hid all metrics from Facebook’s interface: likes, comments, notifications, unread messages, and so on. “What’s going on here is that these quantifica…

via Manual do Usuário June 21, 2025

It's like surfing

The weird thing about engineering management is that you feel kinda useless. Yet if you stop, projects stop.

via swizec.com RSS Feed June 21, 2025

Generated by openring