(→Creating a database) |
(→Quick Connect Facts) |
||
| Line 13: | Line 13: | ||
username: your CAEDM username or group's name | username: your CAEDM username or group's name | ||
| − | The host name for the database is caedmdb.et.byu.edu and the name of the database is your username, or the name of the group if it is a group's database. In order to login to the database through linux or unix, open a console window and type: mysql -h caedmdb.et.byu.edu -u your_username -p | + | The host name for the database is caedmdb.et.byu.edu and the name of the database is your username, or the name of the group if it is a group's database. In order to login to the database through linux or unix, open a console window and type: |
| + | |||
| + | mysql -h caedmdb.et.byu.edu -u your_username -p | ||
You will then be prompted for your password. This is the password that is set for the database in the account manager. You will then be be presented with the mysql> prompt. | You will then be prompted for your password. This is the password that is set for the database in the account manager. You will then be be presented with the mysql> prompt. | ||
| + | |||
===Using a database=== | ===Using a database=== | ||
For more information on mysql, read the [http://dev.mysql.com/doc/refman/4.1/en/index.html mysql tutorial] provided by the MySQL project. | For more information on mysql, read the [http://dev.mysql.com/doc/refman/4.1/en/index.html mysql tutorial] provided by the MySQL project. | ||
[[Category:Services]] | [[Category:Services]] | ||
Revision as of 16:16, 15 March 2013
CAEDM users and groups may have a MySQL database. The database must be for legitimate academic purposes related to the college.
Contents
Creating a database
To request database access, send an email to unix@et.byu.edu with a description of the project you are working on. The Linux administrator will determine the legitimacy of the request and may grant you access.
Once access has been granted, the user must log in to the CAEDM Account Manager and set the password for their database. In the case of a group database, the password must be set by the group owner. The group database password field can be found in the "Groups" -> "Modify <group_name>" -> "Database" section of the CAEDM Account Manager.
For security reasons we ask that the MySQL database password be different than a user's CAEDM account password.
Connecting to a database
Quick Connect Facts
servername: caedmdb.et.byu.edu username: your CAEDM username or group's name
The host name for the database is caedmdb.et.byu.edu and the name of the database is your username, or the name of the group if it is a group's database. In order to login to the database through linux or unix, open a console window and type:
mysql -h caedmdb.et.byu.edu -u your_username -p
You will then be prompted for your password. This is the password that is set for the database in the account manager. You will then be be presented with the mysql> prompt.
Using a database
For more information on mysql, read the mysql tutorial provided by the MySQL project.
