MariaDB - Revision history

Krydos: Created new section for example config

2026-03-14T17:05:43Z

Created new section for example config

← Older revision		Revision as of 17:05, 14 March 2026
Line 84:		Line 84:
	# The remote MariaDB port is 3306 for all of our plans.		# The remote MariaDB port is 3306 for all of our plans.
	# The full remote MariaDB config will look something like this:		# The full remote MariaDB config will look something like this:

			== Example Remote MariaDB Values ==

	<pre>		<pre>

Krydos: Removed hosts section, since it's covered in the Connecting Remotely section

2026-03-14T17:04:17Z

Removed hosts section, since it's covered in the Connecting Remotely section

← Older revision		Revision as of 17:04, 14 March 2026
Line 92:		Line 92:
	</pre>		</pre>
	{{Caution\|Make sure you update the above host based on which server you're actually on, make sure you update the username to match the actual username you created, and make sure you update the database name to match the actual database you created. This is just an example, and if you copy/paste it exactly as displayed without updating it to real values it won't work.}}		{{Caution\|Make sure you update the above host based on which server you're actually on, make sure you update the username to match the actual username you created, and make sure you update the database name to match the actual database you created. This is just an example, and if you copy/paste it exactly as displayed without updating it to real values it won't work.}}

	~~== Server Hosts ==~~

	~~Use the host for your server:~~

	* Morty: morty.heliohost.org
	* Tommy: tommy.heliohost.org
	* Johnny: johnny.heliohost.org

	== Example Code Links ==		== Example Code Links ==

Krydos: /* Connecting Remotely */ A few more details about how to enable remote connections.

2026-03-14T17:03:25Z

Connecting Remotely: A few more details about how to enable remote connections.

@@ Line 73: / Line 73: @@
 == Connecting Remotely ==
-# Login to Plesk.
+# Login at https://heliohost.org/login/
-# Click on 'Remote MariaDB'.
+# Click continue to Plesk.
-# Put a percent sign '%' for all IP or else enter the IP to give access to only that particular IP in the box and click 'Submit'.
+# Click databases in the left navigation panel.
 == Server Hosts ==

KazVee: KazVee moved page MySQL to MariaDB: Renaming 'MySQL' page to 'MariaDB' which is the fully free, fully open source version of MySQL offered on HelioHost

2025-11-22T03:24:35Z

KazVee moved page MySQL to MariaDB: Renaming 'MySQL' page to 'MariaDB' which is the fully free, fully open source version of MySQL offered on HelioHost

← Older revision	Revision as of 03:24, 22 November 2025
(No difference)

KazVee: Add note that MariaDB is the fully free, fully open source version of MySQL

2025-04-26T17:00:12Z

Add note that MariaDB is the fully free, fully open source version of MySQL

← Older revision		Revision as of 17:00, 26 April 2025
Line 1:		Line 1:
	== MariaDB ==		== MariaDB ==

			HelioHost offers MariaDB which is the fully free, fully open source version of MySQL.

	MariaDB is a very handy tool available to webmasters who want to take advantage of dynamic web pages which run on languages such as PHP, as well as software like WordPress that may have been manually installed (not installed using [[:Softaculous\|Softaculous]]).		MariaDB is a very handy tool available to webmasters who want to take advantage of dynamic web pages which run on languages such as PHP, as well as software like WordPress that may have been manually installed (not installed using [[:Softaculous\|Softaculous]]).

KazVee: Add Morty host name & remove Ricky

2025-01-22T06:07:15Z

Add Morty host name & remove Ricky

← Older revision		Revision as of 06:07, 22 January 2025
Line 79:		Line 79:
	Use the host for your server:		Use the host for your server:

			* Morty: morty.heliohost.org
	* Tommy: tommy.heliohost.org		* Tommy: tommy.heliohost.org
	* Ricky: ricky.heliohost.org
	* Johnny: johnny.heliohost.org		* Johnny: johnny.heliohost.org

KazVee: Add missing close bracket

2025-01-21T23:17:06Z

Add missing close bracket

