Creating a new Database
Your guide to pathway services
Revision as of 11:49, 3 February 2014 by Pathway Admin (Talk | contribs)
After you have created database users you can create a database.
To create a new database:
- Go to the Sites tab.
- Locate the Databases section, click Databases.
- Click Add new Database.
When you arrive at the Databases page:
- From the Site dropdown list, select the website that you would like your database to connect to.
- From the Type dropdown list, select the type of database you would like to use. (Currently Hostpath only supports MySQL.)
- In the Database name field, enter the name for your database. (The database name will be prefixed with a client ID. If your client id is c12 and your database name is mydb, the full database name will be c12mydb. Please ensure that the database name you enter does not exceed 12 characters. MySQL does not support longer database names.)
- From the Database user dropdown list, select a database user.
- (Optional) From the Read-only database user dropdown list, select a database user that you would like to grant read-only access to for the database you are creating.