#pragma section-numbers off

This is the chapter of the MemberManual that describes how to use PostgreSQL and MySQL databases on HCoop servers.

[[TableOfContents]]

== MySQL ==
Creating a MySQL user account is an easy task with {{{dbtool}}}.  It is available for use when you login to mire.hcoop.net.  

Run the following command:{{{dbtool mysql adduser}}}.  You will be asked for a password.  The user created will be the same as your log-in username.

=== Creating Databases ===
{{{dbtool}}} is also used to create new MySQL databases.  Replace DATABASE with your desired database name: {{{dbtool mysql createdb DATABASE}}}. The database created will be USER_DATABASE (where USER is your username and database is the name you provided {{{dbtool}}}).

=== Deleting Databases ===
Using {{{dbtool}}}, you may drop a specified database.  Replace DATABASE with your desired database: {{{dbtool mysql dropdb DATABASE}}}.

=== Changing Your Password ===
If you need to change your MySQL password for security purposes or you have forgotten it, you may do so with this command: {{{dbtool mysql passwd}}}.  You will be prompted to input a new password.

=== Accessing Databases ===
For web applications, set the MySQL host/server to {{{mysql}}}.  Default ports apply.  Follow your software package's instructions.

In addition, you can easily use the {{{mysql}}} shell to manipulate or analyze your databases.  Replace USER with your username and DATABASE with the name you gave {{{dbtool}}} to create it: {{{ mysql -p -h mysql USER_DATABASE }}} 

== PostgreSQL ==
To create a PostgreSQL user account, enter the following command on mire.hcoop.net: {{{dbtool postgres adduser}}}.  You will not be prompted for a password since PostgreSQL utilizes a security model that is quite different from MySQL.

=== Creating Databases ===
Additionally, {{{dbtool}}} is used to create new MySQL databases.  Replace DATABASE with your desired database name: {{{dbtool postgres createdb DATABASE}}}.   The database created will be called USER_DATABASE (where USER is your username and database is the name you provided {{{dbtool}}}.


=== Deleting Databases ===
Using {{{dbtool}}}, you may also drop specified databases.  Replace DATABASE with your desired database: {{{dbtool postgres dropdb DATABASE}}}.

=== Accessing Databases ===
For web applications, set the PostgreSQL host/server to {{{postgres}}}.  Default ports apply.  Follow your software package's instructions.

It is very easy to access your database using a PostgreSQL shell.  Replace USER with your username and DATABASE with the database name you gave {{{dbtool}}}:  psql -h postgres USER_DATABASE