Skip to main content

MyWeb Tutorials: Database Creation

This article provides step-by-step instructions for creating a database in MyWeb (DirectAdmin) and a table in phpMyAdmin.

  • Login to MyWeb using your UWINID and password:
    https://www.myweb.cs.uwindsor.ca

  • From “Account Manager” menu, click on “Databases”


    image.png



  • In the “Create Database” section, click on “Advanced mode”

Fill in:

a.     Database Name  (example: projectdb)

b.    User name (can be the same as DB name)

c.     Password (generate or enter your own)

image.png



  • After creation, you will get a confirmation like the following (record these info)

image.png

  • To access the Database, you can use phpMyAdmin, you can access it either from the same page where you created the Database (top right)

image.png



or you can access phpMyAdmin from the left menu:

image.png


 

In the phpMyAdmin page, click on your newly created Database

image.png

  • You can create a table either using the “Create new table” wizard

image.png


Then define your fields/columns (as shown in the image below as an example)

image.png


Or you can create it using SQL command (the recommended method):

image.png


 Please refer to the following sites for additional information about SQL:

·        https://www.datacamp.com/tutorial/my-sql-tutorial

·        https://www.w3schools.com/MySQL

·        https://www.mysqltutorial.org

 

Back to top