Difference between revisions of "Creating a new Database"
Your guide to pathway services
| Line 18: | Line 18: | ||
#From the '''Type''' dropdown list, select the type of database you would like to use. (Currently Hostpath only supports MySQL.) | #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.) | #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. | + | #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. | #''(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.) | ||
| + | # | ||
Revision as of 11:52, 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.)
