Database Setup

Follow these steps to set up the SaasCart database using phpMyAdmin. You can choose to import dummy data for sample content or start with a clean, empty database.

Access phpMyAdmin

  1. Open phpMyAdmin: Go to http://localhost/phpmyadmin in your browser.
  2. Log In: Use root as the username and leave the password blank if not set. Click Go to log in.

Create a New Database

  1. Create Database: In phpMyAdmin, go to the Databases tab.
  2. Name Your Database: Enter saascart as the name or anything you wish.
  3. Confirm Creation: Click Create. The database saascart will now be listed on the left sidebar.

Import the Database File

With the saascart database created, you can now import the data.

  1. Go to Import: Click on the saascart database in the sidebar, then select the Import tab.
  2. Choose the Database File:
    • Dummy Data: To import sample data, select the saascart_dummy_data.sql file.
    • No Data: For a clean setup, select saascart_no_data.sql.
  3. Start Import: Click Go to begin the import. phpMyAdmin will add either the dummy data or only the structure, depending on your selection.

Final Steps

Check Connection: Ensure that DB_DATABASE=saascart, DB_USERNAME=root, and DB_PASSWORD in your .env file match your phpMyAdmin settings.

Your SaasCart database setup is complete!