                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
<?php
$configs = [
    ['host' => '127.0.0.1', 'user' => 'root', 'pass' => '', 'db' => 'event_management'],
    ['host' => '127.0.0.1', 'user' => 'root', 'pass' => 'root', 'db' => 'event_management'],
    ['host' => 'localhost', 'user' => 'root', 'pass' => '', 'db' => 'event_management'],
    ['host' => 'localhost', 'user' => 'root', 'pass' => 'root', 'db' => 'event_management'],
    ['host' => '127.0.0.1:3306', 'user' => 'root', 'pass' => 'root', 'db' => 'event_management'],
];

foreach ($configs as $cfg) {
    try {
        echo "Testing {$cfg['user']}@{$cfg['host']} ... ";
        $conn = @new mysqli($cfg['host'], $cfg['user'], $cfg['pass']);
        if ($conn->connect_error) {
            echo "Failed: " . $conn->connect_error . "\n";
        } else {
            echo "Success!\nAvailable databases:\n";
            $res = $conn->query("SHOW DATABASES");
            while ($row = $res->fetch_row()) {
                echo "  - " . $row[0] . "\n";
            }
            $conn->close();
            break;
        }
    } catch (Exception $e) {
        echo "Error: " . $e->getMessage() . "\n";
    }
}
?>