Difference between revisions of "MariaDB"

Latest revision as of 03:25, 22 February 2025

About

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

Pages

/SQL: syntax
/import: how to import data

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.

Links

official:
- main site
  - documentation
    - SQL Reference
  - other products:
    - documentation

@@ Line 5: / Line 5: @@
 ==About==
 [[MariaDB]] is a drop-in replacement for [[MySQL]], with some minor differences which come up in coding and administrative contexts.
+==Pages==
+* [[/SQL]]: syntax
+* [[/import]]: how to import data
 ==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:<syntaxhighlight lang=mysql>CREATE USER '<USERNAME>'@<HOST> IDENTIFIED BY '<PASSWORD>';</syntaxhighlight>