(→Creating a database) |
|||
| Line 1: | Line 1: | ||
| − | CAEDM users and groups may have a MySQL database. The database must be for legitimate academic purposes related to the college. | + | CAEDM users and [[CAEDM groups|groups]] may have a MySQL database. The database must be for legitimate academic purposes related to the college. |
===Creating a database=== | ===Creating a database=== | ||
| Line 14: | Line 14: | ||
===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]] | ||
Revision as of 09:20, 14 March 2012
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
In order to request use of a database, send an email to unix@et.byu.edu. The Linux administrator will determine the legitimacy of the request and may grant you access. Once access has been granted, users can log in to the CAEDM Account Manager and set the password to their database. 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.
