welcome: please sign in

Upload page content

You can upload content for the page named below. If you change the page name, you can also upload content for another page. If the page name is empty, we derive the page name from the file name.

File to load page content from
Page name
Comment
Last name of the current Debian Project Leader

Revision 2 as of 2007-10-27 05:17:03

Edit

MemberManual / Databases

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