--- /dev/null
+#pragma section-numbers off\r
+\r
+This is the chapter of the MemberManual that describes how to use PostgreSQL and MySQL databases on HCoop servers.\r
+\r
+[[TableOfContents]]\r
+\r
+= MySQL =\r
+\r
+== Create an Account ==\r
+Creating a MySQL user account is an easy task with {{{dbtool}}}. It is available for use when you login to mire.hcoop.net. \r
+\r
+Run the following command:\r
+\r
+{{{\r
+dbtool mysql adduser\r
+}}}\r
+\r
+You will be asked for a password. The user created will be the same as your log-in username.\r
+\r
+== Create a Database ==\r
+{{{dbtool}}} is also used to create new MySQL databases. Replace DATABASE with your desired database name:\r
+\r
+{{{\r
+dbtool mysql createdb DATABASE\r
+}}}\r
+\r
+The database created will be USER_DATABASE (where USER is your username and DATABASE is the name you provided {{{dbtool}}}).\r
+\r
+== Delete a Database ==\r
+Delete a database with the following:\r
+\r
+{{{\r
+dbtool mysql dropdb DATABASE\r
+}}}\r
+\r
+== Changing Your Password ==\r
+If you need to change your MySQL password for security purposes or you have forgotten it, you may do so with this command:\r
+\r
+{{{\r
+dbtool mysql passwd\r
+}}}\r
+\r
+You will be prompted to input a new password.\r
+\r
+== Accessing Databases ==\r
+For web applications, set the MySQL host/server to {{{mysql}}}. Default ports apply. Use your HCoop username. Your password will be required. Please safeguard it. Remember that your database is really named USER_DATABASE, where DATABASE is the name you originally gave {{{dbtool}}}. Follow your software package's instructions.\r
+\r
+In addition, you can easily use the {{{mysql}}} shell to manipulate or analyze your databases:\r
+\r
+{{{\r
+mysql -p -h mysql USER_DATABASE\r
+}}}\r
+\r
+For security reasons, you cannot drop a database using the {{{mysql}}} shell.\r
+\r
+To learn more about the MySQL shell, review the [http://dev.mysql.com/doc/refman/5.0/en/ MySQL manual].\r
+\r
+\r
+= PostgreSQL =\r
+\r
+== Create an Account ==\r
+To create a PostgreSQL user account, enter the following command on mire.hcoop.net:\r
+\r
+{{{dbtool postgres adduser}}}\r
+\r
+You will not be prompted for a password since PostgreSQL utilizes a security model that is quite different from MySQL. The user created will be the same as your log-in username.\r
+\r
+== Create a Database ==\r
+Additionally, {{{dbtool}}} is used to create new Postgres databases. Replace DATABASE with your desired database name:\r
+\r
+{{{\r
+dbtool postgres createdb DATABASE\r
+}}}\r
+\r
+The database created will be called USER_DATABASE (where USER is your username and DATABASE is the name you provided {{{dbtool}}}).\r
+\r
+== Delete a Database ==\r
+Delete a database with the following command:\r
+\r
+{{{\r
+dbtool postgres dropdb DATABASE\r
+}}}\r
+\r
+For security reasons, you cannot drop a database using the {{{psql}}} shell.\r
+\r
+== Accessing Databases ==\r
+For web applications, set the PostgreSQL host/server to {{{postgres}}}. Default ports apply. Use your HCoop username. A password is not required. Remember that your database is really named USER_DATABASE, where DATABASE is the name you originally gave {{{dbtool}}}. Follow your software package's instructions.\r
+\r
+It is very easy to access your database using a PostgreSQL shell:\r
+\r
+{{{\r
+psql -h postgres USER_DATABASE\r
+}}}\r
+\r
+To learn more about the {{{psql}}} shell, take a look at the [http://www.postgresql.org/docs/8.1/interactive/index.html PostgreSQL manual].\r