69 | | a. Log in to your cPanel. |
70 | | |
71 | | b. Go to '''MySQL Databases'''. |
72 | | |
73 | | c. Create a database user: |
74 | | |
75 | | 1. Choose a username for Dolphin (for example "dolphin") and enter it in the Username field. |
76 | | |
77 | | 2. Choose a hard-to-guess password (ideally containing a combination of upper- and lower-case letters, numbers, and symbols), and input it into the Password field. |
78 | | |
79 | | 3. Click '''Create User'''. |
80 | | |
81 | | d. Create a Dolphin database and add the user to it: |
82 | | |
83 | | 1. Choose a name for your Dolphin database (for example "dolphin" or "community"), input it in the New Database field and click '''Create Database'''. |
84 | | |
85 | | 2. Under '''Add Users To Your Database''', select your Dolphin username from the User dropdown list, then select your Dolphin database from the Database dropdown list. Make sure ''ALL'' is checked under Privileges and click '''Add User To Database'''. |
86 | | |
87 | | e. When you return to the main MySQL Account Maintenance screen, cPanel will list information about the database you just created. You should see the username you just added to the database (with ALL PRIVILEGES), as well as a few sample Connection Strings for you to use in Perl or PHP scripts to connect to the database. The PHP code will have the following format: |
| 69 | a. Log in to your cPanel. |
| 70 | |
| 71 | b. Go to '''MySQL Databases'''. |
| 72 | |
| 73 | c. Create a database user: |
| 74 | |
| 75 | 1. Choose a username for Dolphin (for example "dolphin") and enter it in the Username field. |
| 76 | |
| 77 | 2. Choose a hard-to-guess password (ideally containing a combination of upper- and lower-case letters, numbers, and symbols), and input it into the Password field. |
| 78 | |
| 79 | 3. Click '''Create User'''. |
| 80 | |
| 81 | d. Create a Dolphin database and add the user to it: |
| 82 | |
| 83 | 1. Choose a name for your Dolphin database (for example "dolphin" or "community"), input it in the New Database field and click '''Create Database'''. |
| 84 | |
| 85 | 2. Under '''Add Users To Your Database''', select your Dolphin username from the User dropdown list, then select your Dolphin database from the Database dropdown list. Make sure ''ALL'' is checked under Privileges and click '''Add User To Database'''. |
| 86 | |
| 87 | e. When you return to the main MySQL Account Maintenance screen, cPanel will list information about the database you just created. You should see the username you just added to the database (with ALL PRIVILEGES), as well as a few sample Connection Strings for you to use in Perl or PHP scripts to connect to the database. The PHP code will have the following format: |
102 | | a. Create a database: |
103 | | |
104 | | 1. Choose a name for your Dolphin database (for example "dolphin" or "mycommunity"), enter it in the ''Create new database field'' and click '''Create'''. |
105 | | |
106 | | 2. Click the '''Home''' icon in the upper left to return to the main page, then click '''Privileges''' and follow these steps to create a user: |
107 | | |
108 | | 2a. Click '''Add a new User'''. |
109 | | |
110 | | 2b. Chose a user name for Dolphin (for example "dolphin") and enter it in the User name field (make sure "Use text field:" is selected from the dropdown list). |
111 | | |
112 | | 2c. Leave the ''Host'' field blank. |
113 | | |
114 | | 2d. Choose a difficult-to-guess password (ideally containing a combination of upper- and lower-case letters, numbers, and symbols), and enter it in the ''Password'' field (make sure "Use text field:" is selected from the dropdown list.) Re-enter the password in the Re-type field. |
115 | | |
116 | | 3. Write down the username and password you have chosen. |
| 102 | a. Create a database: |
| 103 | |
| 104 | 1. Choose a name for your Dolphin database (for example "dolphin" or "mycommunity"), enter it in the ''Create new database field'' and click '''Create'''. |
| 105 | |
| 106 | 2. Click the '''Home''' icon in the upper left to return to the main page, then click '''Privileges''' and follow these steps to create a user: |
| 107 | |
| 108 | 2a. Click '''Add a new User'''. |
| 109 | |
| 110 | 2b. Chose a user name for Dolphin (for example "dolphin") and enter it in the User name field (make sure "Use text field:" is selected from the dropdown list). |
| 111 | |
| 112 | 2c. Leave the ''Host'' field blank. |
| 113 | |
| 114 | 2d. Choose a difficult-to-guess password (ideally containing a combination of upper- and lower-case letters, numbers, and symbols), and enter it in the ''Password'' field (make sure "Use text field:" is selected from the dropdown list.) Re-enter the password in the Re-type field. |
| 115 | |
| 116 | 3. Write down the username and password you have chosen. |
118 | | 4. Leave the default values for the '''Global privileges''' section. |
119 | | |
120 | | 5. Click '''Go'''. |
121 | | |
122 | | b. Return to the '''Privileges''' screen and click the '''Edit privileges''' icon on the user you've just created for Dolphin. In the Database-specific privileges section, select the database you've just created for Dolphin from the '''Add privileges''' to the following database dropdown list. The page will refresh with privileges for that database. Click '''Check All''' to select all privileges, and click '''Go'''. |
123 | | |
124 | | c. On the resulting page, make note of the host name listed after "Server:" at the top of the page. (This will usually be ''localhost''.) |
| 118 | 4. Leave the default values for the '''Global privileges''' section. |
| 119 | |
| 120 | 5. Click '''Go'''. |
| 121 | |
| 122 | b. Return to the '''Privileges''' screen and click the '''Edit privileges''' icon on the user you've just created for Dolphin. In the Database-specific privileges section, select the database you've just created for Dolphin from the '''Add privileges''' to the following database dropdown list. The page will refresh with privileges for that database. Click '''Check All''' to select all privileges, and click '''Go'''. |
| 123 | |
| 124 | c. On the resulting page, make note of the host name listed after "Server:" at the top of the page. (This will usually be ''localhost''.) |