MariaDB - Revision history

Woozle: URL update

2025-09-15T14:34:16Z

URL update

← Older revision		Revision as of 14:34, 15 September 2025
Line 17:		Line 17:
	** [https://mariadb.com main site]		** [https://mariadb.com main site]
	*** [https://mariadb.com/docs/server/ documentation]		*** [https://mariadb.com/docs/server/ documentation]
	**** [https://mariadb.com/docs/server/sql/ SQL Reference]		**** [https://mariadb.com/docs/server/reference/sql-statements SQL Reference]
	*** '''other products''':		*** '''other products''':
	**** [https://mariadb.com/docs/ documentation]		**** [https://mariadb.com/docs/ documentation]

Woozle at 03:25, 22 February 2025

2025-02-22T03:25:59Z

← Older revision		Revision as of 03:25, 22 February 2025
Line 7:		Line 7:
	==Pages==		==Pages==
	* [[/SQL]]: syntax		* [[/SQL]]: syntax
			* [[/import]]: how to import data
	==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>

Woozle at 17:29, 16 February 2025

2025-02-16T17:29:58Z

← Older revision		Revision as of 17:29, 16 February 2025
Line 5:		Line 5:
	==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.
			==Pages==
			* [[/SQL]]: syntax
	==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>

Woozle at 02:19, 13 February 2025

2025-02-13T02:19:04Z

← Older revision		Revision as of 02:19, 13 February 2025
Line 1:		Line 1:
	~~<hide>~~		{{#set:page type\|article}}
	[[page type::article]]		{{#set:thing type\|software}}
	[[thing type::software]]		{{#set:thing type\|database engine}}
	[[thing type::database engine]]
	[[category:software]]		[[category:software]]
	~~</hide>~~
	==About==		==About==
	[[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.
	==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]

Woozle at 16:49, 6 December 2024

2024-12-06T16:49:03Z

← Older revision		Revision as of 16:49, 6 December 2024
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.

Woozle at 16:35, 6 December 2024

2024-12-06T16:35:48Z

← Older revision		Revision as of 16:35, 6 December 2024
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:<~~source~~ lang=mysql>CREATE USER '<USERNAME>'@<HOST> IDENTIFIED BY '<PASSWORD>';</~~source~~>		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.

Woozle: Created page with " page type::article thing type::software category:software ==About== MariaDB is a drop-in replacement for MySQL, with some minor differences..."

2020-11-07T19:41:33Z

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..."

New page

<hide>
[[page type::article]]
[[thing type::software]]
[[category:software]]
</hide>
==About==
[[MariaDB]] is a drop-in replacement for [[MySQL]], with some minor differences which come up in coding and administrative contexts.{{seed}}
==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:<source lang=mysql>CREATE USER '<USERNAME>'@<HOST> IDENTIFIED BY '<PASSWORD>';</source>