MariaDB

About

MariaDB is a drop-in replacement for MySQL, with some minor differences which come up in coding and administrative contexts.

This page is a seed article. You can help HTYP water it: make a request to expand a given page and/or donate to help give us more writing-hours!

Notes

The function for making new users in MySQL Workbench 8.0.20 is broken with MariaDB 10.5.7. Fortunately, it is easy to get around this by entering the necessary SQL directly:

CREATE USER '<USERNAME>'@<HOST> IDENTIFIED BY '<PASSWORD>';

How To

• 2020-05-05 How To Reset Your MySQL or MariaDB Root Password: Basically -- you stop the server, reload it without credential-checking, reset the permissions-buffer with FLUSH PRIVILEGES;, and then use ALTER USER ... to re-add the root user.
  • Note that although you may be able to get into the un-credentialed MariaDB without a username (or with a different username), it looks like only "root" will allow you to make the needed changes.