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 | 1. Log in to your cPanel. |
| 70 | |
| 71 | 2. Go to '''MySQL Databases'''. |
| 72 | |
| 73 | 3. Create a database user: |
| 74 | |
| 75 | a. Choose a username for Dolphin (for example "dolphin") and enter it in the Username field. |
| 76 | |
| 77 | b. 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 | c. Click '''Create User'''. |
| 80 | |
| 81 | 4. Create a Dolphin database and add the user to it: |
| 82 | |
| 83 | a. 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 | b. 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 | 5. 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: |