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 website 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" -> "Manage My Groups" -> "Modify <group_name>" -> "Database" section of the CAEDM Website.
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 the group's name default schema: your CAEDM username OR the group's name (not always required) database name: your CAEDM username OR the 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:
For a user database: mysql -h caedmdb.et.byu.edu -u username -p For a group database: mysql -h caedmdb.et.byu.edu -u groupname -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.
Alternatively, you can download and install the latest version of MySQL Workbench. You may receive a warning on connection about version differences, but you can ignore that warning.
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.