← Older revision		Revision as of 23:17, 21 January 2025
Line 1:		Line 1:
	== MariaDB ==		== MariaDB ==

	MariaDB is a very handy tool available to webmasters who want to take advantage of dynamic web pages which run on languages such as PHP, as well as software like WordPress that may have been manually installed (not installed using [[:Softaculous\|Softaculous]].		MariaDB is a very handy tool available to webmasters who want to take advantage of dynamic web pages which run on languages such as PHP, as well as software like WordPress that may have been manually installed (not installed using [[:Softaculous\|Softaculous]]).

	More information about MariaDB can be found at [https://en.wikipedia.org/wiki/MariaDB/ Wikipedia] and [https://mariadb.org/ the official MariaDB website].		More information about MariaDB can be found at [https://en.wikipedia.org/wiki/MariaDB/ Wikipedia] and [https://mariadb.org/ the official MariaDB website].

KazVee at 02:56, 1 November 2024

2024-11-01T02:56:58Z

← Older revision		Revision as of 02:56, 1 November 2024
Line 9:		Line 9:
	The following are a list of steps to follow to create a MariaDB in Plesk.		The following are a list of steps to follow to create a MariaDB in Plesk.

	== Navigating to the `Databases` Section ==		== Navigating to the 'Databases' Section ==

	Before you take advantage of MariaDB, you will need to create a database and a user to work with. To access the `Databases` section of Plesk, use the button available left hand menu. Depending on your resolution (e.g. mobile devices), there may be a menu icon ( ☰ ) that you have to click to display the menu. You can also access the `Database` section from the `Websites & Domains` section.		Before you take advantage of MariaDB, you will need to create a database and a user to work with. To access the 'Databases' section of Plesk, use the button available left hand menu. Depending on your resolution (e.g. mobile devices), there may be a menu icon ( ☰ ) that you have to click to display the menu. You can also access the 'Database' section from the 'Websites & Domains' section.

	== Creating the Database ==		== Creating the Database ==

	In the `Databases` section of Plesk, there's a button `+ Add Database`. On smaller resolutions, the menu icon will appear. On the resulting page, you will have to fill out a form.		In the 'Databases' section of Plesk, there's a button '+ Add Database'. On smaller resolutions, the menu icon will appear. On the resulting page, you will have to fill out a form.

	== General Section ==		== General Section ==
Line 21:		Line 21:
	The first section is general. There are three items in this section.		The first section is general. There are three items in this section.

	The first item is the database name, this is prefixed with the format`<Username>_`.		The first item is the database name, this is prefixed with the format'<Username>_'.

	The second item is the server. This will be a dropdown of the available database servers. From this dropdown select `localhost:3306( default for MariaDB )`.		The second item is the server. This will be a dropdown of the available database servers. From this dropdown select 'localhost:3306( default for MariaDB )'.

	The third item is a drop down to associate your database with a site. The default is no related sites. From this dropdown you can associate your database with any website you have set up. This is a convenience feature to help associate a database with a website and is not required.		The third item is a drop down to associate your database with a site. The default is no related sites. From this dropdown you can associate your database with any website you have set up. This is a convenience feature to help associate a database with a website and is not required.
Line 29:		Line 29:
	== User Section ==		== User Section ==

	The next section is `Users`. In this section there are 5 items as well as two buttons.		The next section is 'Users'. In this section there are 5 items as well as two buttons.

	The first item is a checkbox to indicate whether or not you want to add a user while creating your database. This is checked by default.		The first item is a checkbox to indicate whether or not you want to add a user while creating your database. This is checked by default.
Line 35:		Line 35:
	The second item is the username, this will have a prefix of the same format as the database name.		The second item is the username, this will have a prefix of the same format as the database name.

	The third item is the password. This item is associated with the two buttons. The `Generate` button will generate a password for you. The second button will display the password on your screen. Generated passwords are hidden by default unless the show button is pressed. You can also enter any password you require. Once a password is entered a `Password Strength` meter will appear. There is a help button `(?)` with more details regarding this meter.		The third item is the password. This item is associated with the two buttons. The 'Generate' button will generate a password for you. The second button will display the password on your screen. Generated passwords are hidden by default unless the show button is pressed. You can also enter any password you require. Once a password is entered a 'Password Strength' meter will appear. There is a help button '(?)' with more details regarding this meter.

	The fourth item is a confirm password. This must match the password.		The fourth item is a confirm password. This must match the password.

	The fifth item is a checkbox to indicate a `User has access to all databases within the selected subscription`. This means the user can access all databases listed in the main `Databases` section.		The fifth item is a checkbox to indicate a 'User has access to all databases within the selected subscription'. This means the user can access all databases listed in the main 'Databases' section.

	The sixth item is access control. You have three choices. You can allow local only connections. You can allow connections from any IP, or you can submit a list of IPs or FQDNs. This list supports wildcards and examples are provided.		The sixth item is access control. You have three choices. You can allow local only connections. You can allow connections from any IP, or you can submit a list of IPs or FQDNs. This list supports wildcards and examples are provided.

	Once these sections are complete, you can click `OK` to create the database.		Once these sections are complete, you can click 'OK' to create the database.

	== DB User Permissions ==		== DB User Permissions ==

	In order to change user permissions and privileges, you have to navigate to the user. This is done from the `Databases` section. A list of users will be listed next to your databases. Click on the user you want to modify to proceed to the `Edit Database User` screen.		In order to change user permissions and privileges, you have to navigate to the user. This is done from the 'Databases' section. A list of users will be listed next to your databases. Click on the user you want to modify to proceed to the 'Edit Database User' screen.

	== DB User Editing ==		== DB User Editing ==
Line 63:		Line 63:
	== Local connections ==		== Local connections ==

	If you are connecting locally, then your `HOST` is `localhost`. Your database name is the name you specified, but prefixed with your Plesk username and then an underscore (e.g. PLESK_USERNAME_DATABASE).		If you are connecting locally, then your 'HOST' is 'localhost'. Your database name is the name you specified, but prefixed with your Plesk username and then an underscore (e.g. PLESK_USERNAME_DATABASE).

	== Managing the database with phpMyAdmin ==		== Managing the database with phpMyAdmin ==
Line 72:		Line 72:

	# Login to Plesk.		# Login to Plesk.
	# Click on `Remote MariaDB`.		# Click on 'Remote MariaDB'.
	# Put a percent sign `%` for all IP or else enter the IP to give access to only that particular IP in the box and click `Submit`.		# Put a percent sign '%' for all IP or else enter the IP to give access to only that particular IP in the box and click 'Submit'.

	== Server Hosts ==		== Server Hosts ==
Line 79:		Line 79:
	Use the host for your server:		Use the host for your server:

	* Tommy: `tommy.heliohost.org`		* Tommy: tommy.heliohost.org
	* Ricky: `ricky.heliohost.org`		* Ricky: ricky.heliohost.org
	* Johnny: `johnny.heliohost.org`		* Johnny: johnny.heliohost.org

	== Example Code Links ==		== Example Code Links ==

KazVee: /* DB User Editing */

2024-10-04T01:47:22Z

DB User Editing

← Older revision		Revision as of 01:47, 4 October 2024
Line 55:		Line 55:
	There are two items available while editing a user that aren't available while creating a database.		There are two items available while editing a user that aren't available while creating a database.

	You can assign roles: Read & Write, Read Only, Write Only, and Customer. There are also data/structure access which will specify which privileges a DB user has. See the [~~MariaDB privileges documentation](~~https://mariadb.com/docs/server/ref/mdb/privileges/) for more details on the individual privileges.		You can assign roles: Read & Write, Read Only, Write Only, and Customer. There are also data/structure access which will specify which privileges a DB user has. See the [https://mariadb.com/docs/server/ref/mdb/privileges/ MariaDB privileges documentation] for more details on the individual privileges.

	== Accessing the Database ==		== Accessing the Database ==

KazVee: KazVee moved page Creating MySQL Databases to MySQL without leaving a redirect

2024-10-04T01:41:15Z

KazVee moved page Creating MySQL Databases to MySQL without leaving a redirect

← Older revision	Revision as of 01:41, 4 October 2024
(No difference)