Using MySQL - Revision history

Erico: remove SQL workbench

2022-10-01T13:28:49Z

remove SQL workbench

← Older revision		Revision as of 15:28, 1 October 2022
Line 46:		Line 46:
	We can then kill the process using kill with the pid we acquired:		We can then kill the process using kill with the pid we acquired:
	kill 12657		kill 12657

	~~====MySQL Workbench====~~
	While [https://www.mysql.com/products/workbench/ MySQL Workbench] might not fully support our MySQL database, all commonly used operations work perfectly. You can connect to our database using MySQL Workbench by creating a connection as follows ([username] should be replaced by your username, of course):
	~~[[File:MySQL_Workbench_SSH.png]]~~

	[[Category:Databases]]		[[Category:Databases]]

Erico: pgsql replaced with mysql in pgrep command

2022-10-01T12:34:28Z

pgsql replaced with mysql in pgrep command

← Older revision		Revision as of 14:34, 1 October 2022
Line 41:		Line 41:

	If you prefer the command to be run in the background, you can add <code>-f</code> to your command. To close this background process, you can use pgrep to acquire the pid of the process:		If you prefer the command to be run in the background, you can add <code>-f</code> to your command. To close this background process, you can use pgrep to acquire the pid of the process:
	pgrep --list-full ssh \| grep ~~pgsql~~.ulyssis.org		pgrep --list-full ssh \| grep mysql.ulyssis.org
	12657 ssh -f username@ssh2.ulyssis.org -L 5400:~~pgsql~~.ulyssis.org:5432 -N		12657 ssh -f username@ssh2.ulyssis.org -L 5400:mysql.ulyssis.org:5432 -N

	We can then kill the process using kill with the pid we acquired:		We can then kill the process using kill with the pid we acquired:

Erico: expanded SSH explanation

2022-09-30T08:14:38Z

expanded SSH explanation

← Older revision		Revision as of 10:14, 30 September 2022
Line 40:		Line 40:
	To terminate the port forwarding, press ctrl-C in the terminal.		To terminate the port forwarding, press ctrl-C in the terminal.

	~~You~~ can use "ssh -f username@ssh2.ulyssis.org -L ~~3300~~:~~mysql~~.ulyssis.org:~~3306~~ -N~~": the f-argument will put the command in the background.~~		If you prefer the command to be run in the background, you can add <code>-f</code> to your command. To close this background process, you can use pgrep to acquire the pid of the process:
			pgrep --list-full ssh \| grep pgsql.ulyssis.org
			12657 ssh -f username@ssh2.ulyssis.org -L 5400:pgsql.ulyssis.org:5432 -N

	==== MySQL Workbench ====		We can then kill the process using kill with the pid we acquired:
			kill 12657

			====MySQL Workbench====
	While [https://www.mysql.com/products/workbench/ MySQL Workbench] might not fully support our MySQL database, all commonly used operations work perfectly. You can connect to our database using MySQL Workbench by creating a connection as follows ([username] should be replaced by your username, of course):		While [https://www.mysql.com/products/workbench/ MySQL Workbench] might not fully support our MySQL database, all commonly used operations work perfectly. You can connect to our database using MySQL Workbench by creating a connection as follows ([username] should be replaced by your username, of course):
	[[File:MySQL_Workbench_SSH.png]]		[[File:MySQL_Workbench_SSH.png]]

	[[Category:Databases]]		[[Category:Databases]]

Erico: Accessing MySQL aangepast zoals uitgelegd in wikipagina documentatie herschrijven, nog wat meer nodig bij ssh

2022-09-29T14:31:01Z

Accessing MySQL aangepast zoals uitgelegd in wikipagina documentatie herschrijven, nog wat meer nodig bij ssh

← Older revision		Revision as of 16:31, 29 September 2022
Line 17:		Line 17:

	===Using MySQL for your website or application===		===Using MySQL for your website or application===
			you can connect to the database with the following details:
	Host: mysql.ulyssis.org		Host: mysql.ulyssis.org
	Username: your account's username		Username: your account's username
Line 33:		Line 34:
	To prevent unnecessary load on our database server by hackers and bots it is only available inside of our network. If you wish to access it externally the easiest way is to use an SSH tunnel. In many MySQL management tools this is already supported.		To prevent unnecessary load on our database server by hackers and bots it is only available inside of our network. If you wish to access it externally the easiest way is to use an SSH tunnel. In many MySQL management tools this is already supported.

	~~==== MySQL Workbench ====~~		On Linux, Mac OSX and other Unix-like Operating Systems it is also easily possible to use the following command to create a tunnel to a local port (in this case 3300)
	While [https://www.mysql.com/products/workbench/ MySQL Workbench] might not fully support our MySQL database, all commonly used operations work perfectly. You can connect to our database using MySQL Workbench by creating a connection as follows ([username] should be replaced by your username, of course):
	~~[[File:MySQL_Workbench_SSH.png]]~~

	~~==== Linux, Mac OSX ====~~
	On Linux, Mac OSX and other Unix-like Operating Systems it is also easily possible to use the following command to create a tunnel to a local port (in this case 3300)
	ssh username@ssh2.ulyssis.org -L 3300:mysql.ulyssis.org:3306 -N		ssh username@ssh2.ulyssis.org -L 3300:mysql.ulyssis.org:3306 -N

Line 45:		Line 41:

	You can use "ssh -f username@ssh2.ulyssis.org -L 3300:mysql.ulyssis.org:3306 -N": the f-argument will put the command in the background.		You can use "ssh -f username@ssh2.ulyssis.org -L 3300:mysql.ulyssis.org:3306 -N": the f-argument will put the command in the background.

			==== MySQL Workbench ====
			While [https://www.mysql.com/products/workbench/ MySQL Workbench] might not fully support our MySQL database, all commonly used operations work perfectly. You can connect to our database using MySQL Workbench by creating a connection as follows ([username] should be replaced by your username, of course):
			[[File:MySQL_Workbench_SSH.png]]

	[[Category:Databases]]		[[Category:Databases]]

Pcy: fix wording and punctuation a little bit

2020-12-16T18:04:32Z

fix wording and punctuation a little bit

Bert: /* Accessing MySQL */

2020-12-16T00:08:43Z

Accessing MySQL

← Older revision		Revision as of 02:08, 16 December 2020
Line 14:		Line 14:

	== Accessing MySQL ==		== Accessing MySQL ==
			Our MySQL and PostgreSQL databases run on a separate database server, this means you may need to enter a specific host, together with the correct credentials, to access your database within a website or application. You may also wish to use a common tool such as PHPMyAdmin or access a database remotely. Details on how to do that are available in the sections below.

	===Using MySQL for your website or application===		===Using MySQL for your website or application===

Bert: /* Managing MySQL */

2020-12-16T00:06:52Z

Managing MySQL

← Older revision		Revision as of 02:06, 16 December 2020
Line 2:		Line 2:

	== Managing MySQL ==		== Managing MySQL ==
			All common management tasks can be performed through our control panel [https://ucc.ulyssis.org UCC] under the MySQL section.

	===Creating a MySQL user===		===Creating a MySQL user===
	To use MySQL on your ULYSSIS account you first need to create a MySQL user on [https://ucc.ulyssis.org UCC]. In the MySQL section of the panel you will be suggested to click a link to create a user. Then fill in a password for the database user. It is highly recommended that this password differs from the password you use for your account. Then you just click ''Create user'' and you are ready to go.		To use MySQL on your ULYSSIS account you first need to create a MySQL user on [https://ucc.ulyssis.org UCC]. In the MySQL section of the panel you will be suggested to click a link to create a user. Then fill in a password for the database user. It is highly recommended that this password differs from the password you use for your account. Then you just click ''Create user'' and you are ready to go.

Bert at 00:04, 16 December 2020

2020-12-16T00:04:46Z

← Older revision		Revision as of 02:04, 16 December 2020
Line 1:		Line 1:
	==Creating a MySQL user==		MySQL is one of the most popular databases for websites. It's used by most CMSes and other common web software, and many programming languages have support for it. ULYSSIS specifically uses MariaDB, which is a fork of MySQL with similar features and (almost) identical SQL syntax, but offers better performance and has less corporate interference in the development process.

			== Managing MySQL ==
			===Creating a MySQL user===
	To use MySQL on your ULYSSIS account you first need to create a MySQL user on [https://ucc.ulyssis.org UCC]. In the MySQL section of the panel you will be suggested to click a link to create a user. Then fill in a password for the database user. It is highly recommended that this password differs from the password you use for your account. Then you just click ''Create user'' and you are ready to go.		To use MySQL on your ULYSSIS account you first need to create a MySQL user on [https://ucc.ulyssis.org UCC]. In the MySQL section of the panel you will be suggested to click a link to create a user. Then fill in a password for the database user. It is highly recommended that this password differs from the password you use for your account. Then you just click ''Create user'' and you are ready to go.

	==Creating a MySQL database==		===Creating a MySQL database===
	After creating a MySQL user, you can simple press ''Add database'' in [https://ucc.ulyssis.org UCC] and enter the name for your new database. It will automatically be prefixed by your username.		After creating a MySQL user, you can simple press ''Add database'' in [https://ucc.ulyssis.org UCC] and enter the name for your new database. It will automatically be prefixed by your username.

	==Deleting a MySQL database==		===Deleting a MySQL database===
	If you no longer need a database, you can easily remove it by clicking on ''MySQL'' in [https://ucc.ulyssis.org UCC] and then pressing on ''Remove database'' next to the database you would like to delete. After confirming, the database and all its tables and other contents will be gone. For security reasons, you can't remove databases using an SQL query like DROP DATABASE, but have to go through UCC.		If you no longer need a database, you can easily remove it by clicking on ''MySQL'' in [https://ucc.ulyssis.org UCC] and then pressing on ''Remove database'' next to the database you would like to delete. After confirming, the database and all its tables and other contents will be gone. For security reasons, you can't remove databases using an SQL query like DROP DATABASE, but have to go through UCC.

	==Using MySQL for your website or application==		== Accessing MySQL ==

			===Using MySQL for your website or application===
	Host: mysql.ulyssis.org		Host: mysql.ulyssis.org
	Username: your account's username		Username: your account's username
Line 19:		Line 24:
	<syntaxhighlight lang="php">$db = new PDO('mysql:host=mysql.ulyssis.org;dbname=foobar_website', 'foobar', 'correct horse battery staple');</syntaxhighlight>		<syntaxhighlight lang="php">$db = new PDO('mysql:host=mysql.ulyssis.org;dbname=foobar_website', 'foobar', 'correct horse battery staple');</syntaxhighlight>

	==~~Managing~~ MySQL with PHPMyAdmin==		===Accessing MySQL with PHPMyAdmin or Adminer===
	Using your username and password you can easily manage your MySQL databases, tables and records on https://phpmyadmin.ulyssis.org		Using your username and password you can easily manage your MySQL databases, tables and records on https://phpmyadmin.ulyssis.org and https://adminer.ulyssis.org. Documentation is also available to aid in [[using PHPMyAdmin]] and [[using Adminer]]

	==Accessing MySQL from outside of our network==		===Accessing MySQL from outside of our network===
	To prevent unnecessary load on our database server by hackers and bots it is only available inside of our network. If you wish to access it externally the easiest way is to use an SSH-tunnel. In many MySQL management tools this is already supported.		To prevent unnecessary load on our database server by hackers and bots it is only available inside of our network. If you wish to access it externally the easiest way is to use an SSH-tunnel. In many MySQL management tools this is already supported.

	=== MySQL Workbench ===		==== MySQL Workbench ====
	While [https://www.mysql.com/products/workbench/ MySQL Workbench] might not fully support our MySQL database, all commonly used operations work perfectly. You can connect to our database using MySQL Workbench by creating a connection as follows ([username] should be replaced by your username, of course):		While [https://www.mysql.com/products/workbench/ MySQL Workbench] might not fully support our MySQL database, all commonly used operations work perfectly. You can connect to our database using MySQL Workbench by creating a connection as follows ([username] should be replaced by your username, of course):
	[[File:MySQL_Workbench_SSH.png]]		[[File:MySQL_Workbench_SSH.png]]

	=== Linux, Mac OSX ===		==== Linux, Mac OSX ====
	On Linux, Mac OSX and other Unix-like Operating Systems it is also easily possible to use the following command to create a tunnel to a local port (in this case 3300)		On Linux, Mac OSX and other Unix-like Operating Systems it is also easily possible to use the following command to create a tunnel to a local port (in this case 3300)
	ssh username@ssh2.ulyssis.org -L 3300:mysql.ulyssis.org:3306 -N		ssh username@ssh2.ulyssis.org -L 3300:mysql.ulyssis.org:3306 -N

Bert: /* Creating a MySQL database */

2020-12-15T23:31:02Z

Creating a MySQL database

← Older revision		Revision as of 01:31, 16 December 2020
Line 4:		Line 4:
	==Creating a MySQL database==		==Creating a MySQL database==
	After creating a MySQL user, you can simple press ''Add database'' in [https://ucc.ulyssis.org UCC] and enter the name for your new database. It will automatically be prefixed by your username.		After creating a MySQL user, you can simple press ''Add database'' in [https://ucc.ulyssis.org UCC] and enter the name for your new database. It will automatically be prefixed by your username.

			==Deleting a MySQL database==
			If you no longer need a database, you can easily remove it by clicking on ''MySQL'' in [https://ucc.ulyssis.org UCC] and then pressing on ''Remove database'' next to the database you would like to delete. After confirming, the database and all its tables and other contents will be gone. For security reasons, you can't remove databases using an SQL query like DROP DATABASE, but have to go through UCC.

	==Using MySQL for your website or application==		==Using MySQL for your website or application==

Bert at 15:20, 28 August 2019

2019-08-28T15:20:08Z

← Older revision		Revision as of 17:20, 28 August 2019
Line 34:		Line 34:

	You can use "ssh -f username@ssh2.ulyssis.org -L 3300:mysql.ulyssis.org:3306 -N": the f-argument will put the command in the background.		You can use "ssh -f username@ssh2.ulyssis.org -L 3300:mysql.ulyssis.org:3306 -N": the f-argument will put the command in the background.

			[[Category:Databases]]

← Older revision		Revision as of 20:04, 16 December 2020
Line 2:		Line 2:

	== Managing MySQL ==		== Managing MySQL ==
	All common management tasks can be performed through our control panel [https://ucc.ulyssis.org UCC] under the MySQL section.		All common management tasks can be performed through our control panel [https://ucc.ulyssis.org UCC], under the MySQL section.

	===Creating a MySQL user===		===Creating a MySQL user===
	To use MySQL on your ULYSSIS account you first need to create a MySQL user on [https://ucc.ulyssis.org UCC]. In the MySQL section of the panel you will be suggested to click a link to create a user. Then fill in a password for the database user. It is highly recommended that this password differs from the password you use for your account. ~~Then you just~~ click ''Create user'' and you are ready to go.		To use MySQL on your ULYSSIS account, you first need to create a MySQL user on [https://ucc.ulyssis.org UCC]. In the MySQL section of the panel, you will be suggested to click a link to create a user. Then fill in a password for the database user. It is highly recommended that this password differs from the password you use for your account. Finally, click ''Create user'' and you are ready to go.

	===Creating a MySQL database===		===Creating a MySQL database===
	After ~~creating~~ a MySQL user, you can ~~simple press~~ ''Add database'' in [https://ucc.ulyssis.org UCC] and enter the name for your new database. It will automatically be prefixed by your username.		After having created a MySQL user, you can click ''Add database'' in [https://ucc.ulyssis.org UCC] and enter the name for your new database. It will automatically be prefixed by your username.

	===Deleting a MySQL database===		===Deleting a MySQL database===
Line 28:		Line 28:

	===Accessing MySQL with PHPMyAdmin or Adminer===		===Accessing MySQL with PHPMyAdmin or Adminer===
	Using your username and password you can easily manage your MySQL databases, tables and records on https://phpmyadmin.ulyssis.org and https://adminer.ulyssis.org. Documentation is also available to aid in [[using PHPMyAdmin]] and [[using Adminer]]		Using your username and password you can easily manage your MySQL databases, tables and records on https://phpmyadmin.ulyssis.org and https://adminer.ulyssis.org. Documentation is also available to aid in [[using PHPMyAdmin]] and [[using Adminer]].

	===Accessing MySQL from outside of our network===		===Accessing MySQL from outside of our network===
	To prevent unnecessary load on our database server by hackers and bots it is only available inside of our network. If you wish to access it externally the easiest way is to use an SSH-tunnel. In many MySQL management tools this is already supported.		To prevent unnecessary load on our database server by hackers and bots it is only available inside of our network. If you wish to access it externally the easiest way is to use an SSH tunnel. In many MySQL management tools this is already supported.

	==== MySQL Workbench ====		==== MySQL Workbench ====