37 lines
1004 B
PHP
37 lines
1004 B
PHP
<?php
|
|
$sockets = [
|
|
'/tmp/mysql.sock',
|
|
'/tmp/mysql5.sock',
|
|
'/var/run/mysqld/mysqld.sock',
|
|
'/Users/dvapp/Library/Application Support/Herd/config/run/mysql.sock',
|
|
];
|
|
|
|
$ports = [3306, 3307, 3308, 8889];
|
|
|
|
echo "Testing Ports:\n";
|
|
foreach ($ports as $port) {
|
|
try {
|
|
$pdo = new PDO("mysql:host=127.0.0.1;port=$port", "root", "");
|
|
echo "SUCCESS on Port $port!\n";
|
|
$pdo = null;
|
|
} catch (PDOException $e) {
|
|
echo "FAIL on Port $port: " . $e->getMessage() . "\n";
|
|
}
|
|
}
|
|
|
|
echo "\nTesting Sockets:\n";
|
|
foreach ($sockets as $socket) {
|
|
if (file_exists($socket)) {
|
|
echo "Socket file exists: $socket\n";
|
|
try {
|
|
$pdo = new PDO("mysql:unix_socket=$socket", "root", "");
|
|
echo "SUCCESS on Socket $socket!\n";
|
|
$pdo = null;
|
|
} catch (PDOException $e) {
|
|
echo "FAIL on Socket $socket: " . $e->getMessage() . "\n";
|
|
}
|
|
} else {
|
|
echo "Socket file does NOT exist: $socket\n";
|
|
}
|
|
}
|