Sandi Budic Sandi Budic - 1 month ago 31
MySQL Question

How to connect with PhpMyAdmin to the localhost via a Unix socket?

Can someone help with connecting to my web server?

In phpMyAdmin database is

Server: localhost:3306
when click on it I get:

Server: Localhost via UNIX socket
Server type: MySQL
Server version: 5.5.52-cll - MySQL Community Server (GPL)


So how I can connect on it without an address or an IP?

The PhpMyAdmin and the MySQL run on the same, non-local system.

Answer

Probably You wanted this:

$socket = '/var/run/mysqld.sock'; // or: /tmp/mysqld.sock
$db = new mysqli('localhost', 'username', 'password', "database", 3306, $socket);
// $db = mysql_connect('localhost:'.$socket, 'username', 'password');
Comments