Remote Root Access for MariaDB on Ubuntu 16.04 LTS
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
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
- Great Lakes, Illinois
- My Custom Miniflux CSS Theme
- Ladybird on Debian Stable
- SQLite DB Migrations with PRAGMA user_version
- 2025
Recent Favorite Blog Posts
This is a collection of the last 8 posts that I bookmarked.
- Clicks Communicator from Chris Hannah
- A Year Of Vibes from Armin Ronacher's Thoughts and Writings
- Pluralistic: A perfect distillation of the social uselessness of finance (18 Dec 2025) from Pluralistic: Daily links from Cory Doctorow
- Moving from WordPress to Substack from charity.wtf
- Grow, Like a Tree Not a Cancer from Jim Nielsen’s Blog
- Pluralistic: All the books I reviewed in 2025 (02 Dec 2025) from Pluralistic: Daily links from Cory Doctorow
- DEP-18: A proposal for Git-based collaboration in Debian from Optimized by Otto
- [RIDGELINE] No Phones in The Ten-don Shop from Craig Mod — Writer + Photographer
Articles from blogs I follow around the net
The year of technoligarchy
In 2025, Trump brought tech executives into power to dismantle regulators and write their own rules. But the instabilities they’re creating may be their downfall.
via Citation Needed January 7, 2026we are here. Performance at Beyond Tellerrand
This performance has been years in the making. In a sense, you could say it’s been a lifetime in the making. On November 6th, 2025, my brother Ian and I gave a “talk” at the amazing Beyond Tellerrand conference in […]
via Blog – Brad Frost January 7, 2026Pluralistic: Writing vs AI (07 Jan 2026)
Today's links Writing vs AI: If you wouldn't ask an AI to eat a delicious pizza for you, why would you ask it to write a college essay? Hey look at this: Delights to delectate. Object permanence: WELL State of the World; A poem in 30m logfiles; We…
via Pluralistic: Daily links from Cory Doctorow January 7, 2026Generated by openring