Difference between revisions of "MariaDB"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
− | + | {{#set:page type|article}} | |
− | + | {{#set:thing type|software}} | |
− | + | {{#set:thing type|database engine}} | |
− | |||
[[category:software]] | [[category:software]] | ||
− | |||
==About== | ==About== | ||
− | [[MariaDB]] is a drop-in replacement for [[MySQL]], with some minor differences which come up in coding and administrative contexts. | + | [[MariaDB]] is a drop-in replacement for [[MySQL]], with some minor differences which come up in coding and administrative contexts. |
==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:<syntaxhighlight lang=mysql>CREATE USER '<USERNAME>'@<HOST> IDENTIFIED BY '<PASSWORD>';</syntaxhighlight> | 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> | ||
Line 12: | Line 10: | ||
* '''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. | ** '''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''': | ||
+ | ** [https://mariadb.com main site] | ||
+ | *** [https://mariadb.com/docs/server/ documentation] | ||
+ | **** [https://mariadb.com/docs/server/sql/ SQL Reference] | ||
+ | *** '''other products''': | ||
+ | **** [https://mariadb.com/docs/ documentation] |
Revision as of 02:19, 13 February 2025
About
MariaDB is a drop-in replacement for MySQL, with some minor differences which come up in coding and administrative contexts.
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.
Links
- official:
- main site
- documentation
- other products:
- main site