102 | | 1. 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 tp create a user: |
107 | | |
108 | | 1. Click Add a new User. |
109 | | |
110 | | 2. 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 | | 3. Leave the Host field blank. |
113 | | |
114 | | 4. 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. |
| 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. |
118 | | 4. Leave the default values for the Global privileges section. |
119 | | |
120 | | 5. Click Go. |
121 | | |
122 | | 2. 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 | | 3. On the resulting page, make note of the host name listed after Server: at the top of the page. (This will usually be ''localhost''.) |
125 | | |
126 | | |
127 | | '''Using MySQL Client''' |
| 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''.) |
| 125 | |
| 126 | |
| 127 | === Using MySQL Client === |