MariaDB: Difference between revisions
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
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..." |
No edit summary |
||
| 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
<hide> page type::article thing type::software thing type::database engine </hide>
About
MariaDB is a drop-in replacement for MySQL, with some minor differences which come up in coding and administrative contexts.<hide>
page status::seed
</hide>
|
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.
