# Fix: SQLSTATE[28000] [1045] Access denied - Session Error

## Problem

After updating session configuration, you're getting database access errors because `SESSION_DRIVER` is set to `database` but the database credentials are incorrect or the user lacks permissions.

## Immediate Fix (Choose One)

### Option 1: Switch to File-Based Sessions (Quickest Fix)

**Update your production `.env` file:**

```env
SESSION_DRIVER=file
```

**Then clear cache on your production server:**

```bash
php artisan config:clear
php artisan cache:clear
```

**Ensure storage directory is writable:**

```bash
chmod -R 775 storage/framework/sessions
```

This will immediately fix the error. File-based sessions work fine for single-server setups.

---

### Option 2: Fix Database Credentials (If You Want Database Sessions)

**1. Update your production `.env` file with correct credentials:**

```env
DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=your_actual_database_name
DB_USERNAME=sprovprs_sprovprs
DB_PASSWORD=your_correct_password_here

SESSION_DRIVER=database
```

**2. Grant database permissions (connect to MySQL):**

```sql
-- Grant permissions
GRANT ALL PRIVILEGES ON your_database_name.* TO 'sprovprs_sprovprs'@'localhost';
FLUSH PRIVILEGES;
```

**3. Create sessions table (if it doesn't exist):**

```bash
php artisan session:table
php artisan migrate
```

**4. Clear cache:**

```bash
php artisan config:clear
php artisan cache:clear
```

---

## Recommended Solution

**For production, use file-based sessions unless you have multiple servers:**

```env
SESSION_DRIVER=file
SESSION_LIFETIME=120
SESSION_EXPIRE_ON_CLOSE=false
SESSION_SECURE_COOKIE=true
```

File-based sessions are:

-   ✅ Simpler to set up
-   ✅ No database dependency
-   ✅ Work perfectly for single-server setups
-   ✅ Faster for small to medium traffic

Only use database sessions if:

-   You have multiple servers (load balancing)
-   You need to share sessions across servers
-   You have Redis available (Redis is better than database for sessions)

---

## After Making Changes

Always clear the config cache:

```bash
php artisan config:clear
php artisan cache:clear
```

Then test your application to ensure sessions work correctly.