If you would like access to a MySQL database then send an e-mail to admin@socis.ca to request one, the following information should be included.

1) Send the email from your @uoguelph account so that we know who you are.

2) Suggest a database name. We will try to accommodate the name you want if it is available. The default is that it will be the same as your username.

3) A password hash should be given if you would like your password to be set to something you would like, otherwise the admins will generate something for you of adequate strength. You can generate your password hash here if you like: http://socis.ca/hash.html

4)Lastly, if you would intend for this database to be used by a website that is not hosted on teddie, then you will need to request remote access.

Without remote access, your database will only be accessible through the MySQL shell if you SSH into teddie, and over localhost for any php scripts or the like that are hosted on teddie. If you know the host or have a static IP that will always be connecting to the database, you can specify that and it will also be able to be connected from only that host as well as teddie.

If you don't have a static IP or reliable hostname that you will be connecting from, then you will need universal remote access, which means that your database can be accessed from anywhere, and could be vulnerable to attack from the outside. For that reason we recommend that you do not request universal remote access unless necessary, and that if you do, that your password be of adequate strength.