|
Size: 2685
Comment: add content... maybe I've created too many sections?
|
Size: 3087
Comment: more clarifications
|
| 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. Remember that your database is really named USER_DATABASE, where DATABASE is the name you originally gave {{{dbtool}}}. 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. Remember that your database is really named USER_DATABASE, where DATABASE is the name you originally gave {{{dbtool}}}. 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. Remember that your database is really named USER_DATABASE, where DATABASE is the name you originally gave dbtool. 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. Remember that your database is really named USER_DATABASE, where DATABASE is the name you originally gave dbtool. 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].