MySQL Database

No matter the engineering purpose, a MySQL database will keep track of what is vital to you.

CAEDM users and groups may have a MySQL database. The database must be for legitimate academic purposes related to the college.

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 group's name
default schema: your CAEDM username or group name (not always required)
database name: your CAEDM username or group 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.

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.