Difference between revisions of "MariaDB"
Jump to navigation
Jump to search
(Created page with "<hide> page type::article thing type::software category:software </hide> ==About== MariaDB is a drop-in replacement for MySQL, with some minor differences...") |
|||
| Line 2: | Line 2: | ||
[[page type::article]] | [[page type::article]] | ||
[[thing type::software]] | [[thing type::software]] | ||
| + | [[thing type::database engine]] | ||
[[category:software]] | [[category:software]] | ||
</hide> | </hide> | ||
| Line 7: | Line 8: | ||
[[MariaDB]] is a drop-in replacement for [[MySQL]], with some minor differences which come up in coding and administrative contexts.{{seed}} | [[MariaDB]] is a drop-in replacement for [[MySQL]], with some minor differences which come up in coding and administrative contexts.{{seed}} | ||
==Notes== | ==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:< | + | 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> |
| + | ==How To== | ||
| + | * '''2020-05-05''' [https://www.digitalocean.com/community/tutorials/how-to-reset-your-mysql-or-mariadb-root-password How To Reset Your MySQL or MariaDB Root Password]: Basically -- you stop the server, reload it without credential-checking, reset the permissions-buffer with <syntaxhighlight lang=mysql inline>FLUSH PRIVILEGES;</syntaxhighlight>, and then use <syntaxhighlight lang=mysql inline>ALTER USER ...</syntaxhighlight> to re-add the root user. | ||
Revision as of 16:35, 6 December 2024
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 useALTER USER ...to re-add the root user.