Database Manager

Contents

• Availabilty of Database Manager for your account
  • Database Manager works with up to two databases
• Login to Database Manager
  • First time
  • Repeat visits
• Using Database Manager
  • Adding a MySQL database to your site
  • Deleting a MySQL database from your site
  • Changing your MySQL password

Availabilty of Database Manager for your account

Database Manager is available on all Unix Value and higher hosting packages. Our legacy non-profit hosting package is the equivalent of a Lite hosting package, which does not come with database support. If you are not sure what type of hosting package you have, contact our 24/7 support staff at 503-968-3279 and we can look up details about your package type.

Database Manager works with up to two databases

Database Manager allows you to add up to a maximum of two databases for your site. Each database may contain as many tables as you need, up to the limit allowed by MySQL or practical limits imposed by performance.

If you need more than two databases, each database beyond the second database must be created manually by an EasyStreet engineer. Adding a database takes a minimum of 24 hours and incurs a setup fee of $99 per each additional database. Request an additional database by contacting your account manager at 503-646-8400 during business hours to place an order. Once more than two databases have been enabled for your site, Database Manager will not work to manage your databases. You must use an alternative method of managing your databases such as command line mysql or phpMyAdmin. See managing your MySQL databases for more information.

Login to Database Manager

• First time
• Repeat visits

Logging in to Database Manager the first time

1. The Database Manager application will only work reliably under recent versions of Internet Explorer web browser for PC users and Safari web browser for Mac OS X users. If you are using a different browser, please switch to one of the supported ones now.

2. Login to your WebSiteOS control panel.

3. Click on the Website Management link on the upper left navigation bar

   

4. Select Database Manager by clicking on that link in the lower left navigation bar:

   

5. Since this is the first time you are using your MySQL account, Database Manager will prompt you to set a MySQL password for your account. We recommend chosing a password that is between 7 and 12 characters long:

   

6. You will then be taken to the normal login screen where you must select your username from the pulldown menu on the left, by clicking on it once, and type your new password in the box at the right:

   

7. You are now logged in. Proceed to using Database Manager instructions.

Logging in to Database Manager on repeat visits

1. The Database Manager application will only work reliably under recent versions of Internet Explorer web browser for PC users and Safari web browser for Mac OS X users. If you are using a different browser, please switch to one of the supported ones now.

2. Login to your WebSiteOS control panel.

3. Click on the Website Management link on the upper left navigation bar

   

4. Select Database Manager by clicking on that link in the lower left navigation bar:

   

5. You will then be taken to the login screen where you must select your username from the pulldown menu on the left by clicking on it once and type your new password in the box at the right:

   

6. You are now logged in. Proceed to using Database Manager instructions.

Using Database Manager

Database Manager should be used to change your database password or to create and drop databases Once the databases have been created, you should use something other than Database Manager to popluate your databases with tables and data. See managing your MySQL databases for more suggestions.

Adding a MySQL database to your site

You must use Database Manager to add a database to your site. No other methods of adding the database will work reliably.

1. These instructions assume you have already logged in to Database Manager using one of the supported web browsers.

2. You will see a menu on the left with Create as one of the options. Click on the word Create:

   

3. A new menu should appear to the right with Database as one of the options. Click once on the word Database.

   

4. You will then be presented with a screen which shows you how many of the two allowed databases you are using. This control panel will only work for adding up to two databases. Adding more than two databases requires a sales order and must be done by an EasyStreet engineer, see adding more than two databases for details.

   Note that your database name may not contain any spaces or special characters such as a period . or a hyphen -. In addition, your domain name will be appended to the end of the database name you choose in the format _yourdomain_com. For the domain hahnmeyerphotos.org, for example, the database names chosen will end in _hahnmeyerphotos_org.

   Once you have typed a database name, click Build Query.

   

5. Click on the Run Query button.

   

6. You should see a created sucessfully message at the bottom of your screen:

   

7. Now that your database is created, you can populate it with tables and data using your normal methods such as command line mysql, phpMyAdmin, or Perl/PHP code. Whatever method you use, you'll need some basic settings.

Deleting a MySQL database from your site

1. These instructions assume you have already logged in to Database Manager using one of the supported web browsers.

2. Warning: the following steps will delete your database and all data in the database. Please be certain you want to do this before proceeding.

3. You will see a menu on the left with Drop as one of the options. Click on the word Drop:

   

4. A new menu should appear to the right with Database as one of the options. Click once on the word Database.

   

5. A list of your databases will then appear to the right:

   

6. Click once on the name of the database you wish to delete. You will be presented with a warning screen and a Run Query button.

   

   Click the Run Query button and when prompted with Are you sure? click OK.

Changing your MySQL password

1. These instructions assume you have already logged in to Database Manager using one of the supported web browsers.

2. Click on the Users tab.

3. Select your database username from the pulldown menu on the left by clicking on it once.

4. Warning: changing your password here will break any web pages on your site connecting to your database with the old password.

   To change your password, type the new password in the enter new password box at the right and put a check in the box that says Yes, I want to change the password for the selected user.

   

   Click the OK button and when prompted with Are you sure? click OK again.