Database - MariaDB - Revision history

Tinker: /* Allowing non-localhost access */

2025-10-12T23:33:01Z

Allowing non-localhost access

← Older revision		Revision as of 19:33, 12 October 2025
Line 138:		Line 138:

	(where '''Machine.Domain.TLD''' is the FQDN or IP address of the database server itself...)		(where '''Machine.Domain.TLD''' is the FQDN or IP address of the database server itself...)

			or... you could live on the edge & simply do:

			<code>bind-address = 0.0.0.0</code>

	= Set up at least one database user =		= Set up at least one database user =

Tinker: /* Set up at least one database user */

2025-09-01T17:22:12Z

Set up at least one database user

← Older revision		Revision as of 13:22, 1 September 2025
Line 150:		Line 150:
	('''Hint:''' This'd be a good time to create yourself as that user with your non-admin password of choice...)		('''Hint:''' This'd be a good time to create yourself as that user with your non-admin password of choice...)

			('''BONUS Hint:''' Change '''''localhost''''' in that CREATE USER line with ''''''%'''''' if this will be a remotely accessible server...)
	== Remotely accessed Database Server ==		== Remotely accessed Database Server ==
	If this is to be a remotely accessed Database Server, ''''localhost'''' will actually be the name/address of the remote machine you'll access '''from'''.		If this is to be a remotely accessed Database Server, ''''localhost'''' will actually be the name/address of the remote machine you'll access '''from'''.
Line 155:		Line 156:
	Possibly even ''''%'''' as a wildcard.		Possibly even ''''%'''' as a wildcard.

	<span style="color: rgb(186, 55, 42);" >'''A NOTE:'''</span> If you have a user @ a specific host, then add the same user @ '%', MariaDB will not let the wildcard user have priveleges...		<span style="color: rgb(186, 55, 42);">'''A NOTE:'''</span> If you have a user @ a specific host, then add the same user @ '%', MariaDB will not let the wildcard user have priveleges...

	= Some Reference Materials =		= Some Reference Materials =

Tinker: /* Some Useful Things */

2024-09-08T19:45:05Z

Some Useful Things

← Older revision		Revision as of 15:45, 8 September 2024
Line 178:		Line 178:
	**<code>CREATE DATABASE db_name;</code>		**<code>CREATE DATABASE db_name;</code>
	***You will need to grant access to any new database to the appropriate user(s). This is covered more clearly on pages where you create specific databases...		***You will need to grant access to any new database to the appropriate user(s). This is covered more clearly on pages where you create specific databases...
			**<code>GRANT ALL ON db_name. TO 'user'@'localhost';</code>
			***(as one example)
	*Trash a complete database '''(WARNING! DANGER! DAMAGE LIKELY!)'''		*Trash a complete database '''(WARNING! DANGER! DAMAGE LIKELY!)'''
	**<code>DROP DATABASE wp_Someblog;</code>		**<code>DROP DATABASE wp_Someblog;</code>

Tinker: /* Some Useful Things */

2024-09-08T19:42:10Z

Some Useful Things

← Older revision		Revision as of 15:42, 8 September 2024
Line 177:		Line 177:
	*Create a new database		*Create a new database
	**<code>CREATE DATABASE db_name;</code>		**<code>CREATE DATABASE db_name;</code>
			***You will need to grant access to any new database to the appropriate user(s). This is covered more clearly on pages where you create specific databases...
	*Trash a complete database '''(WARNING! DANGER! DAMAGE LIKELY!)'''		*Trash a complete database '''(WARNING! DANGER! DAMAGE LIKELY!)'''
	**<code>DROP DATABASE wp_Someblog;</code>		**<code>DROP DATABASE wp_Someblog;</code>

Tinker: /* Set up at least one database user */

2023-11-11T21:31:45Z

Set up at least one database user

← Older revision		Revision as of 17:31, 11 November 2023
Line 150:		Line 150:
	('''Hint:''' This'd be a good time to create yourself as that user with your non-admin password of choice...)		('''Hint:''' This'd be a good time to create yourself as that user with your non-admin password of choice...)

	If this is to be a remotely accessed Database Server, ''''localhost'''' will actually be the name/address of the remote machine you'll access '''from'''. (Possibly even ''''%'''' as a wildcard)		== Remotely accessed Database Server ==
			If this is to be a remotely accessed Database Server, ''''localhost'''' will actually be the name/address of the remote machine you'll access '''from'''.

			Possibly even ''''%'''' as a wildcard.

			<span style="color: rgb(186, 55, 42);" >'''A NOTE:'''</span> If you have a user @ a specific host, then add the same user @ '%', MariaDB will not let the wildcard user have priveleges...

	= Some Reference Materials =		= Some Reference Materials =

Tinker: /* Set up at least one database user */

2023-11-11T21:28:06Z

Set up at least one database user

← Older revision		Revision as of 17:28, 11 November 2023
Line 150:		Line 150:
	('''Hint:''' This'd be a good time to create yourself as that user with your non-admin password of choice...)		('''Hint:''' This'd be a good time to create yourself as that user with your non-admin password of choice...)

	If this is to be a remotely accessed Database Server, ''''localhost'''' will actually be the name/address of the remote machine you'll access '''from'''. (Possibly even ''''*'''' as a wildcard)		If this is to be a remotely accessed Database Server, ''''localhost'''' will actually be the name/address of the remote machine you'll access '''from'''. (Possibly even ''''%'''' as a wildcard)

	= Some Reference Materials =		= Some Reference Materials =

Tinker at 22:00, 20 August 2023

2023-08-20T22:00:00Z

← Older revision		Revision as of 18:00, 20 August 2023
Line 3:		Line 3:
	{{!}}- --="" debian=""		{{!}}- --="" debian=""
	{{!}} style="text-align: center; width: 60px;" {{!}} [[File:Logo Debian.png{{!}}60px{{!}}link=https://www.debian.org/{{!}}center{{!}}middle{{!}}frameless]]		{{!}} style="text-align: center; width: 60px;" {{!}} [[File:Logo Debian.png{{!}}60px{{!}}link=https://www.debian.org/{{!}}center{{!}}middle{{!}}frameless]]
	{{!}} style="text-align: center; width: 40px;" {{!}} 11 (bullseye)		{{!}} style="text-align: center; width: 40px;" {{!}} 11 (bullseye)<br>12 (bookworm)
	{{!}}		{{!}}

Tinker: /* Some Useful Things */

2023-03-12T21:56:34Z

Some Useful Things

← Older revision		Revision as of 17:56, 12 March 2023
Line 167:		Line 167:
	**<code>sudo mysql -u root -p</code>		**<code>sudo mysql -u root -p</code>
	*Restart MySQL		*Restart MySQL
	**<code>sudo systemctl restart ~~mysql~~.service</code>		**<code>sudo systemctl restart mariadb.service</code>
	*Change a user password		*Change a user password
	**<code>ALTER USER 'userName'@'localhost' IDENTIFIED BY 'New-Password-Here';</code>		**<code>ALTER USER 'userName'@'localhost' IDENTIFIED BY 'New-Password-Here';</code>

Tinker: /* Some Useful Things */

2023-02-25T20:37:00Z

Some Useful Things

← Older revision		Revision as of 16:37, 25 February 2023
Line 162:		Line 162:

	= Some Useful Things =		= Some Useful Things =
	<span style="color: rgb(186, 55, 42);" >(These have yet to be tested on MariaDB as opposed to mySQL...)</span>		<span style="color: rgb(186, 55, 42);">(These have yet to be fully tested on '''MariaDB''' as opposed to '''mySQL'''...)</span>

	*Sign into MySQL		*Sign into MySQL

Tinker at 20:35, 25 February 2023

2023-02-25T20:35:57Z

← Older revision		Revision as of 16:35, 25 February 2023
Line 9:		Line 9:
	{{!}}}		{{!}}}

	Something to note: When working with MariaDB, you will occasionally see utilities & such referring to mySQL. This is normal as MariaDB is a replacement for mySQL & the developers have not recreated things that work for both. (in many cases, this means that commands you would expect to be based on '''mariadb''' will be '''mysql''' instead.)		Here in the NerdMage's Lair, we have switched from mySQL to MariaDB lately. This has been prompted by the apparent abandonment of mySQL. (Yes, this IS a primarily Debian environment...)

			'''Something to note:''' When working with MariaDB, you will occasionally see utilities & such referring to mySQL. This is normal as MariaDB is a replacement for mySQL & the developers have not recreated things that work for both. (in many cases, this means that commands you would expect to be based on '''mariadb''' will be '''mysql''' instead.)

	= Installation =		= Installation =