#!/usr/bin/env php

========================================
  Database Connection Diagnostic
========================================

✓ .env file found

✓ Environment variables loaded

Current Database Configuration:
----------------------------------------
Driver:   mysql
Host:     localhost
Port:     3306
Database: admin254_invento
Username: admin254_invento
Password: ********
----------------------------------------

Testing database connection...
❌ DATABASE CONNECTION FAILED!

Error: SQLSTATE[HY000] [1045] Access denied for user 'admin254_invento'@'localhost' (using password: YES)

Common solutions:
----------------------------------------
1. Check if MySQL service is running:
   - Windows: services.msc -> MySQL
   - Linux: sudo systemctl status mysql

2. Verify database credentials in .env file

3. Make sure database 'admin254_invento' exists:
   mysql -u root -p
   CREATE DATABASE admin254_invento;

4. Check user permissions:
   GRANT ALL ON admin254_invento.* TO 'admin254_invento'@'localhost';
   FLUSH PRIVILEGES;