# MySQL Database Setup for MSoft Secure Dashboard

To use an online MySQL database, please follow these steps:

### 1. Import Database Schema
Use the provided `database.sql` file to import the schema and seed data into your online MySQL database. You can do this via phpMyAdmin, MySQL Workbench, or the command line:

```bash
mysql -h YOUR_HOST -u YOUR_USERNAME -p YOUR_DATABASE < database.sql
```

### 2. Update .env File
Update the following lines in your `backend/.env` file with your online database credentials:

```env
DB_CONNECTION=mysql
DB_HOST=your-online-host.com
DB_PORT=3306
DB_DATABASE=your_database_name
DB_USERNAME=your_username
DB_PASSWORD=your_password
```

### 3. Verify Connection
Restart your Laravel server:
```bash
php artisan serve
```

### Credentials in SQL:
- **Admin**: `admin@msoft.com` / `password123`
- **Clerk**: `clerk@msoft.com` / `clerkpassword`