# MyWeb Tutorials: Database Creation

<span style="font-size: 14.0pt; line-height: 107%;">This article provides step-by-step instructions for creating a database in MyWeb (DirectAdmin) and a table in phpMyAdmin.</span>

- <span style="font-size: 14.0pt; line-height: 107%;">Login to MyWeb using your UWINID and password:   
    [https://www.myweb.cs.uwindsor.ca](https://www.myweb.cs.uwindsor.ca)  
      
    </span>
- <span style="font-size: 14.0pt; line-height: 107%;">From “Account Manager” menu, click on “Databases”  
    </span>  
    [![image.png](https://help.cs.uwindsor.ca/uploads/images/gallery/2026-02/scaled-1680-/oeIimage.png)](https://help.cs.uwindsor.ca/uploads/images/gallery/2026-02/oeIimage.png)
    
    <span style="font-size: 14.0pt; line-height: 107%;">  
      
    </span>
- <span style="font-size: 14pt;">In the “Create Database” section, click on “Advanced mode”</span>

<span style="font-size: 14.0pt; line-height: 107%;">Fill in:</span>

<span style="font-size: 14.0pt; line-height: 107%; mso-bidi-font-family: Aptos; mso-bidi-theme-font: minor-latin;"><span style="mso-list: Ignore;">a.<span style="font: 7.0pt 'Times New Roman';"> </span></span></span><span style="font-size: 14.0pt; line-height: 107%;">Database Name <span style="mso-spacerun: yes;"> </span>*(example: projectdb)*</span>

<span style="font-size: 14.0pt; line-height: 107%; mso-bidi-font-family: Aptos; mso-bidi-theme-font: minor-latin;"><span style="mso-list: Ignore;">b.<span style="font: 7.0pt 'Times New Roman';"> </span></span></span><span style="font-size: 14.0pt; line-height: 107%;">User name *(can be the same as DB name)*</span>

<span style="font-size: 14.0pt; line-height: 107%; mso-bidi-font-family: Aptos; mso-bidi-theme-font: minor-latin;"><span style="mso-list: Ignore;">c.<span style="font: 7.0pt 'Times New Roman';"> </span></span></span><span style="font-size: 14.0pt; line-height: 107%;">Password *(generate or enter your own)*</span>

[![image.png](https://help.cs.uwindsor.ca/uploads/images/gallery/2026-02/scaled-1680-/nyVimage.png)](https://help.cs.uwindsor.ca/uploads/images/gallery/2026-02/nyVimage.png)

<span style="font-size: 14.0pt; line-height: 107%;">  
  
</span>

- <span style="font-size: 14.0pt; line-height: 107%;">After creation, you will get a confirmation like the following (record these info)</span>

[![image.png](https://help.cs.uwindsor.ca/uploads/images/gallery/2026-02/scaled-1680-/YqAimage.png)](https://help.cs.uwindsor.ca/uploads/images/gallery/2026-02/YqAimage.png)

- <span style="font-size: 14.0pt; line-height: 107%;">To access the Database, you can use phpMyAdmin, you can access it either from the same page where you created the Database (top right)</span>

[![image.png](https://help.cs.uwindsor.ca/uploads/images/gallery/2026-02/scaled-1680-/R7Vimage.png)](https://help.cs.uwindsor.ca/uploads/images/gallery/2026-02/R7Vimage.png)

<span style="font-size: 14.0pt; line-height: 107%;">  
  
or you can access phpMyAdmin from the left menu:</span>

[![image.png](https://help.cs.uwindsor.ca/uploads/images/gallery/2026-02/scaled-1680-/1Loimage.png)](https://help.cs.uwindsor.ca/uploads/images/gallery/2026-02/1Loimage.png)

<span style="font-size: 14.0pt; line-height: 107%; mso-no-proof: yes;">  
</span>

<span style="font-size: 14.0pt; line-height: 107%;"> </span>

<span style="font-size: 14.0pt; line-height: 107%;">In the phpMyAdmin page, click on your newly created Database</span>

[![image.png](https://help.cs.uwindsor.ca/uploads/images/gallery/2026-02/scaled-1680-/Tcaimage.png)](https://help.cs.uwindsor.ca/uploads/images/gallery/2026-02/Tcaimage.png)

- <span style="font-size: 14.0pt; line-height: 107%;">You can create a table either using the “Create new table” wizard </span>

[![image.png](https://help.cs.uwindsor.ca/uploads/images/gallery/2026-02/scaled-1680-/am4image.png)](https://help.cs.uwindsor.ca/uploads/images/gallery/2026-02/am4image.png)

<span style="font-size: 14.0pt; line-height: 107%; mso-no-proof: yes;">  
</span>

<span style="font-size: 14.0pt; line-height: 107%;">Then define your fields/columns (as shown in the image below as an example)</span>

[![image.png](https://help.cs.uwindsor.ca/uploads/images/gallery/2026-02/scaled-1680-/oC6image.png)](https://help.cs.uwindsor.ca/uploads/images/gallery/2026-02/oC6image.png)

<span style="font-size: 14.0pt; line-height: 107%; mso-no-proof: yes;">  
</span>

<span style="font-size: 14.0pt; line-height: 107%;">Or you can create it using SQL command (the recommended method):</span>

[![image.png](https://help.cs.uwindsor.ca/uploads/images/gallery/2026-02/scaled-1680-/1tzimage.png)](https://help.cs.uwindsor.ca/uploads/images/gallery/2026-02/1tzimage.png)

<span style="font-size: 14.0pt; line-height: 107%; mso-no-proof: yes;">  
</span>

<span style="font-size: 14.0pt; line-height: 107%;"> </span><span style="font-size: 14.0pt; line-height: 107%;">Please refer to the following sites for additional information about SQL:</span>

<span style="font-size: 14.0pt; line-height: 107%; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt 'Times New Roman';"> </span></span></span><span style="font-size: 14.0pt; line-height: 107%;">[https://www.datacamp.com/tutorial/my-sql-tutorial](https://www.datacamp.com/tutorial/my-sql-tutorial)</span>

<span style="font-size: 14.0pt; line-height: 107%; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt 'Times New Roman';"> </span></span></span><span style="font-size: 14.0pt; line-height: 107%;">[https://www.w3schools.com/MySQL](https://www.w3schools.com/MySQL)</span>

<span style="font-size: 14.0pt; line-height: 107%; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt 'Times New Roman';"> </span></span></span><span style="font-size: 14.0pt; line-height: 107%;">[https://www.mysqltutorial.org](https://www.mysqltutorial.org)</span>

<span style="font-size: 14.0pt; line-height: 107%;"></span>