60 | | |
61 | | == Step 2: Create a Database and a User == |
62 | | |
63 | | '''Using CPanel''' |
64 | | |
65 | | If your hosting provider has cPanel, you can follow these instructions to create your Dolphin database and user. |
66 | | |
67 | | 1. Log in to your cPanel. |
68 | | |
69 | | 2. Click MySQL Databases. |
70 | | |
71 | | 3. Create a database user: |
| 61 | ---- |
| 62 | |
| 63 | == Part 2: Create a Database and a User == |
| 64 | |
| 65 | Create a database for Dolphin on your web server, as well as a MySQL user who will have all privileges for accessing and modifying it. There're at three ways to do it: |
| 66 | |
| 67 | === Using cPanel === |
| 68 | |
| 69 | a. Log in to your cPanel. |
| 70 | |
| 71 | b. Go to '''MySQL Databases'''. |
| 72 | |
| 73 | c. Create a database user: |
75 | | 2. Choose a difficult-to-guess password (ideally containing a combination of upper- and lower-case letters, numbers, and symbols), and input it into the Password field. |
76 | | |
77 | | 3. Click Create user. |
78 | | |
79 | | 4. Create a Dolphin database and add the user to it: |
80 | | |
81 | | 1. Choose a name for your Dolphin database (for example "dolphin" or "community"), input it in the New Database field and click Create Database. |
82 | | |
83 | | 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, then click Add User To Database. |
84 | | |
85 | | 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: |
| 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: |