HCoop Git - hcoop/zz_old/ikiwiki/blob - MemberManual/Databases.mdwn

   1 #pragma section-numbers off
   2
   3 This is the chapter of the MemberManual that describes how to use PostgreSQL and MySQL databases on HCoop servers.
   4
   5 [[TableOfContents]]
   6
   7 = MySQL =
   8
   9 == Create an Account ==
  10 Creating a MySQL user account is an easy task with {{{dbtool}}}.  It is available for use when you login to mire.hcoop.net.
  11
  12 Run the following command:
  13
  14 {{{
  15 dbtool mysql adduser
  16 }}}
  17
  18 You will be asked for a password.  The user created will be the same as your log-in username.
  19
  20 == Create a Database ==
  21 {{{dbtool}}} is also used to create new MySQL databases.  Replace DATABASE with your desired database name:
  22
  23 {{{
  24 dbtool mysql createdb DATABASE
  25 }}}
  26
  27 The database created will be USER_DATABASE (where USER is your username and DATABASE is the name you provided {{{dbtool}}}).
  28
  29 == Delete a Database ==
  30 Delete a database with the following:
  31
  32 {{{
  33 dbtool mysql dropdb DATABASE
  34 }}}
  35
  36 == Changing Your Password ==
  37 If you need to change your MySQL password for security purposes or you have forgotten it, you may do so with this command:
  38
  39 {{{
  40 dbtool mysql passwd
  41 }}}
  42
  43 You will be prompted to input a new password.
  44
  45 == Accessing Databases ==
  46 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.
  47
  48 In addition, you can easily use the {{{mysql}}} shell to manipulate or analyze your databases:
  49
  50 {{{
  51 mysql -p -h mysql USER_DATABASE
  52 }}}
  53
  54 For security reasons, you cannot drop a database using the {{{mysql}}} shell.
  55
  56 To learn more about the MySQL shell, review the [http://dev.mysql.com/doc/refman/5.0/en/ MySQL manual].
  57
  58
  59 = PostgreSQL =
  60
  61 == Create an Account ==
  62 To create a PostgreSQL user account, enter the following command on mire.hcoop.net:
  63
  64 {{{dbtool postgres adduser}}}
  65
  66 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.
  67
  68 == Create a Database ==
  69 Additionally, {{{dbtool}}} is used to create new Postgres databases.  Replace DATABASE with your desired database name:
  70
  71 {{{
  72 dbtool postgres createdb DATABASE
  73 }}}
  74
  75 The database created will be called USER_DATABASE (where USER is your username and DATABASE is the name you provided {{{dbtool}}}).
  76
  77 == Delete a Database ==
  78 Delete a database with the following command:
  79
  80 {{{
  81 dbtool postgres dropdb DATABASE
  82 }}}
  83
  84 For security reasons, you cannot drop a database using the {{{psql}}} shell.
  85
  86 == Accessing Databases ==
  87 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.
  88
  89 It is very easy to access your database using a PostgreSQL shell:
  90
  91 {{{
  92 psql -h postgres USER_DATABASE
  93 }}}
  94
  95 To learn more about the {{{psql}}} shell, take a look at the [http://www.postgresql.org/docs/8.1/interactive/index.html PostgreSQL manual].