1. NETWORK / HOST LAYER: ● REACHING MYSQL HOST
2. APPLICATION / AUTH LAYER: ● AUTHENTICATED & VERIFIED
PHP 8.2.32
Both Host Transport and Application Layer Handshakes Succeeded
This tool isolates whether connection issues originate at the Network/Socket Layer (TCP port closed or missing Unix socket file) or the Application Layer (incorrect MySQL username/password `1045`, missing database `1049`, or ungranted database privileges `1044`) across both mysqli_connect() and new PDO() drivers.
Test Custom Connection Parameters
1. Low-Level MySQL Host & Socket Transport Probes
TCP/IP Loopback Probe (127.0.0.1:3306)
REACHABLE • 0.13ms
TCP Port 3306 is OPEN and responding (Server Greeting: 5.5.5-10.11.18-MariaDB d7 Usf)
Unix Domain Socket File Probe (localhost)
REACHABLE • 0.1ms
Active Unix socket verified at: /var/lib/mysql/mysql.sock
2. mysqli_connect() & PDO Connection String Test Matrix
Detailed execution results for every driver and connection string permutation.
✓ CONNECTED • CONNECTED_OK
MySQLi Extension (mysqli_connect)
|
Host: localhost
Latency: 0.19ms
• SQLSTATE: 00000
• Errno: 0
Connection String: mysqli_connect('localhost', 'oneanonnet_db', '***', 'oneanonnet_db', 3306)
Layer Diagnosis: Host Reached & Application Authenticated
Server / Host Info: 10.11.18-MariaDB | Localhost via UNIX socket (21 tables)
Output / Explanation: None — mysqli_connect() handshake succeeded. — Both the transport socket and MySQL authentication/schema selection succeeded.
✓ CONNECTED • CONNECTED_OK
MySQLi Extension (mysqli_connect)
|
Host: 127.0.0.1
Latency: 0.2ms
• SQLSTATE: 00000
• Errno: 0
Connection String: mysqli_connect('127.0.0.1', 'oneanonnet_db', '***', 'oneanonnet_db', 3306)
Layer Diagnosis: Host Reached & Application Authenticated
Server / Host Info: 10.11.18-MariaDB | 127.0.0.1 via TCP/IP (21 tables)
Output / Explanation: None — mysqli_connect() handshake succeeded. — Both the transport socket and MySQL authentication/schema selection succeeded.
✓ CONNECTED • CONNECTED_OK
PDO MySQL Driver (new PDO)
|
Host: localhost
Latency: 0.27ms
• SQLSTATE: 00000
• Errno: 0
Connection String: mysql:host=localhost;port=3306;dbname=oneanonnet_db;charset=utf8mb4
Layer Diagnosis: Host Reached & Application Authenticated
Server / Host Info: 10.11.18-MariaDB | Localhost via UNIX socket (21 tables)
Output / Explanation: None — PDO DSN handshake and schema query succeeded. — Both the transport socket and MySQL authentication/schema selection succeeded.
✓ CONNECTED • CONNECTED_OK
PDO MySQL Driver (new PDO)
|
Host: 127.0.0.1
Latency: 0.23ms
• SQLSTATE: 00000
• Errno: 0
Connection String: mysql:host=127.0.0.1;port=3306;dbname=oneanonnet_db;charset=utf8mb4
Layer Diagnosis: Host Reached & Application Authenticated
Server / Host Info: 10.11.18-MariaDB | 127.0.0.1 via TCP/IP (21 tables)
Output / Explanation: None — PDO DSN handshake and schema query succeeded. — Both the transport socket and MySQL authentication/schema selection succeeded.
✓ CONNECTED • CONNECTED_OK
PDO MySQL Driver (new PDO)
|
Host: unix_socket:/var/lib/mysql/mysql.sock
Latency: 0.16ms
• SQLSTATE: 00000
• Errno: 0
Connection String: mysql:unix_socket=/var/lib/mysql/mysql.sock;dbname=oneanonnet_db;charset=utf8mb4
Layer Diagnosis: Host Reached & Application Authenticated
Server / Host Info: 10.11.18-MariaDB | Localhost via UNIX socket (21 tables)
Output / Explanation: None — PDO DSN handshake and schema query succeeded. — Both the transport socket and MySQL authentication/schema selection succeeded.