Creating a new Database - Revision history

Pwadmin at 17:47, 4 November 2016

2016-11-04T17:47:40Z

Pwadmin at 14:08, 10 March 2014

2014-03-10T14:08:27Z

Pwadmin: Protected "Creating a new Database" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite)) [cascading]

2014-02-18T14:18:16Z

Protected "Creating a new Database" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite)) [cascading]

Pwadmin at 15:07, 14 February 2014

2014-02-14T15:07:17Z

Pwadmin at 04:19, 13 February 2014

2014-02-13T04:19:48Z

Pwadmin at 16:35, 5 February 2014

2014-02-05T16:35:51Z

Pwadmin at 16:33, 5 February 2014

2014-02-05T16:33:02Z

Pwadmin at 14:46, 4 February 2014

2014-02-04T14:46:43Z

Pwadmin at 18:10, 3 February 2014

2014-02-03T18:10:03Z

Pwadmin at 17:00, 3 February 2014

2014-02-03T17:00:50Z

@@ Line 4: / Line 4: @@
 To create a new database:
 #Click on the '''Sites''' tab.
@@ Line 15: / Line 13: @@
 '''[[File:Creating new databases2.PNG|none|Creating new databases2.PNG]]'''
 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>
@@ Line 35: / Line 27: @@
 <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.

@@ Line 25: / Line 25: @@
 <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>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>
@@ Line 31: / Line 31: @@
 <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>'''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>

@@ Line 7: / Line 7: @@
-#Go to the '''Sites''' tab.
+#Click on the '''Sites''' tab.
 #Locate the '''Databases '''section.
 #Click '''Databases.'''

@@ Line 23: / Line 23: @@
+<ol start="5">
-#From the '''Site '''dropdown list, select the website that you would like your database to connect to.
+<li>From the '''Site '''dropdown list, select the website that you would like your database to connect to.</li>
-#From the '''Type''' dropdown list, select the type of database you would like to use. (Currently Hostpath only supports MySQL.)
+<li>From the '''Type''' dropdown list, select the type of database you would like to use. (Currently Hostpath only supports MySQL.)</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>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>
-#From the '''Database user '''dropdown list, select a database user.
+<li>From the '''Database user '''dropdown list, select a database user.</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>''(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>
-#From the '''Database charset''' dropdown list, select the character set for the database. (UTF-8 is recommended for most databases.)
+<li>From the '''Database charset''' dropdown list, select the character set for the database. (UTF-8 is recommended for most databases.)</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>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>
-#'''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>'''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>
-#Select the '''Active '''checkbox to activate the database. To deactivate the database unselect the checkbox.
+<li>Select the '''Active '''checkbox to activate the database. To deactivate the database unselect the checkbox.</li>
-#Click '''Save.'''
+<li>Click '''Save.'''</li>

@@ Line 8: / Line 8: @@
 #Go to the '''Sites''' tab.
-#Locate the '''Databases '''section, then click '''Databases.'''
+#Locate the '''Databases '''section.
 #Click '''Add new Database.'''

@@ Line 32: / Line 32: @@
 #'''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.
 #Select the '''Active '''checkbox to activate the database. To deactivate the database unselect the checkbox.
-#Click '''Save '''to confirm your changes.
+#Click '''Save.'''

← Older revision		Revision as of 18:10, 3 February 2014
Line 32:		Line 32:
	#'''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.		#'''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.
	#Select the '''Active '''checkbox to activate the database. To deactivate the database unselect the checkbox.		#Select the '''Active '''checkbox to activate the database. To deactivate the database unselect the checkbox.
		+	#Click '''Save '''to confirm your changes.

@@ Line 1: / Line 1: @@
 After you have created database users you can create a database.
 To create a new database:
@@ Line 12: / Line 14: @@
 '''[[File:Creating new databases2.PNG|none|Creating new databases2.PNG]]'''