REDROOM

Create

Preview: quick_mysql_test.php Size: 2.21 KB

/home/ankaservis/.trash/quick_mysql_test.php

<?php
echo "<h1>🔍 Hızlı MySQL Bağlantı Testi</h1>";

// Farklı bağlantı ayarlarını test et
$configs = [
    ['localhost', 'root', '', ''],
    ['localhost', 'root', 'root', ''],
    ['127.0.0.1', 'root', '', ''],
    ['localhost', 'ankaservis', 'YeniSifre123', 'ankaservis']
];

foreach ($configs as $i => $config) {
    list($host, $user, $pass, $db) = $config;
    
    echo "<h3>Test " . ($i + 1) . ": $user@$host</h3>";
    
    $conn = @mysqli_connect($host, $user, $pass);
    
    if ($conn) {
        echo "<p style='color:green'>✅ Bağlantı başarılı!</p>";
        
        // Veritabanlarını listele
        $result = mysqli_query($conn, "SHOW DATABASES");
        echo "<p><strong>Veritabanları:</strong> ";
        while ($row = mysqli_fetch_assoc($result)) {
            echo $row['Database'] . " ";
        }
        echo "</p>";
        
        // Eğer belirli bir veritabanı varsa test et
        if ($db) {
            if (mysqli_select_db($conn, $db)) {
                echo "<p style='color:green'>✅ '$db' veritabanı seçildi</p>";
                
                // Tabloları göster
                $result = mysqli_query($conn, "SHOW TABLES");
                if ($result && mysqli_num_rows($result) > 0) {
                    echo "<p><strong>Tablolar:</strong> ";
                    while ($row = mysqli_fetch_array($result)) {
                        echo $row[0] . " ";
                    }
                    echo "</p>";
                } else {
                    echo "<p style='color:orange'>⚠️ Tablolar bulunamadı</p>";
                }
            } else {
                echo "<p style='color:red'>❌ '$db' veritabanı seçilemedi</p>";
            }
        }
        
        mysqli_close($conn);
        echo "<hr>";
        
    } else {
        echo "<p style='color:red'>❌ Bağlantı hatası: " . mysqli_connect_error() . "</p>";
        echo "<hr>";
    }
}

echo "<h2>📋 Önerilen Çözüm</h2>";
echo "<p>Eğer root bağlantısı çalışıyorsa, phpMyAdmin'de yukarıdaki SQL komutlarını çalıştırın.</p>";
?>

<style>
body { font-family: Arial, sans-serif; margin: 20px; }
hr { margin: 20px 0; }
</style>

Name	Size	Perms	Modified	Actions
.trash_restore	1.04 KB	lrw-------	2025-11-14 06:31:49	Edit Download recursive recursive
ankaservis.sql	33.24 KB	lrw-r--r--	2025-08-29 14:12:44	Edit Download recursive recursive
ankaservis.sql.1	33.24 KB	lrw-r--r--	2025-08-29 14:12:44	Edit Download recursive recursive
ankaserviscom.zip	33.46 MB	lrw-r--r--	2025-11-13 15:09:42	Edit Download recursive recursive
ankaserviscom2.rar	16.25 MB	lrw-r--r--	2025-11-13 12:29:23	Edit Download recursive recursive
ankaserviscom2.rar.1	16.25 MB	lrw-r--r--	2025-11-13 12:30:16	Edit Download recursive recursive
error_monitor.php	8.81 KB	lrw-r--r--	2025-08-29 14:25:54	Edit Download recursive recursive
performance_test.php	2.53 KB	lrw-r--r--	2025-08-30 02:18:32	Edit Download recursive recursive
php_config_test.php	1.05 KB	lrw-r--r--	2025-08-29 13:29:28	Edit Download recursive recursive
quick_mysql_test.php	2.21 KB	lrw-r--r--	2025-08-29 13:33:36	Edit Download recursive recursive
system_test.php	3.61 KB	lrw-r--r--	2025-08-29 13:31:38	Edit Download recursive recursive
test_ayarlar.php	703 B	lrw-r--r--	2025-08-30 03:31:04	Edit Download recursive recursive
test_php74.php	3.23 KB	lrw-r--r--	2025-08-29 13:29:04	Edit Download recursive recursive
watch_errors.ps1	1.46 KB	lrw-r--r--	2025-08-29 13:01:24	Edit Download recursive recursive
wrapper_debug.php	2.82 KB	lrw-r--r--	2025-08-29 13:35:36	Edit Download recursive recursive

Directory Contents