MariaDB: Difference between revisions
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
No edit summary |
No edit summary |
||
| Line 11: | Line 11: | ||
==How To== | ==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. | * '''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. | ||
** '''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. | |||
Revision as of 16:49, 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.- 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.
