Difference between revisions of "Creating a new Database"
Your guide to pathway services
| Line 21: | Line 21: | ||
#''(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. | #''(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. | ||
#From the '''Database charset''' dropdown list, select the character set for the database. UTF-8 is recommended for most databases. | #From the '''Database charset''' dropdown list, select the character set for the database. UTF-8 is recommended for most databases. | ||
| − | #Select the '''Remote Access checkbox if you would like to restrict access to the database. (You will need to explicitly specify the IPs that have access to this box, see the '''Remote access IPs '''step below.) | + | #Select the '''Remote Access '''checkbox if you would like to restrict access to the database. (You will need to explicitly specify the IPs that have access to this box, see the '''Remote access IPs '''step below.) |
# | # | ||
Revision as of 11:53, 3 February 2014
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.
- From the Database charset dropdown list, select the character set for the database. UTF-8 is recommended for most databases.
- Select the Remote Access checkbox if you would like to restrict access to the database. (You will need to explicitly specify the IPs that have access to this box, see the Remote access IPs step below.)
