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
Basics for using mysql can be found at the mysql tutorial, provided by the MySQL project. In the same place is the MySQL Reference Manual for several versions of MySQL, from version 3.23 on up.
