Setting up MySQL database for Email Processing Pipeline...
Host: localhost:3306
Database: tvccom_pipe
User: tvccom_pipe

✓ Connected to MySQL server
✓ Database 'tvccom_pipe' created/verified
✓ Connected to database 'tvccom_pipe'
✓ Executing database schema...
Warning: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_email_logs_sender'
Warning: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_email_logs_recipient'
Warning: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_email_logs_status'
Warning: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_email_logs_pipe1_status'
Warning: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_sessions_session_id'
Warning: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_sessions_expires'
✓ Database schema executed successfully
✓ Created tables: dashboard_users, email_logs, login_attempts, system_stats, user_sessions
✓ Email logs table accessible (current records: 10)
✓ Dashboard users table accessible (current users: 1)

🎉 MySQL database setup completed successfully!

Next steps:
1. Test the web dashboard: http://your-server/dashboard.php
2. Default admin login: admin / password
3. Run health check: php health_check.php
4. Set up monitoring: ./health_monitor.sh