|
Size: 2685
Comment: add content... maybe I've created too many sections?
|
Size: 2844
Comment: get rid of some redundancy, reduce sections a bit... clarify a little
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 10: | Line 10: |
| 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. | 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. |
| Line 12: | Line 12: |
| === Creating Databases === | === Creating and Deleting Databases === |
| Line 15: | Line 15: |
| === Deleting Databases === Using {{{dbtool}}}, you may drop a specified database. Replace DATABASE with your desired database: {{{dbtool mysql dropdb DATABASE}}}. |
Delete a database with the following: {{{dbtool mysql dropdb DATABASE}}}. |
| Line 22: | Line 21: |
| For web applications, set the MySQL host/server to {{{mysql}}}. Default ports apply. Follow your software package's instructions. | For web applications, set the MySQL host/server to {{{mysql}}}. Default ports apply. Your password will be required. Please safeguard it. Follow your software package's instructions. |
| Line 24: | Line 23: |
| 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 }}} | In addition, you can easily use the {{{mysql}}} shell to manipulate or analyze your databases: {{{ mysql -p -h mysql USER_DATABASE }}}. For security reasons, you cannot drop a database using the {{{mysql}}} shell. To learn more about the MySQL shell, review the [http://dev.mysql.com/doc/refman/5.0/en/ MySQL manual]. |
| Line 29: | Line 30: |
| === 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}}}. |
|
| Line 32: | Line 31: |
| === Creating and Deleting 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}}}. |
|
| Line 33: | Line 34: |
| === Deleting Databases === Using {{{dbtool}}}, you may also drop specified databases. Replace DATABASE with your desired database: {{{dbtool postgres dropdb DATABASE}}}. |
Delete a database with the following command: {{{dbtool postgres dropdb DATABASE}}}. For security reasons, you cannot drop a database using the {{{psql}}} shell. |
| Line 37: | Line 37: |
| For web applications, set the PostgreSQL host/server to {{{postgres}}}. Default ports apply. Follow your software package's instructions. | For web applications, set the PostgreSQL host/server to {{{postgres}}}. Default ports apply. A password is not required. Follow your software package's instructions. |
| Line 39: | Line 39: |
| 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 | It is very easy to access your database using a PostgreSQL shell: {{{psql -h postgres USER_DATABASE}}}. To learn more about the {{{psql}}} shell, take a loot at the [http://www.postgresql.org/docs/8.1/interactive/index.html PostgreSQL manual]. |
This is the chapter of the MemberManual that describes how to use PostgreSQL and MySQL databases on HCoop servers.
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 and Deleting 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).
Delete a database with the following: 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. Your password will be required. Please safeguard it. Follow your software package's instructions.
In addition, you can easily use the mysql shell to manipulate or analyze your databases: mysql -p -h mysql USER_DATABASE . For security reasons, you cannot drop a database using the mysql shell.
To learn more about the MySQL shell, review the [http://dev.mysql.com/doc/refman/5.0/en/ MySQL manual].
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 and Deleting 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.
Delete a database with the following command: dbtool postgres dropdb DATABASE. For security reasons, you cannot drop a database using the psql shell.
Accessing Databases
For web applications, set the PostgreSQL host/server to postgres. Default ports apply. A password is not required. Follow your software package's instructions.
It is very easy to access your database using a PostgreSQL shell: psql -h postgres USER_DATABASE.
To learn more about the psql shell, take a loot at the [http://www.postgresql.org/docs/8.1/interactive/index.html PostgreSQL manual].