Login Login

Difference between revisions of "Creating a new Database"

Your guide to pathway services

Jump to: navigation, search
 
(13 intermediate revisions by one user not shown)
Line 1: Line 1:
 
After you have created database users you can create a database.
 
After you have created database users you can create a database.
 +
 +
  
 
To create a new database:
 
To create a new database:
  
#Go to the '''Sites''' tab.
+
#Click on the '''Sites''' tab.
#Locate the '''Databases '''section, click '''Databases.'''
+
#Locate the '''Databases '''section.
 +
#Click '''Databases.'''
 
#Click '''Add new Database.'''
 
#Click '''Add new Database.'''
  
Line 12: Line 15:
  
 
When you arrive at the '''Databases '''page:
 
When you arrive at the '''Databases '''page:
 +
<ol start="5">
 +
<li>From the '''Site '''dropdown list, select the website that you would like your database to connect to.</li>
 +
<li>From the '''Type''' dropdown list, select the type of database you would like to use. (Currently HostPath only supports MySQL.)</li>
 +
<li>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.)</li>
 +
<li>From the '''Database user '''dropdown list, select a database user.</li>
 +
<li>''(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.</li>
 +
<li>From the '''Database charset''' dropdown list, select the character set for the database. (UTF-8 is recommended for most databases.)</li>
 +
<li>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.)</li>
 +
<li>'''Remote Access IPs '''restricts host access to the database by IPs. <u>We recommend you leave this field blank.</u> This field will suggest a list of IPs available on HostPath, use IPs from the drop-down list only if you know your web-server IP.</li>
 +
<li>Select the '''Active '''checkbox to activate the database. To deactivate the database unselect the checkbox.</li>
 +
<li>Click '''Save.'''</li>
 +
</ol>
 +
 +
'''NOTE:&nbsp; '''If you have access to multiple database servers you will have the option to choose which server you would like to connect your database to.
  
  
  
#From the '''Site '''dropdown list, select the website that you would like your database to connect to.
+
[[File:Creating new databases1.png|none|Creating new databases1.png]]
#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.)
+
#
+

Latest revision as of 12:47, 4 November 2016

After you have created database users you can create a database.


To create a new database:

  1. Click on the Sites tab.
  2. Locate the Databases section.
  3. Click Databases.
  4. Click Add new Database.


Creating new databases2.PNG

When you arrive at the Databases page:

  1. From the Site dropdown list, select the website that you would like your database to connect to.
  2. From the Type dropdown list, select the type of database you would like to use. (Currently HostPath only supports MySQL.)
  3. 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.)
  4. From the Database user dropdown list, select a database user.
  5. (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.
  6. From the Database charset dropdown list, select the character set for the database. (UTF-8 is recommended for most databases.)
  7. 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.)
  8. Remote Access IPs restricts host access to the database by IPs. We recommend you leave this field blank. This field will suggest a list of IPs available on HostPath, use IPs from the drop-down list only if you know your web-server IP.
  9. Select the Active checkbox to activate the database. To deactivate the database unselect the checkbox.
  10. Click Save.

NOTE:  If you have access to multiple database servers you will have the option to choose which server you would like to connect your database to.


Creating new databases1.png